A DDL trigger will grab things, but here's a problem. If you store this in the db, once the user has sysadmin, they can erase their tracks.

If you trigger on...

Data compression white paper: http://msdn.microsoft.com/en-us/library/dd894051.aspx

The compression applies to structures coming off disk, and in memory in some cases, so it can increase the IO rates that you appear to get.

You'd have to scan all databases for login mappings and then look for something that didn't have a match. I might create a table, load in matches from each database...

If this is homework/exam question, you need to do some more work, or show us what you think needs to happen to answer the question. We are happy to help...

If you show some code, or what you're trying to do, we could help.

If you're moving to 2008 on the database, I think that you might want to use VS2008, only so that you don't find something that would work well in the...

No real disadvantage for using the max.

Text/ntext/image are deprecated and will be removed in the next version or two.

Books Online, maximum capacity specifications: http://msdn.microsoft.com/en-us/library/ms143432.aspx

You'll need accounts in those domains with any tool. They will all require authentication. Without a trust, you'll just need to supply domain\user credentials in the other domains.

Assuming those commands are proper for PuTTY, I think the problem is that PuTTY doesn't take separate commands from the command line. Once you invoke putty, you're in it's shell,...

the owner of the job, if I remember, doesn't do much in 2000. I think it can only be logins, and I've just used SA as the login.

It seems...

Richard,

Excellent points, and some of that is trying to be addressed with Sharepoint integration. I'd agree there are issues, but that's not a reason to ignore Excel, especially when a...

http://www.sqlservercentral.com/articles/Clustering/65994/

http://www.sqlservercentral.com/articles/Clustering/66246/

Very well put, Jeff. There are multiple ways to handle inventory, and modeling is not something you learn in a day. It takes time, and if you've never done it,...

I'd tend to agree with Jeff. You can secure this pretty well these days, and in limited use, it makes sense. I wouldn't want someone to have unbridled access, especially...