If there is no documentation and the developer/admin has rolled off? All you can do is document it as best you can as you go and insure to document when...

If you are using MS SQL Server 2000 you can use user defined functions on a row by row basis. What are you trying to do?

The out of box maint plans do backups in a serial fashion for all selected dbs. Do you need a more robust backup plan? What are you using to do...

What type of maint is this job doing?

Transaction log backups? One or more databases are probably in SIMPLE recovery model.

DBCC? You probably have attempt to repair errors when they...

Both qa and production return 1 when you run count(*)? What do you get when you run the update outside the proc? Is there more to the proc than posted?

Are you trying to take advantage of AWE memory?

So all is OK?

Are you sure you have the right proc as the one above is an update and the first message talks abount an insert!

The answer is you are probably updating 4 rows in production. Run the query below on both production and QA.

Select Count(*)

From logins

Where userid = 'the_userid_passsed_when_sproc_was_called'

Are you using a DSN or DSNless connection? Please post the connection string you are using in your asp page!

This is a double post by the subject and has been answered.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=232418

DatePart returns an integer so the addition is correct, but not desired!  For an update on as datetime column I would also return that column and use a DataAdd function...

No work around just do as the message asks!

Insert Into dbo.tablename (column list, which you did not supply)

Values (etc...)

Did the service actually stop or was it stopping? Check your logs, as it is probably rolling back, checkpointing or in recovery!

We are not talking about EM we are talking about a system table in the user db!