I'd wait for a year, show you have some experience and then pass the test to show that you've learned something and can pass the test. It probably doesn't matter...

Haven't seen this, but I'll post a note and try to track this down.

They are all good. Litespeed (Quest), SQL Backup (Red Gate), SQL Safe (Idera), and Hyperbac's tool.

Pick the one that seems suited to your environment and has the features you need.

I'll track this down, but I know you can find a bunch of jobs if you go to Microsoft.com and go to the careers section. You can search for jobs...

If the objecst are not owner by dbo, then you might need to. If they are owner by dbo, just remove those two users from the role.

I think any of the 2005 admin books are about the same, containing about 80% the same stuff. The Pocket Guides are cheaper and they have good info. I've avoided...

The possibilities are the answers.

The easiest way it to use Enterprise Manager, check the user and see which roles it has been assigned. Then you can see the rights for those roles as their...

This is also in Enterprise Manager, under the properties for the server. Check the security tab and you should use this tab to change the account if needed. That way...

As mentioned above, you've written the statement to deal with one row.

You cannot use local variables for the values or you only get them for one row. What you really...

If you can better explain what you're trying to do, maybe we can come up wiht something. from the tables and code, it isn't obvious what the criteria is on...

The easiest way is to detach the file, copy it, and then reattach it.

Copy of.....?

I have both CTP6 and CU6.

You might have a large virtual log file as well, which could prevent shrinks.

Search for "forcibly shrink the transaction log" here. There's a script that can help, but be sure...

I think this is simple if I understand what you are looking for.

In the trigger, look for the inserted table and check if it's dates and code are inside an...