Ya, I bust people for using an sql account...

Thats just the way it looks for the tempdb. If I go to any server, the shrink database always has the right data for tempdb and shrink file is some...

Mostly sqr's. You are right, at the moment there is no real need for a reporting environment, its when HRCS is implemented in the fall that there should be significant...

PaulB (6/5/2009)

---

Let me check my understanding of the described scenario.

There is an OLTP database happily living in a cluster which for the purpose of this exercise I would call system-a.

So,...

Well I did it pretty much the way I outlined above, having the same server name was a pain.

The new server was patched with SP4 where the old one was...

Would help if  you include the whole proc. Must have a syntax error somewhere.

As Kemp said a trigger could work for you once you are in SQL server. In our main application security settings are stored in a table and we want to...

um i don't see why sp_changeobjectowner will not work. sp_changeobjectowner 'user.tablename', 'dbo'

Works for me

Try the following: ALTER TABLE yourtable NOCHECK CONSTRAINT ALL. This should disable all constraints on a given table and allow you to delete. Much easier than having to list the constraints....

Looks like this had to do with hardware problems on one of the servers. Had many errors again today to do with I/O and in particular writing to disk. Our infrastructure...

The cluster log only seems to hold a day or two of data so I will get the appropriate day from backups and e-mail to you sa24. Thanks!

Here are the system log entries at the same time no security entries that apply. These are all errors from the source ClusSvc.

1: The Microsoft Clustering Service could not write...

There were several access denied errors on the quorum drive,also this shows up in the application log right before trouble started 17053 :

LogWriter: Operating system error 5(Access is denied.) encountered.I...

I can't find anything in the logs about the drive the db's and logs are on (the F: drive) but the e: drive is the quorum drive and from the...

Might be over simplifying here but might as well check before you go to far. Can you just rename all the tables in access so they no longer have dbo...