Each node is a "box", so for a two-node...

Dev (11/11/2011)

---

Well I can understand the scenario & your worries / frustration as well. I have experienced it. I don’t remember exact code that caused the issue BUT...

The error message tells you what you need to know. You can't use the same physical files for a different database. You have to specify new files.

John

Lee

(1) http://www.sqlservercentral.com/articles/Administration/2960/

(2) That's the Windows version.

John

Never code an application so that a transaction waits for user input. You'll have too many locking issues when users forget to complete their work before they go off...

If you're just executing a simple insert, why do you need an explicit transaction? If you want to do it like this, I think you'll need something in your...

You could try searching for "gaps and islands" - this looks like a similar principle to that.

John

Instead of GETDATE()-1, try DATEADD("Day",-1,GETDATE()).

John

So you want the date in the file name always to be yesterday's date? Best way to do that is to do some date arithmetic and take one day...

SSIS isn't free, but it comes with the product, so it won't cost you anything extra to write a package that will connect to each server and get the information...

Good work, Cadavre, especially generating all those random postcodes! The following are also legal postcodes, and I've checked that your code also works with them:

'N12 4DB'

'SW1A 4DB'

'W1B 4DB'

'L1 4DB'

'LS1...

I'm afraid I don't understand what the difficulty is. Just give the SQL Server Agent service account the necessary permissions on the share and everything should work.

John

Yes, we have no DDL or sample data, so it's difficult to visualise and impossible to test. However, are those nested statements necessary? This should work:

case when bh_type...

You should be able to do everything with UNCs. You haven't said what operations you'll be carrying out on the folders, so I'm just guessing, but if you keep...

Yes, you can do this. Read about package configurations. You can take any property of the package (for example the location of the text file to be read...