There are errors, associated with the query. The error Code is -1073548784.

Follows is the Error Description (note the 2 DECLARE Statements):

Executing the query "CREATE TABLE [tempdb].[dbo].[DASD_DataFile]([File Id] [smallint] NULL,...

Sorry. I believe I posted this in the wrong place.

I'm having trouble getting the steps in Collect Database Info to execute. For example the Update Data Used Size step is failing. The temp table isn't being created. If I...

I encountered a problem getting the size of the files, when the database was mirrored in the Update Data Used Size step. I received this error message:

failed with the following...

My bad. I though the job was failing on Step 1, but it was actually Step 5 - because I fat fingered the job name.

Thanks much for a great tool....

I'm getting an error in s01-Job Last Run Datetime. It's a syntax error near '(' in this code. I'm not familiar with the $(ESCAPE_NONE(JOBID)) portion of the statement.

-- Get Job...

I got it resolved. Problem was in the application.

I created a web page to dynamically build a grid view, using a connection string that was exposed on the web page.

Thanks...

I do have a witness configured for automatic failover.

The application's connection string specifies the server & failover partner.

When I set the database on the connection string's server to failover, the...

Does this work with multiple filters? For example Country = "USA" & Order Date After "1/1/2006". Got an example?

I like the previous scripts, but if you are intent on uses a DTS package, consider the following steps:

1. Create a temp table with a Primary Key, Telephone # &...

DTS & SSIS packages can eliminate the looping activity - they may not be as efficient as a stored procedure but they sure can accomplish a lot.

I like cursors in...