SELECT * FROM iaxChecksCurrent

WHERE

CONVERT(DATE,UploadDate) = '2012-07-18'

gives me this:

Msg 243, Level 16, State 1, Line 1

Type DATE is not a defined system type (I neglected to say I was...

: ) Major incidents we can do without! ciao!

You have been so very helpfull and I apologize for not posting back with results!!

I ended up killing the hung backup threads and it turns out that there were Netbackup...

Thanks for all your help. I think I will Kill the threads on the user database first and see how I make out. I can at...

Netbackup running a Full Backup everynight and TLOG backups every 2 hours during busines hours. Sometimes we do have jobs waiting for media.. but not often....

Both Databases have threads with wait types of Backupthread, backupio and lck_m_u

I got this cleaned up by going in through Management studio and DISABLING Replication - this seemed to cleanup what I messed up and allowed me to re-do the whole...

Thank you for the replies. It goes without saying that i will try and ramp up the CPU and memory on any new solution, I...

Thank you Lowell. I will do some testing of my own on a Test server!

You guys are the best!

Thank you Steve 😀

You set a DB to read only like this:

ALTER DATABASE [My_Databse] SET READ_WRITE WITH NO_WAIT

So I would change the Trigger to:

Create TRIGGER...

Thank you. one of the devopers had asked advice on how to optomize it.. i just thought maybe i was missing something... thanks!!

Joie Andrew (1/13/2012)

---

The account with <domain>\<machine>$ is a computer account. You should be able to add that account as a user to the db if need be. Is it causing...

did you try

Use Master

EXEC sp_change_users_login 'Auto_fix', 'userid'

Use USERDB

EXEC sp_change_users_login 'Auto_fix', 'userid'

This sometimes works for me after I've done a redirected restores to remap the users

restarted the service, got a connection and set the memory back to 2048mb