It's the Microsoft Self-Paced Training Kit for 70-441. I don't have it on me at the moment (it's at work), but the cover is blue and it has a...

Without knowing at least one column name, there's no good way to do a delete other than manually before the run of the package.

I recommend redirecting the rows out of...

If I'm not mistaken (someone correct me if I am), the Image datatype is actually stored in the DB as a binary file. Therefore, there is no good way...

If all else fails, you might have to back up all your databases, uninstall and then reinstall SQL Server, then restore all your databases.

But try the MSDB restore first. ...

Why are you using SQL to delete from an Excel spreadsheet? What are you trying to accomplish?

and this link:

http://blogs.neudesic.com/blogs/pete_orologas/archive/2006/10/12/416.aspx

Check this link out and see if it helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2553214&SiteID=1

Given the staff changes issue, you need to start documenting what it is you're training the back up people on. Create a binder filled with details on what you...

If the group is really tight knit, you might want to consider your approach to them carefully. You don't want them to think you're trying to steal one of...

And it's that comment that worries me. So you are...

The problem is that SQL Server Agent is not part of the client tools. It's part of the whole SQL Server Engine install. So taking off the client...

Check your Add/Remove Programs. SQL Express might have installed anyway when you installed VS 2005. If so, you'll need to uninstall it and reinstall the regular version of...

You might want to check DBCC InputBuffer in BOL and the text of SP_WHO to see if you can crib some code from the procedure to help you identify the...

Rolf,

I hope you didn't test this on a production machine...

Have you tried re-running the SQL 2000 install process to see if it gives you a repair option?

Look at...

Do you see the service pack 2 listed separately in Add/Remove Programs?

If so, try uninstalling that. If not, I'd call Microsoft. They should have a way of upgrading...