I will test to see if I can duplicate but I have not run accross this issue before?

My thoughts is the UPDATE is of course running the delete but the fact dbo.waitForDealTrans is the table involved it should be causing a deadlock. You effectively have a lock...

MSDN is another location that you can check. Occasionally you will run across errors that the number will not help, in that case use the text.

Model only fixes it so that when you create a new Database the changes will be reflected there. However, it does not do anything to existing databases. I suggest if...

How often do these occurr? Also, when it occurrs again try sp_recompile YOURSPNAMEHERE and see if the same thing occurrs. If that works as well you may have something in...

Ok, first I would like to get the details of what you are trying to do to make sure you are getting what you need and limit some performance areas...

The big thing with Linked Servers is that you can inadvertently create security holes on remote servers if you do not setup properly. As for DTS thou it also has...

Unfortunately Oracle so I can't be of help. I do recall coming across someone using it on SQL but as for where I don't remember.

You might check around in...

Try running the backup yourself and see what happens with BACKUP LOG TSQL process. Also, check the Event Viewer logs to see if anything may have been reported to the...

Without proper access, no. You might try several things but there has to be sufficient rights on the other end to access the text file.

The best thing to do is to check with Peoplesoft on the required specs. Usually they will be glad to demo and give you comparisons on each. Also, ask if...

This is the way I do it.

sp_MSForEachDB '

IF ''?'' NOT IN (''db1Idontwant'', ''db2idontwant'') -- You could create a table for these and other cotrol info on this.

begin

BACKUP DATABASE

Just as an FYI check out on Planet-Source-Code, a script has been posted that uses the ALTER PROC command captures the before and after effect and demasks any SP under...

I think I would consider doing

RAID5 4x18GB with OS/SWAP/Raw Data

If not a lot of writes then

RAID5 8x69 GB Drives Data/Logs (tempdb also)

if high number of writes and you can...

I have been told this can vary from user to user, account to account and Financial Institute to Financial Institute. It is best to sit done with the leaders of...