I believe it is "normal", but confusing to see. Microsoft has a paper somewhere explaining it.

I think something got goofed up in the cut-paste process :

(I.STATUS & 64)

I prefer Idera's SQLSafe because you can restore an individual table without having to restore the entire Database - Handy if your database is 700 Gig like mine. Redgate...

You want the target database to be a subset of the original database ? Or are you saying you might want to remove data from the original database...

Anywhere you're comparing or joining between the 2 databases....

Did you contact Idera support ?

You need to move or copy the database to another server ?? How will knowing the number of tables & SPs help you ?

What method are you using...

And performance will be bad, especially if the Data & Log are on the same drive.

Look for the object under a different owner.

I completely agree with splitting prod from dev/test. We're building out a new data center soon, and probably going to use VM for the servers. The 2 prod SQL...

True ... I like fixing things, so it's a good challenge.

I've often found the history information to be useful. Why do you want to delete it ?

GilaMonster (10/6/2008)

---

Less on the security and more on the performance, see if you can secure a separate server for dev/test. Letting developers develop on the prod box is asking for...

Thanks for the replies. My manager has made it pretty clear that he wants me to straighten things out (security, backups, performance...), and I think he's let the developers know.

We...

What are the collation settings for all the databases involved ?