Thanks - I was wondering why my answer was incorrect too....

A similair request was made some time back - so there are links within that thread:

http://www.sqlservercentral.com/Forums/Topic1213693-360-1.aspx

http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/

Don't assume that these identities will always be consecutive though - there may be gaps in the sequence when you look at the data.

An interesting article with examples of manipulating...

They changed the name of the old table system:

http://www.businessinsider.com/the-original-microsoft-surface-table-is-now-called-pixelsense-2012-6

Horribly obvious!

And yet it would appear I'm not the first to miss that, from the hunting around through the world of Google.

And you've just made me realise - we don't...

It is possible to log-ship from 2005 to 2008 but I don't think you would want to.

If your Log-Shipping is for Disaster Recovery then what happens if your 2005 server...

http://msdn.microsoft.com/en-us/library/dd207006.aspx and http://msdn.microsoft.com/en-us/library/ms189902.aspx

When the witness becomes unavailable the Principal can still be used but the mirroring state is DISCONNECTED. The log file of the principal will continue to expand until...

There was a very good article from Celko over a while ago (yes he does write good articles, without abuse!), describing the sequence a little better than the article pointed...

One way to do this:

CREATE TABLE #Temp(

Rack_LocationVarChar(50)

);

INSERT INTO #Temp(Rack_Location)

VALUES('c1'),

('c10'),

('c25'),

('c100'),

('c3'),

('c102'),

('c12'),

('c2');

select *

from #Temp

order by Rack_Location;

select *

from...

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

I'm currently studying towards 70-432 and still intend to take it. 2008 is still a supported product (and all of our customers use it) , so if you have the...

It depends! 😀

Taken from BOL:

"Instructs the SQL Server Database Engine to discard the plan generated for the query after it executes, forcing the query optimizer to recompile a query plan the next...

Because you need to run it as Dynamic SQL, using the EXEC command:

EXEC(N'SELECT * FROM #Test1 WHERE Test_Text IN (' + @P1 + ')');

What you have is SQL probably attempting...

It is because the column that you're trying to convert to a Primary Key has been defined as allowing NULL values, which is not allowed in a PK column.

Simply alter...