I used the Trancender software for a couple of exams about 5 years ago and found them to be very good. The questions were very close to the tests...

If the email you are trying to send has an attachment, make sure the file you are attaching exists. I have gotten

Msg 18025, Level 16, State 1, Line...

OMG!!!! That so saved my bacon. That directory;

C:\Documents and Settings\Your Name Here\My Documents\SQL Server Management Studio\Backup Files\Solution1, contains a ~blah.sql file for the window that you were working...

I finally found the problem and yes, it was between the keyboard and the chair. When you make changes to a data source, be sure to delete the old...

I need to access data on a server other than my reporting server. I have tried using the UID/PWD, tried using a linked server, stored the credientials in the...

You can get around this by creating a temp table or table variable in your stored procedure and loading it up with the raw data i.e. order_id, detail_id, item (one...