Max Mulawa (8/5/2008)

---

Hi Jack,

I think this is pretty brave advice to tell to replace clustered index on the table with nonclustered one. What about other queries, maybe it’s being used...

It sounds like you could make this work. Without knowing what the errors are it is hard to suggest any solutions though.

By using dynamic sql your parameters are going out of scope. If this is how you have to do things lookup sp_execute_sql in BOL and use it. ...

The error is saying that some of your data IS being truncated which means that the length of either name or desc in the statecodes table is not set long...

It sounds like you are not setup to be able to deploy reports to the Report Server. You need to get into Report Manager and make sure you are...

Even with Outlook installed I wouldn't call using SQLMail the easy way out. ...

Your code does not work because you reference the Insert table, which, unless you have created it in your database, does not exist. I think you want the virtual...

At my last job we used XP_SMTP_SENDMAIL (http://sqldev.net/xp/xpsmtp.htm) on all our SQL 7 and 2000 servers so we could get away from SQL Mail except for alerts and failed job...

You need to use a For Each loop container. Set the Enumerator to For Each File. Then you can apply a criteria for the file name like tr*.csv...

sonia (8/5/2008)

---

thanks. actually i am trying to insert the result set obtained from the edge table ( for the first example) into a table already created in the database. but...

Check out this blog post:

http://zulfiqar.typepad.com/zulfiqars_web/2006/11/ssis_passing_pa.html

This is probably overly simplified, but here are the basics. Statistics are a histogram of the values in an index or column that the query optimizer uses to determine the...

The single quote " ' " is the string "wrapper" in SQL Server so whenever SQL Server encounters it, it thinks it is the start of a character string. ...

I don't know, based on your time in the field from your recently posted article, I feel like I need to show you proper respect and call you "Mister". ...

Jeff Moden (8/4/2008)

---

Jack Corbett (8/4/2008)

---

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...