you'll need to insert the flat file into a staging table...the flat file doesn't contain a varbinary string, right?

so you stick it in a table of the right data type,...

whoops i didn't read your quesiton completely. ; i was assuming a non-clustered setup;, i thought we were talking single server/3 ip's / 3 instances.

my mistake i think.

I think you'll have to modify each instance to listen to one IP address; then change the port on that one IP address so that it's 1433.

no instance should listen...

is exactly the same as

SELECT * FROM TableABC bananas

In the above, the word after the table is just an alias.

This is...

i would consider looking at whatever query the current code returns, and build a view of THAT, and fix the code to pass parameters for the WHERE clause;

there's a lot...

SQL is very similar, and there's two ways:

select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='POS_TRANSACTION'

--or

select OBJECT_NAME(object_id) As TableName, name As ColumnName from sys.columns where name ='POS_TRANSACTION'

a nolock on an update is ignored anyway, so there's no advantage to adding it anyway.

only SELECT statements will honor NOLOCK, and then you get the usual possibilities about doubled/repeated...

03sunil (3/28/2013)

We have similar kind of issue, We have 9 instances running on windows 2008 box. All are 2008 R2 instances. We have problem with only one instance.

We are not...

your trigger is on the table TEST, but the update command is looking at a different table;

shouldn't that be...

Thanks for the insight guys; I'm still hoping for some more suggestions.

My non profit wouldn't even spend the five dollars per mailing, but would love for me to invest hundreds...

the command you posted is from MYSQL;

SQL doesn't do file writing operations directly, you typically would use BCP OUT, or a CLR, or an application to write to disk when...

it's like...

...ORDER BY ?

BIDS is a trimmed down version of VS2010 with the project templates related to Business Intelligence installed.

i have VS 2010 professional, and I have SQL 2008 standard installed on my...

based on your example code, Lynn's post, barely modified for the column name, works perfectly:

declare @SQLCmd nvarchar(max);

select

@SQLCmd = stuff((select N'union select MFG from ' + TableName...