Hi Thomas,

Your point is well taken. For the specific example you have mentioned, you could use:

sp_MSforeachtable

@command1 = "Alter Table ? Alter Column Foo nvarchar(10)",

...

Assuming that all 8 errors lines show the exact same output, you could perhaps create a staging table and send the errors into it. This would cause the table to...

Assuming that all 8 errors lines show the exact same output, you could perhaps create a staging table and send the errors into it. This would cause the table to...

If you are okay with a non-conventional method, you can check my article: http://www.sqlservercentral.com/articles/XML/63687/

Thanks for the excellent interview series and all the useful information between the questions!

I believe you will need a tool like Red Gate's SQL Data Generator. Check: http://www.red-gate.com/products/SQL_Data_Generator/index.htm. Not aware of any opensource/freeware to do this.

Girish

Isnt this question, the same as:http://www.sqlservercentral.com/Forums/Topic645577-5-1.aspx

Do you see the order changed when you import the data? Can you check if the tables into which the data is imported have any clustered indexes which cause sorting...

I dont think there is a direct T-SQL command to do that. But if you have to use T-SQL only, here is one way:

1. Schedule the package in an SQL...

You mean you want to a script to generate 1 GB of realistic test data? Or is this for migrating data existing in one DB to be inserted into another?

Check these links. You may find something helpful:

http://www.sql-server-performance.com/faq/function_in_view_yields_nondeterministic_results_p1.aspx

http://msdn.microsoft.com/en-us/library/ms178091.aspx

When you say "print", where do you want to print? I believe you mean you want to record the DDL commands into some kind of an audit table, right?

Check out...

I am not sure of your SGen error and the permission errors are related. For the SGen error you may want to look at the link: http://social.msdn.microsoft.com/Forums/en-US/asmxandxml/thread/fa59738e-11e1-45f8-a81f-613c6bb377db/ ....

What is the permission you used when you executed your CREATE ASSEMBLY statement? Also, are you using any Message Boxes within your CLR code?

blandry (10/9/2008)

---

....Reading your article it seems this tool would be more work than what can be done fairly quickly in SSIS. Besides the GUI versus command line differences, are...