I agree with Paul. My husband is currently working with ERP LN (former BAAN) and the column names are "horror"...:-)

No...Do as BOL, ALZDBA and Steve advise.

You can try to change this:

http://www.sqlservercentral.com/scripts/64793/

Add a join with sys.sql_modules to include the object definition.....

You should shrink the db only if you really, really need it - but not on a regular basis. Please take a look at

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx?pr=blog

Also...

Also make sure that the user can access only the db he needs, as a "db_datareader".

However, it would be better if the user had only the right to run certain...

Do you really need to move the records "in real time"? Otherwise, either follow Elliott's advice, or schedule a stored proc / SSIS package to periodically move a batch of...

See also http://pratchev.blogspot.com/2008/03/updates-with-cte.html. This is my favourite for SQL 2005...:-)

Consider using SSIS or the "import and export wizard".

See also http://msdn.microsoft.com/en-us/library/ms175937(SQL.90).aspx and http://msdn.microsoft.com/en-us/library/ms190923(SQL.90).aspx.

Can you list the exact steps you've done?

You cannot move the resource db, see BOL ---> Moving System Databases

Steve, Shawn, thanks for your quick responses.

Shawn - yes, that's what I'm already using ("MemberType"). While working on PS scripts, I try to build my own reference by copying the...

Right now I'm using mainly http://www.microsoft.com/technet/scriptcenter/topics/winpsh/manual/default.mspx and http://msdn.microsoft.com/en-us/library/cc281954.aspx.

As Grant says, it is not very easy...

Gaby, if it's legal, can you post details about finding that pdf?

See also http://msdn.microsoft.com/en-us/library/ms143693(SQL.90).aspx for some insight.

Performance might be better if you parse your file in .NET according to the data definition document.

See BOL ---> Understanding SQL Dependencies

Parsing the file in .NET (VB, C#) may be another solution - are there any specs about working with those files?