Some of these are system processes (Task Manager, etc.) so there's nothing to do with these. The Awaiting Command ones are usually idle client connections.

How much free space do you have in you database v the size of this table? Maybe there's no enough extents in a row to build the table. You might...

You could set up a check for the file timestamp with a script of some sort. In SQL 2000, I'd probably set a DTS package that uses VBScript to check...

Denis,

I'm not sure there's an easy way to run this report without performance issues. You can set up a clustered index on the date, which will limit he amount of...

I'm not sure how many times you should go through the book, but you should be able to add/delete/edit the following:

- Logins

- Users

- Databases

- Schemas

- Roles

- Permissions to any object...

I took this after writing part of the Sybex book. It was fairly routine and I didn't think it was overly difficult. Of the 4 I've done (431, 441, 443,...

Doing some projects would definitely help and I'd consider them. Especially if you could bring a version to teh interview on a laptop, explain how/why things work.

I'm not saying you're...

Michael has it right. Look up Multi-Server Admin in BOL or Master Server/ Target Server.

The way to do it would be to insert rows into the temp table and manipulate them, then select out all the rows as your message. Not sure how this...

Have you tried it with replacing SHEET$1 with something else?

There are numerous scripts on this site that will write a new file based on the date. I'd recommend different dates since I've had issues iwth a single file before.

I'd still think you are a junior DBA since so much of SQL Server is different from Access. There are definitely cross overs in the database design, understanding how tables...

Strange question, but I'd go with the union as well.

Agree with John. We came up with a hack to force changes in SQL2000, but we couldn't deal with complexity.

Are you sure that Mixed mode is enabled on the server? Make sure you're connecting the same way, same name/IP and same protocol.