Can you give snippets of your C# and T-SQL stored procedure? Make sure that you clean up any code to hide anything that might be sensitive your organization. That would...

Fric frac, triggers are designed to work with multiple records at a time, as a matter of fact, that's why you have the inserted and deleted tablespaces. Set based operations...

Actually, you can create the join table like this:

CREATE TABLE CarDriver(
  CarID int NOT NULL,
  DriverID int NOT NULL,
  CONSTRAINT PK_CarDriver PRIMARY KEY (DriverID, CarID)
)

I don't typically...

You could use (perhaps with a little modification) the following script from the Script Library here:

Automated Profiler trace import

There are some versions of media that will not prompt for a key. As indicated, these are obtained that way by your organization... usually the media comes from a reseller...

Wrap the test in some client code capable of catching the error. I know this is a kludge, but it's really the only way to do so. Technically you could...

Yes, I talk about how to do so in this article (which is a general article on Profiler). Look for the section A Major Proviso:

Auditing with SQL Profiler

RestrictAnonymous has implications on the operating system side. It should not have any impact on SQL Server. Basically it determines if someone can make a null connection and if they...

It is not currently present in SSMS, so far as I am aware. This has raised some hate and discontent if you do...

First step is to always normalize the database. This ensures data integrity standard are met. After that, denormalize when needed to regain performance. However, data integrity checks will need to...

What version of OS? Windows 2000 Advanced Server? How did you do the MS DTC install if it's Windows Server 2003 Enterprise Edition?

Make sure the guest account for OS is disabled. Also, get rid of the following part of your connection string:

Integrated Security=SSPI

This tells the client to try and make a Windows...

Was the SQL Server 2000 EE installed as a clustered instance? If so, did the setup not roll back when it hit this error or are you applying a service...

The app name isn't something you can really depend on, though, because it is passed by the client and there is no verification of it by SQL Server (which raises...

That probably should be server local groups. Domain local groups can only be seen within the domain and thus aren't typically as heavily used as domain global groups for obvious...