What exactly is a bean counter?

If you want an automated way to do this, I'd highly recommend using Bill Wunder's DDL Archive Utility. Been using it for the last 3 years, and absolutely love it....

Where...

Yeah I went to databasepropertyex right away as well, but the status reported was online.

Basically, I attempted to take a database offline that still had active connections, during this time,...

USE [database] GRANT EXECUTE ON ASSEMBLY::[assemblyname] TO ;

I went back and changed it so that it does the dbcc inputbuffer ... I wasn't able to find any other way to get the actual procedure called, vs the...

I highly recommend looking into Quests's performance analysis.

Sorry I can't elaborate more at the time, but go demo it ... have them put a web demo together for you....

So this works ... just dumped the db backup into dynamic SQL:

I'd really like to hear any type of explanation ...

Thanks

IF OBJECT_ID('DailyDatabaseBackups','P') IS NOT NULL

DROP PROCEDURE DailyDatabaseBackups

GO

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

**Name:admin.dbo.DailyDatabaseBackups

**Desc:Runs full SQL...

Wow, this is nuts ...

So If I put the comment out the backup or put it into dynamic SQL:

SET @BUName = @BUPath + @DBName + '.bak' ...

Immediately after you create the snapshot or after you start altering the source database?

Good to know.

Also, just FYI, the name of the type of file (I think) is a sparse file. That it creates a file at a specified size, but doesn't actually...

There are quite a few good scripts here on SSC for scripting out logins ... I haven't used it, but this looks like it should help: http://www.sqlservercentral.com/scripts/Replication/31160/

If not, just search...

matt stockham (1/24/2008)

---

I haven't made it to trying 2008 yet, but I would guess that there may be some kind of benefit from reduced locking (depending on the isolation level...

Run your backup again, then do a sp_readerrorlog and grab the full error.

If I were to take a random guess, I'd say it's permissions to the file system.

In your dataset, you can specify...