Print the value of @sql, and run it from the command line, and you should have your answer.

To be fair, sp_msforeachtable uses a cursor as well, but at least it's already written for you.

The SPIDs numbered 1-50 are reserved by SQL Server for internal use, so all user processes will be 51 or higher.

By the way, my initial code does strip off the time portion of the date, so if you need the time, just increase (or decrease, such as style 112 to...

Don't feel bad Sam, as it's a problem many of us had when getting familiar with the internals of dates. The problem is that a line such as "Convert(datetime, Getdate(),...

Max, I think you're a bit too fond of the ol' single quotes. 

Try this and see how if it works for you (be...

It sounds like you are using a datetime return type when doing the CONVERT, THEN doing the CAST, as using CONVERT with a return type of varchar will do exactly...

It depends on the purpose of your exam.

If you want to create practice exams to be used for certification purposes then get a bunch of people to take the exam...

We just send e-mails to the SMTP server and let it send it on to Notes. That will work whether your final destination is an enterprise mail server such as...

What do the following statements return for you?

SELECT

Max(Len(Date_Created)) FROM tablenamehere