Did you try INSTEAD OF triggers?

Maybe this will answer your question:

http://support.microsoft.com/default.aspx?scid=kb;en-us;818374

INF: SQL Server 2000 SP3 Creates a SQLDebugger Windows User Account

The link from this article to this:

http://support.microsoft.com/kb/318632/EN-US/

FIX: SQL Debugging may fail...

Steve,

Thanks for confirming that it is the issue. 

What happened to the concept of the group / role based access?

I do agree with you about setting the job owner to SA or...

1. Use sp_attach_single_file_db (see syntax in Books Online in the SQL Server Star Menu) because it uses only the database file and creates a new transaction log

2. Check the log...

I am doing moving backups to another box and restoring  them there for one of the applications I support for the redundancy. When I will move this application to SQL...

What do you mean by communicating? There is an FTP replication or web access, depends on what level you want to access.

Hi,

detach databases from the old server, copy to the new server and attach to the new server. Or restore database backups to the new server. When restoring, watch the file...

I usually go to

http://www.accessmonster.com

when I have problems like this. It is not that we can not help here, we would try, but they do have more expertise.

Good Article, easy to read and understand.

Exec xp_cmdshell

'dir C:\WINDOWS\sqlsp.log'

it will return several lines including the date on the file. It will work on SQL Server 2000 computers and will not work on...

To avoid this problem you would want to have DNS alias that is not the server name. The app should use this DNS alias for connection. Then if you are...

Karen,

I don't think the clock settings take a reboot, try on your workstation first. Check your jobs that run around this time, so you would not miss a job like...

There were a couple of posts on this topic on this forum. I did test it a while ago and have the same result. You can add a securable and...

If the people are working with the database, they may be doing something. I would notify users in advance, then see who is connecting and call them.

A couple of things:

1. If you are working with the instances, they have a different naming conventions, you have to acount for that.

2. Developer edition is a counterpart of the...