Good article, anything that gets this many responses is, IMHO, a good article. Being a relative newcomer to the field (late 90's) I never had to deal with...

Yes, I understood what you needed except for the schedule part. I'm not sure how you would do this in SSIS. You could do an execute SQL Task...

Is this something you want to schedule or is it a 1-time thing? IF 1 time you can do it in SSMS by sending the results to a file.

It's a database error message that could be handled more gracefully by the application. It is related to either poor database design and/or the way in which the application...

Well, you'd have to find the location of the first numeric character using IsNumeric and then take that position to the right. You would probably want to use a...

The Optimizer chooses the near best way to get the data. Depending on the statistics for the index/column and the criteria entered. Now you have specified a non-clustered...

You can use sp_msforeachdb and set @command1 to "Select table_schema, table_name, column_name, data_type from infomation_schema.columns".

[font="Courier New"]sp_msforeachdb @command1 = 'Select table_schema, table_name, column_name, data_type from INFORMATION_SCHEMA.COLUMNS'[/font]

Here's an article about sp_msforeachdb: http://www.databasejournal.com/features/mssql/article.php/3441031

By default in SQL Server when you create a Primary Key it creates a CLUSTERED index. You can define the Primary Key to be non-clustered. Each table can...

There is a transaction it is just an implicit transaction that is being rolled back. In SQL Server 2005 you can use TRY CATCH error handling which I think...

Most SQL Server DBA's use SSMS because it is a good tool for managing SQL Server. There are other tools out there, but most of the good ones are...

A table scan in SQL Server means that the Query Processor has to read every row in a table in order to determine if the row should be returned by...

They do the same thing, just a slightly different syntax. I prefer using Convert. I believe CAST is more widely implemented by other database platforms.

I'd go with the lazy, as there is no way to do that.

I don't know if this works in SQL 2000 QA, but in SSMS you can drag the columns...

You do not want to us e@@IDENTITY. It returns that last Identity value which could be another table if you have triggers, etc... You want to use th...

IS the new column DEFINED as INT? If so you can't put the value 'NA' in a integer column. In the case you would want to use NULL...