Because dynamic sql is almost always a bad idea, especially when you're executing it like this with no validation or checking for sql injection.

What do you mean WTF?

XML is a perfectly valid way of passing multiple parameters (and full records) to a stored proc without the need to resort to dynamic SQL.

Carlos, your...

Depending on what environment you're in (DTS, SQL 2005, .Net etc) here is a simple vbscript that will load your document and count the numbers of elements you need. ...

See http://www.connectionstrings.com/

and look under sql server 2005

Very vague and misleading question. Although still not considered part of the xml content as such certain very important things do precede the root element such as processing instructions,...

I knocked this script up to copy either all or a set of listed dts packages from one server to another. If it already exists on the destination server...

You should find this link helpful.

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=179&rl=1

The creation of multiple tempdb files (not databases) be processor number of to do with the parallel processing nature of SQL Server enabling it access a thread per processor for...

The creation of multiple tempdb files (not databases) be processor number of to do with the parallel processing nature of SQL Server enabling it access a thread per processor for...

I would suggest either

a) going through the pain of creating the transformation for each file/table once and place them all in the same package so multiple imports can run at...

Firstly you need a zip product that allows you to automate it via script, either through automation (COM) or through the command line (shell). Winzip has a command line...

I don't know if it's relevant but can't you download SQL Server Express 2005 with Advanced Services that allows you to do Reporting Services (as well as other things) now...

Is the sysadmin answer correct ? Below is an extract from http://msdn2.microsoft.com/en-US/library/ms345106(SQL.90).aspx

To create an EXTERNAL_ACCESS or UNSAFE assembly in SQL Server, one of the following two conditions...

Don't know if you considered this but it is also possible to create a CHECK CONSTRAINT, referencing a UDF which performs the cross database check hence enforcing DRI.

melster,

I'm not sure what you're asking but, if you want a very specific output schema, as you mention above, I think you will probably have to use FOR XML with...