Viewing 11 posts - 31 through 41 (of 41 total)
The error I am getting is "Error Message -> Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
When I say...
May 6, 2008 at 8:28 am
The problem I had was resolved by fixing the DNS on the network. It happened in the process of merging multiple domains.
Sorry I can't help beyond that.
Bill Mell
April 24, 2008 at 8:08 am
I got it right only because I pretended that an nvarchar(50) only takes 50 bytes instead of the 100 it actually takes and that an nvarchar(100) only takes 100 bytes...
April 9, 2008 at 4:06 am
Works just fine in SQL 2000.
If you want to limit the question to SQL 2005 it should be stated.
March 31, 2008 at 3:55 am
Thanks for the good info.
Turns out the problem was a DNS issue.
I'm glad to have a better understanding of the SPNs now though.
October 24, 2006 at 5:02 am
I'm assuming that someone blew it and just listed the incorrect answer.
September 11, 2006 at 4:14 am
Good point. I will definately discuss these issues before doing anything.
March 23, 2006 at 12:18 pm
Thanks, that's what I was thinking.
March 23, 2006 at 11:50 am
Yep, they are identical. I figured the non PKs should be removed, but I was mainly just checking to make sure there is was not some good reason for...
March 23, 2006 at 6:56 am
These other indexes are identical to the PK (Except they are defined as non clustered, non unique indexes).
March 23, 2006 at 4:26 am
Try passing a table variable with the values instead of a varchar.
There is a good explanation of this here:
http://qa.sqlservercentral.com/columnists/aGrinberg/thearrayinsqlserver2000.asp
HTH,
Bill Mell
January 25, 2006 at 5:34 am
Viewing 11 posts - 31 through 41 (of 41 total)