I could see using this script on a SQL express installation without SQL Agent installed. Windows Scheduled Taks would be used for scheduling it.

I am not sure how I...

samehzagloul

I ran the query against AdventureWorks and the join to data type included column names as a type

Here is a sample of the output

TableNameColumnNameNameLength

AddressAddressIDint4

AddressAddressLine1nvarchar120

AddressAddressLine1AccountNumber120

AddressAddressLine1Name120

AddressAddressLine1OrderNumber120

AddressAddressLine1Phone120

AddressAddressLine2nvarchar120

AddressAddressLine2AccountNumber120

AddressAddressLine2Name120

AddressAddressLine2OrderNumber120

AddressAddressLine2Phone120

TravisDBA,

I notice some tables where still being skipped after your latest changes. The query excludes tables without a clustered index.

To include them, modify the where clause to use (sysindexes.indid...

SanDroid,

You are right about the order. The columns types where still character because that is how sp_spaceused returnsthem. I updated the code with a a select that converts them...

Thanks ngreene for sharing your script. Without it this forum topic and sharing of scripts would not of happened.

SanDroid my visual tests show the results are the same for both...

Thanks for the article. It motivated me to look more into this sample tool and maybe make use of it.

At first I did not know what Execution Log Reports...

I found the solution I was looking for. I wanted to be able to use the installation GUI and still be able to specify the Analysis Services configuration folder location....

I recently discovered the space in the new table SQL_Sysprocesses was not being freed even though the delete old rows statement was successful for each package execution. To fix this...

Thanks for sharing your stored procedure. I was successful in creating and executing this stored procedure from a user database on SQL Server 2005 and 2008.

I was surprised that...

How many applications will be using these databases?

Database Mirroring and Window clustering both help with High Availability in different ways and both have limitations.

I look at Window clustering as keeping a spare server ready to go. It...

MaximumErrorCount is set for each container. For example Populate ADO Variable is set to 1 because if it can't set the variable there is no reason to attempt the other...

Some components such as fn_ServerInstanceName is included in the file attachment for the previous article: SQL Overview Part V[/url]

SQL Monitoring VI is coming out next week. Steve Jones must be planning ahead.

The scheduled job in the second step creates the temp tables on the local server. This allows the SSIS package to start.

Then when an item in the package connects...