There isn't a fool-proof method without doing some complex parsing or using a third-party tool but you can try a couple of things:

Use the procedure sp_depends to get a list...

In my case the times match in eventviewer and in SQL Server.

Check the job history and see when the job started (according to SQL Server). Also, expand the job...

Matt Miller (4/16/2008)

It will help substantially if you are comparing it to not having an index. however, a non-clustered index (covering) could give it a run for its money,...

Yep, try this:

select backup_start_date

from msdb.dbo.restorehistory h

join msdb.dbo.backupset s on s.backup_set_id = h.backup_set_id

where destination_database_name = 'the name of the database you want to check'

order by restore_date desc

That will return the...

Generally speaking you are right in your analysis. But bear in mind that every table should have a clustered index. So if there isn't a need for another...

I'm not sure what you mean by "initiate"?

When I look in the history of my jobs that run SSIS packages it just gives me the time it took to run...

As Gail suggested, turn on the trace flag to get a better idea of what's happening.

Looking at the code though I've got a couple of ideas that would suggest why...

Hi David,

if you had linked servers setup you could run the following command:

exec a_linked_server.master.dbo.sp_executesql N'select serverproperty(''productversion''), serverproperty(''productlevel''), serverproperty(''edition'')'

If you don't have permanent linked servers set up you could potentially create...

You shouldn't need to use dynamic SQL for the NOT EXISTS statement. Try this:

IF NOT EXISTS(select * from information_schema.columns where table_name = @TableName)

begin

SELECT @sql = 'Create Table...

You have to re-index after the shrink because shrink a database can lead to fragmentation.

Peter,

By far the easiest way would be to get a job with a large corporate in the UK and then do an internal transfer. I worked for a large...

cooldba (4/11/2008)

---

Thx Guys for Replying my post....

Karl: If you compare the date & time in both the logs then u will find that as per application their is a occurance...

Seeing as you have three instances and you need to share 8 GB across the three I don't see any reason to use AWE. Just give about 2.3 GB...

Now that you've enabled those trace flags, the next time a deadlock occurs you'll get some more info in the error log about the deadlock. The fact that you've...

As you've discovered you cannot use a go statement inside of an if statement because the go is meant to seperate batches. So you'd have to do something like...