I think you're stuck with building a job that runs often. I know of no built in functionality that will detect long running jobs.

Greg

How about scripting out TRUNCATE statements:

select 'truncate table ' + name

from sysobjects

where xtype = 'U'

Greg

Here's something I put in a step of a job that runs every morning to detect overnight jobs that have been executing for more than 2 hours:

set nocount on

Unless you had some sort of auditing running: Profiler, DDL triggers, etc., you won't be able to see who dropped the table without the help of a transaction log reader...

I've used the Wizard to export data from SQL 2000 to SQL 2005, BUT I was only able to use the "copy tables and views..." option, not the "copy objects...

Did you create the diagrams that existed before the restore or are you a member of the db_owner role?  Diagrams can only be viewed by the user that created them...

Duplicate post.  This thread has responses: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=399584

Greg

Your license won't expire when support ends.  See the Support Lifecycle explanation here: http://support.microsoft.com/?pr=lifecycle. 

As for upgrading, you'll just need a new license when your SQL 2000 license expires. ...

I've found that only the owner of a diagram i.e. the user who created it, or a member of the db_owner role can open diagrams.

Greg

I think not, unless a trace was running at the time.  I tried switching the recovery model of a test database then looked in the SQL error log and the server...

Hi Bob,

Stored procedures for creating and managing DTS packages are in msdb, but

the common tool for working with DTS is the GUI DTS Designer in Enterprise

Manager. 

When the Import/Export...

We use fixed database roles in development databases.  Developers are assigned to db_datareader in all databases via a group login, and db_datawriter and db_ddladmin in the particular databases they develop...

You can't really get any info about why a package failed from the job history.  You should enable package logging, execute the job, then check the package log to see...

Just make the new login a member of the sysadmin fixed server role.  We make the DBAs members of sysadmin so they can do all the SQL Server administration using...

Kedar,

Although there isn't a native SQL Server object restore, you can restore a database backup to a new database using the 'WITH MOVE' option of the RESTORE DATABASE command.  Then,...