Can't do it to dbo... dbo maps to the login name of the owner.

If you do:

sp_changedbowner 'aaron'

It will make the login aaron the owner (represented as dbo) in the...

I'm assuming RecID is the same between both tables... so if 'ABC Company' exists in tblCustomer there would already be an entry in tblTempCustomer for 'ABC Company'. You're probably...

That's great news to hear! Thank you very much for being so responsive to the community. I knew that there would be an official solution from MS dwn...

Yes, I originally was playing around with using vb or perl to clean up the backup files, however I ended up wanting to try to keep everything inside SQL. ...

That is a very good point which I had neglected to mention! You read an article a thousand times thinking you've addressed everything...

In our situation we wanted to stick...

I had trouble getting this to work as well. A couple of things that helped me get things going:

1. Ensure that all SQL Server instances in your mirroring quorum...

That answer's not 100% accurate.

All nonaggregated columns in the SELECT clause must also be listed in the GROUP BY clause; assuming that there is at least one aggregated column in...