You can get the same information by using the sys.master_files which returns data for ALL database and ALL files regardless of the database context you are working in. So...

The error is telling you that you have unicode characters in the source and you are losing them when converting to non-unicode. It isn't really truncating because of length,...

Yes you could and should re-write the trigger, but not just because of the error message, which you get whenever you have a rollback in a trigger, there's no way...

Hey, I haven't gotten the newsletter for today, has anyone else had this issue?

Not...

I believe so, since you can connect to any version of SQL Server using ADO.NET. I haven't done it and don't currently have an environment to try it...

I wouldn't expect you to get anything back form TRACESTATUS that you didn't already know about. I'm checking all my resources to see if I can find anything about...

First you need to determine if you have a good candidate for a clustered index. Check out Kimberly Tripp's blog for this. Here's the last post, http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-again!.aspx in group...

Why did you run this? Running this will only get you trace flags set for the current session. If you wanted to all trace flags...

The only resource I can find that mentions this lock type is this and it says:

I'd love to be able to give you more than...

If you are calling the stored procedure and using parameters then you wouldn't need to escape the single quotes, just have the parameter types set correctly. I can't recall...

Select * from sys.databases where is_encrypted = 1 returns no rows?

If a single database is encrypted using TDE then tempdb is encrypted.

No, and it's funny you should ask about him because I was thinking of asking the same thing.

After the destination

Here's an article on how...