Eleanor,

I'm sorry, but I'm not sure that you're going to get a great deal of help with that particular request.  Depending on the type of experience you require, it could...

There is an undocumented extended stored procedure that you can use for this.  It is xp_fileexist and resides in the master database.  Following is a sample execution -

exec master..xp_fileexist 'x:\SQL_Backups\test.BKP'

If...

Here's a snippet of code from one of my procedures.  My filenames include the date in the name, so thats all I need.  However, by modifying the DIR command, you...

As Mark said, the job related procedures are in msdb, and if you execute them from any other database, the procedure name must be qualified(msdb..sp_update_jobschedule).  However, if you are just wanting...

Its refusing to disappear because it is rolling back.  It is undoing what it had done up to the time you killed it in that particular transaction.  If this is...

I'm not sure why its happening, but all you need to do is change the word CREATE to ALTER.

Steve

By the way, regarding the script that I mentioned earlier... I just now had occasion to use it myself.  (I shrank a 2GB transaction log to 100MB).  In looking at...

>>Just to be clear, you don't think that backing up the transaction logs tonite will remove those inactive transactions?

Yeah, it might. That really depends on whether the transactions have committed...

Yes, that helps.  You have a total of 48GB of transaction log, 653.85MB currently in use according to task pad.  You shrank the log a few hundred mbs, so that...

declare @db sysname

set @db = 'pubs'

if (select databaseproperty(@DB, 'isSuspect')) = '1'

 print '   *****  database is SUSPECT.  *****'

else

 print '   database is not suspect.'

-- Steve

And your transaction log backup completed successfully?

If you view the database (in Enterprise Manager) using taskpad view, what information does it give you about the transaction log?  Total size for...

I've never tried it.  When I script an object in Enterprise Manager, I usually want to work with the script immediately.  So I copy the script to the Windows clipboard,...

Are you sure that the 2nd file is associated with the database and that it is a transaction log?  The name, integration_log, would seem to indicate that it is a...

Frank!  Congratulations!

Treasure every moment.  They grow up so fast.  It seems like only yesterday that my kids were little.  Son's 18 and daughter's 15 now.  They are still the joy...

I don't know.  I live in YUKON OK, and I couldn't get it to work on my SQL 2K box.

Steve