Steve

I think what I would do is this:

(1) Import your file into a staging table

(2) Move the rows with no product or valid product to the destination table

(3) Handle the...

sp_MSForeachdb will return one result set for each database and therefore you can't put the results into your destination table with a single INSERT statement. You'll need to embed...

Steve

I'm finding it hard to visualise this. Please will you show us the table structure and sample data, the SQL to create the foreign key constraint, and some of...

Thom's right. Go to the Security tab on your Linked Server properties and change the connection to Be made using this security context, and enter your SQL login name...

Indeed. The double-hop issue means you can't use Windows authentication for your linked server unless you have Kerberos configured on the remote server. Have a read about it....

It sounds as if you're suffering from the double-hop problem. You need either to create a SQL login on the remote server for the linked server object to use,...

Yes, I did say "it may". It depends what you're familiar with and what the wider requirement is. I'm more comfortable with a single DOS command and the...

If you have xp_cmdshell enabled, it may be simpler to run a dir command and put the results into a staging table. You can then count the number of...

Your error has severity 16 - that will only abort the current statement, which means that your batch will continue to run after the error. Higher level errors (19...

Does the exception in the trigger raise an error message? What is its severity number?

John

My question is this: if you have 90GB of memory and more on your server, why not let SQL Server use it? But I agree, let's see the execution...

That's one thing eliminated, then. All that's left is either you don't...

The only way you can know is by actually restoring the databases. You can give yourself a headstart by using the CHECKSUM option in your backups, and doing RESTORE...

There's a big risk of SQL injection if you do it that way. Can you not have your presentation layer (Excel spreadsheet, SSRS or whatever) do the sorting? ...

If I've understood correctly, you want to load from one database and then from another and then from another. A config file is only for specifying properties of a...