True, but in most cases they are running a trace behind the scenes. If they aren't. they are likely putting shims in place (some tools do this to try and...

In order to be able to start the job, the user must be the job owner or the member of a particular database role within msdb (whose use isn't supported)....

First and last name doesn't guarantee uniqueness, though, in any directory. Even a small organization can have two John Smiths. But beside that... are you just trying to do a lookup...

ApexSQL Log has a 30 day full featured version available. I've looked at it in the past, but that was an older version. I have the newest version, but I've...

I'm guessing you are using SQL Server 2000 (although this is a 2005 forum). If that is the case, something like this:

SELECT 
  OBJECT_NAME(sfk.constid) FNAME, 
  OBJECT_NAME(sfk.fkeyid) PNAME, 
  sc1.name...

This is a question probably best asked of your Microsoft sales rep. That person can give you the answer by which your licensing will be measured against. Unfortunately, most on...

Mohammed is right, get a version of SQL Server installed. Then the next thing I'd suggest is to take a look at Safari (http://safari.informit.com/ or http://safari.oreilly.com/). Do a...

When the connection was specified on the application server, was the port specified in the connection string? For instance <server>,<port>? This is one way to establish the connection to a...

Agree with you on the dbo. Don't grant this unless absolutely necessary.

1) DDL

In order to create, alter, or drop the appropriate database object, the user will need the appropriate rights....

The C2 auditing is really a trace, so I can sympathize with you there. Some of the DBCC commands are automatically audited to the SQL Server event log. Is there...

Moving SQL Server is fairly simple... if it's not a cluster. You get the service accounts in the new domain, give them the appropriate permissions (changing service accounts via Enterprise...

Yes, SQL Recon is the best tool out there. It'll use all known methods to detect SQL Server. Which means... get a domain admin to run it for you because...

First question... is there a trust between the two domains? Second questions... is this a complete migration (to include all user accounts, etc.)?

This seems to fit right now:

http://weblog.infoworld.com/dbunderground/archives/2006/12/too_old_to_code.html

net stop mssqlserver /Y

Otherwise it'll hang at the prompt to also shut down SQL Server Agent if that is running.