Other things to think about.

Architecture - think about server interactions, if there are too many interdependencies then it becomes very difficult to upgrade a server in isolation. If the interactions...

Main things to think about are

How do you install

How do you maintain

How do you monitor.

With 5 servers you can easily install and check things manually.

With 100+ it becomes a lot...

If you want to allocate an answer id then you might consider having another table to hold it then

update NextAnswerId

set nextID = nextID + 1, @SessionID = nextID +...

bcp is a command line utility so you need to use xp_cmdshell

master..xp_cmdshell

'bcp Integra.dbo.temp_Reporte_shpmnt in F:\Cerveceria\adw_39_FPP\Sp\MasterPlanning\enterprise\scp\data\solver_data\op_data\Shipment.sol /U user /P password /S server /c /t","'

for the bulk insert it usually gives an...

Other ways of creating a text file from sql server are osql, bcp, sp_makewebtask.

Usually the easiest is to create a global temp table and then use bcp to output it.

...

Anyone else frightened by vb.net?

EDL now there was a language (and machine); kept me off the streets for several years.

I'm very against the sp_foreach... SPs.

They use cursors (something I never allow) and I feel are more difficult to use than a temp table - and also lock you in...

I'm not suggesting you use it as it is a big overhead.

It can be used as a method of calling an SP and creating a temp table from the results...

>> getting ORACLE into organization means hiring DBA (or 2) and UNIX Admin...and pay them through the nose (well, it used to be this way 🙂

>> MS SQL Server is...

A temp table crated in an exec statement only has scope of that batch.

You can create a temp table with a dummy column, call the exec to alter the table...

You can probably do it with an exlicit collation convertion - something like

SELECT b.LastName, b.FirstName, a.ExpenseNo, a.EmployeeNo

FROM devExpense.dbo.ExpenseHeader AS a INNER JOIN devCorp.dbo.OrganizationEmployee AS b

ON a.EmployeeNo collate Latin1_General_BIN = b.EmployeeNo...

In the SP to populate the table you can have a finite number of entries passed, say 10, so your 20 values would only take 2 calls.

It is usual to...

Sounds like the two databases are defined with different collations and the server can't decide what equals means between them.

What do the applications do. You can use the profiler to log the interactions with the database.

You can set a task running which monitors sysprocesses for created and destroyed connections.

If...

There is no array data type but there are ways of simulating it.

Create a character parameter and pass the array in as a csv and parse it in the SP....