Better use GUI instead of this query.

Good point Roy. Could you elaborate a bit as how to keep data in memory and use that? Are you talking from front end point of view? I am interested...

If you have to select all the rows everytime then better not to use any index.

I asked you the columns and size for your table. ie table script

eg: Table: Contact

Contactid...

As per my understanding MS DTC (Distributed Transaction Coordinator) is not required for the sake of linked server. You just create the linked server by using sp_addlinkedserver. MS DTC is...

Agree.

The requester can also go ahead and look for the granular level as how the table is created. Can you tell me the table structure?

Thanks Richard. This seems that some of the variable would have corrupted in mid and got NULL. Now this works.

Thanks again to all.

-Lk

Thanks Bru for correct links. This is how I should have executed from command prompt.

sqlcmd -S SQLServer05 -i C:\Test.bat

This is a demo which I am trying to run many sql queries in the batch file later. The batch file can contain the T-sql commands but I feel that...

Fred,

If this is a regular error then you need to figure out correct size of the log files. Did you mention automatic increment for log files? What about the free...

I would recommend only raid 10 for tempdb for principal as well as mirror. This is not a good option to use os drive for tempdb. raid 1 is mirroring...

There is following information from the sql server profiler:

2009-09-24 21:10:10.87 Logon Database Mirroring login attempt failed with error: 'Connection handshake failed. There is no compatible encryption algorithm. State 22.'. [CLIENT:...

There is some information on following link

http://archive.networknewz.com/networknewz-10-20080721SQLServerUpgradeDatabaseMirroringIssues.html

This looks relevant but should I need to reinstall the sql server as the auther of this article did :(?

How to completely drop previous...

There is following information from the sql server profiler:

2009-09-24 21:10:10.87 Logon Database Mirroring login attempt failed with error: 'Connection handshake failed. There is no...

george sibbald-364359, what is the meaning of "tablock hint used"? Do you mean we should not use tablock hint?

-lk

Oh this was the answer george sibbald-364359, I was looking at. Many thanks george sibbald-364359.