Viewing 15 posts - 11,041 through 11,055 (of 26,486 total)
Can't see anything wrong with the SQL itself, other than I can't run it since I don't have your tables. I would change your CAST's to use NVARCHAR instead...
June 26, 2012 at 12:54 pm
Can't help you as long as we can't see what you see. Would help to see the DDL for the procedure in question.
June 26, 2012 at 12:26 pm
The named instance you connected to is SQL Server 2000. You are Using SQL Server 2008 R2 SSMS to connect. Are there other SQL Servers? Were you...
June 26, 2012 at 12:06 pm
FutureQueryArtist (6/26/2012)
June 26, 2012 at 12:00 pm
gciszewski (6/26/2012)
Here is what mine say's it is. Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c)...
June 26, 2012 at 11:48 am
We will need to see the proc as well. Where exactly are you getting the error?
June 26, 2012 at 11:31 am
Couple of questions.
Where are the servers located, are they geographically separated or in the same server room?
Do you have this problem with all of your mirrored databases or just specific...
June 26, 2012 at 11:23 am
Kasnut (6/26/2012)
June 26, 2012 at 11:14 am
anarayanamoorthy (6/26/2012)
Please find attached the output from mirroring server too.
I'm sorry, what part of "the picture doesn't show everything" don't you undestand? What is there doesn't really tell me...
June 26, 2012 at 11:02 am
We really can't answer your question based on what you have posted and we can't see from here what you see there either. When you say the string value...
June 26, 2012 at 11:00 am
anarayanamoorthy (6/26/2012)
Please find the output from witness server.
First, it doesn't show all the fields (columns). Second, doesn't really provide much information other than the witness is involved in several...
June 26, 2012 at 10:58 am
Revenant (6/26/2012)
Lynn Pettis (6/26/2012)
bitbucket-25253 (6/26/2012)
Any one interested in convincing this OP that for a development / design / implementation contract as a consultant they would help him/her solve their problem.http://www.sqlservercentral.com/Forums/Topic1321325-391-1.aspx
As...
June 26, 2012 at 10:44 am
Sqlism (6/26/2012)
But I am successfull in logging with the same password on SQL Server.
Same password, different username?
Have checked the properites of the login that failed to see if it...
June 26, 2012 at 10:34 am
sturner (6/26/2012)
If the royalties they collected...
June 26, 2012 at 10:29 am
The beauty of the community!
June 26, 2012 at 10:24 am
Viewing 15 posts - 11,041 through 11,055 (of 26,486 total)