Not sure, but I think maybe you need to run dbcc updateusage before running dbcc sqlperf(logspace).

Backing up the transaction log does a truncate as part of the backup, whether its...

There should be no issues with users accessing a database during a SQL backup.  Any inserts/updates/deletes are put into the transaction log, and committed after the backup.  Further, the backup...

By purging, do you mean you want to remove all the data, or that you wish to delete the database completely?

If you want to delete it, just right click within...

There was a change at some point in how SQL Server determines the owner of an object.   I'm not sure when that change took place, but I think it was...

Are the updates done in a job or manually executed?  If they were run in a job, you could make sa the owner of the job. Then objects created will...

One more point....

I would suggest that you modify your procedures such that you don't overwrite backups.  Keep them as long as feasible (at least a couple of days), then create...

Muneeb,

So, normal procedures are as follows?

1. full backup which overwrites the previous night's full backup

2. transaction log backups which overwrite the previous day's transaction log backups

???

If this is the case,...

I tried it on our test 7.0 server.  Since we don't have the xp_smtp_sendmail proc, I commented that part out, and replaced it with "select @Msg".  Worked fine.  I would...

First, be aware that 6.5 doesn't always report space properly.  Try running "dbcc checktable (syslogs)", which should update the space reported for the log.   If you are getting "log device full"...

SQLBill,

Thank you for suggesting that I submit my stored proc.  I took a look at it, and it makes a LOT of assumptions about our 'DBA' database being present,...

Edward,

Beautiful function!  Performs rounding just as advertised!  Miriana's requirement was for rounding up, so if we add "set @Value = @Value + (@Base / 2.001)", it will always round up.

CREATE...

Also, I would suggest that developers should not have the ability to create/modify jobs, or to implement stored procedures on a production server.  They should be coming to you for...

Take a look at INFORMATION_SCHEMA in books online.

Steve

Isaiah,

The best thing about differential backups is that it reduces the number of backup files to restore if you're taking lots of transaction log backups.

For example, in my shop we...

Phoenix,

Thanks.  No, its just scheduled through SQL Agent, but it contains activex scripts.  Today, another colleague suggested trying to run it through a command exec batch file.  Once again, if...