You searched for the word(s):
Showing page 1 of 185 (1,848 total posts)
< 1 second(s)
Wow, what compelling arguments. You might lose data integrity and need to fall back on a "known" identity value. Not having an identity column is incompetent and lazy. *sigh*
@jon I'm not quite sure how the code in the post is failing you, but I can see at least two ways your new code could go wrong:
(1) INFORMATION_SCHEMA only holds the first 4,000 characters
(2) PRINT has an 8K limit
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon.
SQL Server 2012 Service Pack 1 Cumulative Update #13
13 fixes (10 public)
Relevant for Service Pack 1 only ...
Vikas, your clients should be patched to >= version of the highest server you have to manage. Always.
That said, I am not the guy to ask about SSDT. I don't think the story on that side of the house is a very good one...
Microsoft has released Cumulative Update #4 for SQL Server 2014.
KB Article: KB #2999197
66 fixes total (54 fixes listed publicly at time of publication), including several fixes for Management Studio.
Build number is 12.0.2430
Relevant for @@VERSION 12.0.2000 through 12.0.2429
Microsoft has released the final Service Pack (SP4) for SQL Server 2008.
Build # 10.00.6000
KB Article: KB #2979596 (Download)
6 public fixes, including important security fixes from MS14-044
Relevant for builds < 10.00.6000
NOT for SQL Server 2008 R2 (10.50.xxxx)
Once more, this is the last service pack for SQL ...
You're right Chris, I've added that info (I was a little cautious mentioning it since the KB doesn't currently list it).
Microsoft has released a final service pack for SQL Server 2008 R2: Service Pack 3. The build # is 10.50.6000.34 and you can download it here. This is essentially a rollup of all of the fixes from the 13 cumulative updates for this branch (if you want to get a complete list of fixes, start at KB #2730301). For the fixes specific to SP3, see KB ...
The SQL Server team has released two cumulative updates for SQL Server 2012.
SQL Server 2012 Service Pack 2 Cumulative Update #2
KB Article: KB #2983175
Build # is 11.0.5548
Currently there are 50 public fixes listed (52 total)
Relevant for builds 11.0.5058 -> 11.0.5547. Do not attempt to install on SQL Server 2012 ...
@robotik nonsense. SELECT your_favorite_band AS [1direction]; - not that you should *want* to have aliases that start with numbers, since it can cause problems for other code down the pipeline as well.