limit of 4096MB - social.msdn.microsoft.com
Nov 12, 2013 · little OT, in this context... anyway, SQLExpress installs by default without management tools but SqlCMD.exe and oSql.exe, 2 command line tools.. if you like to manage your instance with …
How to create candidate and super key? - social.msdn.microsoft.com
Jun 10, 2015 · Both candidate keys and super keys are defined in SQL Server as either primary key constraints, unique key constraints, or unique indexes. They are functionally the same except that …
Remove HTML Tags Using SSIS Derived Column Expression
Aug 2, 2016 · In addition to Arthur mentioned, you could also create a user defined function for removing the HTML Tags in SQL Server, then call the user defined function in Execute SQL Task. If the HTML …
How to check if windows cluster has ben set up or not??
Sep 12, 2011 · How to check if Windows clustering services has been enabled/configured in windows 2008??... (Before installation of SQL Cluster)... Harry Thursday, September 1, 2011 7:27 PM
How can you sort query filenames within a ssmssqlproj project file?
Apr 4, 2014 · The file for my project (SQL Main) is located in "My Documents\SQL Server Management Studio\Projects\SQL Main\SQL Main\SQL Main.ssmssqlproj". Its just an xml file.
Could not establish trust relationship for the SSL/TLS secure channel ...
Apr 2, 2012 · start-->program files-->microsoft sql server--> configurtion tools-->reporting server configuration. Inreport server virtual directory --> uncheck the require secure socket layer (ssl) …
SVG in SSRS 2010 / 2012 - social.msdn.microsoft.com
Jul 4, 2013 · Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and …
An INSERT EXEC statement cannot be nested.
Oct 16, 2009 · But its necessary that the fields have same or implicit convertable types, all fields of the SP are covered and in the same order; otherwise address the fields by its name like INSERT INTO …
Select distinct with ntext fields - social.msdn.microsoft.com
Jul 9, 2007 · If you use Sql Server 2005 you can use NVARCHAR (MAX) almost simular to the NTEXT (new feature). NTEXT/TEXT wont allow any string manipulation (including comparision). So this new …
How to get the Date/Time of a given country using GetUTCDate?
Oct 7, 2013 · If I have a SQL Server instance in the EST timezone, but want to get the time and date in another country or timezone, how can I use GetUTCDate?