At first blush, this was my thoughts too. Everything I've checked appears to be up to date. Any ideas on where I could check to make sure everything...

Actually the answer is "NONE OF THE ABOVE". The answer (deemed correct) refers to IDENTITY INSERT set to ON. This query will run if IDENTITY INSERT is set...

Thanks John! This sounds like the makings of a good QotD!

Cheers,

Brian

Thanks for the responses. That is what I thought would happen. I did read some more information after posting. It appears that changing the collation DOES NOT...

Here's one way to do this. This is using a CTE (assuming you're using 2005 or higher). If not, it is easy enough to wrap up as a...

That's the way a join works. Even though you may only have one batch number record in table 1, if table 2 has three records with that number, then...

Your initial insert statement is incorrect.

"Assume you have a SQLServer2005 database and that the table "tb_User" contains the user 'Assis Marques'"

You need to modify the initial insert to be...

Since the abbreviation is "nvarchar" I can see National VARying CHARacter. How did it become National CHARacter VARying? If that was the case shouldn't it be ncharvar? I...

I concur. The result set is (should be):

Vyas Mohan ...

If you create a view and use the sp_rename stored proc you can rename it. This might be an error in BOL.

Cheers,

Brian

The only reason you would need the three part name was if you were referencing a different database [DatabaseName].[SchemaName].[TableName] on the same instance. In this case HumanResource is the schema...

Good article. Nice and concise, with good points. BOL pointed this out in regards to the read-only file groups:

While TDE operations are not allowed if the database has any...

From Microsoft: "The exact results of a UNION operation depend on the collation chosen during installation and the ORDER BY clause."

http://msdn.microsoft.com/en-us/library/ms191141(SQL.90).aspx

This is for SQL Server 2005. I'm...

Run this query on 2008 and tell me what you get back:

SELECT MIN(severity),MAX(severity)

FROM sys.sysmessages;

That will give you your answer. Hint: 0 and 24. It's the same for...

I tried starting a 2000 SP3 Standard Edition with single user mode with no luck. DAC didn't come along until SQL 2005 so that wouldn't work. Is there...