Sounds like it is set to local administrator. For your problem to be fixed, it should read something like domainname\username. You may need to check with your network admins to...

This is just a guess from the error, but your SQL Server Agent Service is probably set to login under a local system account. If that is the case, it...

Don't feel too bad. Look at it this way, you've probably already put 90 - 95% of the time you needed to into studying. You just need to do the...

That's why I think the last anwser should have been NULL. Then it would be a bad joke at least. As it was, it looked like an incomplete answer choice...

After you restore on Server B, you will have to deal with the orphaned users (users in your database that either don't have an asociated login on Server B or...

Maybe the last choice should have been 'NULL'

Ken Henderson - Guru's Guide to SQL Server Stored Procedures, XML, and HTML.

Wrox and O'Reilly are definitely good. I would also recommend the Murach's SQL for SQL Server (for beginners). They talk a bit about your example (joins vs subqueries) and what...

Hey, learn something new everyday. it looks like the main differences between the two versions are mainly due to the diffewrences in SQL Server Enterprise and/or Windows Advance Server (mainly...

Here's one solution (Googled on SQL Server Uptime). Minutes since last reboot:

SELECT datediff(mi, login_time, getdate())

FROM master..sysprocesses WHERE spid = 1

I'll look into a T_SQL query, but I know you can tell this information from the SQL Server logs. In SQL Server Enterprise manager, go into Management, SQL Server Logs,...

If I were doing this, I would definitely normalize the tables (your first option, I believe). I would have an Employee Table, Location Table, and an EmployeeLocation Table. The EmployeeLocation...

If you are using the send email task in DTS, make sure that you are logged into the server (either directly or via Termserv) as the SQL Server Agent account...

I think that you are referring to Online vs. Offline operations (From Books Online):

DBCC INDEXDEFRAG is an online operation. While this operation is running, the underlying table is available to...

i always just put a staggered delay in my Windows startup, i.e.My Computer, Properties, Advanced, Startup and Recovery, Set the time to display list of OS to 15 seconds on Node...