Viewing 15 posts - 6,166 through 6,180 (of 7,429 total)
Will LocationID always be 1 and 2 or other possiblities? If other then do you have a field that will uniquely ID Russ in you example?
"Don't roll your eyes at...
May 2, 2002 at 4:51 am
First try sp_resetstatus to try and bring db back online. (I do suggest backup the db file by stopping SQL and make a copy beforehand then restart SQL which may...
May 2, 2002 at 4:43 am
Duplicate post, see http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3959&FORUM_ID=8&CAT_ID=1&Topic_Title=Merging+many+rows+into+one%2E&Forum_Title=T%2DSQL for responses.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 2, 2002 at 4:39 am
Unfortunately -2147467259 applys to a lot of possibilities. Do you have the exteneded message that was returned. Also you will most likely need to step thru the code in debug...
May 2, 2002 at 4:34 am
I agree with Clive. Go to management and explain the various impacts that having the SA account used and not having a password to protect from intrusion can have then...
May 2, 2002 at 4:28 am
Just a little twist on the other but I believe short of doing a temp table this is possible. However the fact that esum_AVGScore is a calculated field and caoont...
May 1, 2002 at 8:06 pm
2 things , 1 can you post the table DDL so I can see if there is something key maybe about the another field or the table itself. 2 run...
May 1, 2002 at 6:55 pm
Are you redefining or trying to use the connection being refered to more than once. If so the consider using Precedence Constraints as they will allow you to control flow...
May 1, 2002 at 6:52 pm
Duplicate post see http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3940&FORUM_ID=5&CAT_ID=1&Topic_Title=DTS+Error+Message&Forum_Title=Administration for posting.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 1, 2002 at 6:43 pm
One possiblility is the OS as NT and 2000 only support this method. Also I don't remember but could be something to do with the protocols installed on the one...
May 1, 2002 at 4:04 pm
quote:
"Server: Msg 170, Level 15, State 1Line 1 Incorrect syntax near vac_available".
?You get this...
May 1, 2002 at 3:59 pm
First let me get an idea of a few things. 1 how much RAM and HD space do you have (what type of HD setup)? What version of SQL and...
May 1, 2002 at 3:58 pm
The error about nested to a level of 10 usually means you did something like this
EX
CASE colx
WHEN 1 THEN CASE coly
...
May 1, 2002 at 3:47 pm
Look at sp_dropmergepublication and sp_dropmergesubscription in BOL. These should help.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 1, 2002 at 3:40 pm
If it is a fresh install of SQL and no critical data on the server then run uninstall then do reinstall and choose custom to make sure you can get...
May 1, 2002 at 3:39 pm
Viewing 15 posts - 6,166 through 6,180 (of 7,429 total)