SQL Server 2000, yes, but I haven't faced the torture of having to do it...

There are also trace files you can read with SQL Profiler in your LOG directory that traces DDL changes. So if the table was dropped (as in deleted), you can...

One catch is that any shared components, like Workstation components, SSIS, etc., will be upgraded to SP2.

A group account would mean a Windows group. So you would need to add it to the appropriate Windows group, whether on that server or in Active Directory. For BUILTIN\Administrators,...

But that's a related degree, at least. If...

Loner (6/4/2008)

---

Most people apply for a job that they are not qualified for because they do not have a job and they desperately need a job or some people just...

Michael Earl (6/3/2008)

---

Assuming you are using Active Directory and Server 2003 for your domain controllers, it is already turned on. You should just have to configure your SPN's.

Use the...

Not just Kerberos authentication, but Kerberos delegation. The first SQL Server must be configured to be able to delegate to the second one.

To piggy back on what has already been said, named instances will try to use the same port, but if it's in use, they will try the next available port...

The best way, if you do this, is to use a log reader application, such as Apex SQL Log, for one. However, you can build a solution without putting your...

If it's Volume Shadow Copy, I'm not sure what supported configuration there is with respect to service accounts. I know in the past you couldn't run Full Text with anything...

Robert Bedick (6/3/2008)

---

SchemaToDoc (http://www.schematodoc.com) will document your database's tables, fields (type, size, defaults, nullable), indexes, check constraints, foreign keys, triggers, views, stored procedures and functions. It has Word and HTML...

blandry (6/3/2008)

---

Now with the web, companies can list everything from "must have" through "would'nt it be nice to have" qualifications and this leaves many of us "utility men" looking at...

Anirban Paul (6/3/2008)

---

Some people are champions (read exceptional) like you, who can be expert on both (read Network & DBA). We have a utility guy who is very popular but...

C2 audit is nothing more than a server-side trace with a lot of the events and columns turned on (actually most of them). You can build a more lightweight trace...