The_SQL_DBA (10/10/2008)

---

We use spotlight, never had any issues with it. I suggest you request a demo for spotlight at http://www.quest.com.The licensing and all issues can be asked for with the...

I just recently found this:

[font="Courier New"]IF OBJECT_ID('JobActivityMonitor','P') IS NOT NULL

DROP PROCEDURE [JobActivityMonitor]

GO

/*******************************************************************************************************

**Name:dbo.JobActivityMonitor

**Desc:Job Activity Monitor (SQL2005)

**Auth:Adam Bean (SQLSlayer.com) [original interval logic from William McEvoy - http://cookingwithsql.com/source/sp_ShowJobSchedules.sql%5D

**Date:09.05.2008

*******************************************************************************

**Change History

*******************************************************************************

**Date:Author:Description:

**-------------------------------------------------------

**

********************************************************************************************************/

CREATE...

Replication would be a pain. Any time new tables were added to the database, you'd have to remember to add them to replication.

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 ?