I have an odd feeling that is a SQL 2000 instance. The directory is wrong for SQL 2005 (which uses the MSSQL.1, MSSQL2. format)

Can you...

http://www.microsoft.com/learning/mcp/certifications.mspx

Testing XML

[code2]

[/code2]

Edit: Nope.

I notice that the ADDADD is still...

Ok. What does the services dialog give as the path to the executable?

Is the other one something like MSSQL$BACKUPEXEC ?

Stamey (3/30/2009)

---

I don't know how long the info stays in there, as this is from the default trace, perhaps it is determined by how busy the DB is, but...

Find the database files on the PC in question (.mdf and .ldf), copy them to another machine that has SQL 2000 on and attach them.

ALTER TABLE < Table name >

ADD CONSTRAINT < Constraint Name > UNIQUE (ColA, ColB)

Casper (3/30/2009)

---

Is there a way to see what user login created a specific object, like a specific stored proc or a table?

And for that matter is there a way to...

Check both under SQL and under...

I need the actual names of the services in order to help you. One of those is going to be the default instance, one is going to be a named...

My guess is that the SQL service is starting before the disks are available. If you check the error log, you'll probably find a lot of errors relating to SQL...

http://www.microsoft.com/learning/mcp/certifications.mspx

You sure? I'm still wincing from the last one I...

Sure. no problem.

That is, if you can give us some info on the table the trigger's going on, what the trigger needs to do and when, and, if it has...

Yes