Viewing 15 posts - 5,626 through 5,640 (of 7,429 total)
Just thinking but you could create another server alias thru client network utility and create the new linked server exactly like the old only using the new alias as the...
June 3, 2002 at 11:28 am
Right jsut define another linked server using the SQL ole connector is what I use.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 3, 2002 at 11:07 am
How are you retrieving your value, and can you post the relavent code?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 3, 2002 at 10:36 am
When you created your DTS packages did you create your SQL connections with sa and the blank password. To check open a package and do a save as from the...
June 3, 2002 at 10:28 am
I cannot duplicate this issue. Try dropping and rebuilding each index then check, you may have a corrupt index.
"Don't roll your eyes at me. I will tape them in place."...
June 3, 2002 at 10:17 am
That is where the problem lies. Then once you get this problem the only solution in every case I came across was to stop SQL otherwise it would just clock.
"Don't...
June 3, 2002 at 10:03 am
Then can you give an overview of what you need to accomplish as we need to understand the points of your situation?
"Don't roll your eyes at me. I will tape...
June 3, 2002 at 9:45 am
I do the same thing and get in fine with EM unless I open a QA or other session to the box. You must have something talking to the box...
June 3, 2002 at 9:39 am
Did you also set the AWE switch in SQL?
From SQL BOL
quote:
awe enabled OptionIn Microsoft® SQL Server™ 2000, you can use the...
June 3, 2002 at 6:33 am
The question I have is this when SQL has fully started it needs to run or before? If when fully then use Agent to create a job scheduled when Agent...
June 3, 2002 at 5:47 am
I have to ask too, considering it is just as simple to upgrade to VB.net and when compiled it compiles into the same machine language as C#, it is just...
June 3, 2002 at 5:18 am
As far as the copy of EM should not mater what disk it comes from as long as you have license for connecting to the server. This is why you...
June 3, 2002 at 5:07 am
GRN thnaks for pointing that out as I did forget, however you have to be carefull that the ALTER COLUMN matches exactly as the column is now or some things...
June 3, 2002 at 5:05 am
Your field must be an int column which it is trying to match the case. However, the value when submitted via a single variable like this is treated as a...
June 3, 2002 at 4:56 am
You can create a linked server to the AS400 system and potetntially get to the data. I have not done this but you can look in the search area for...
June 3, 2002 at 4:44 am
Viewing 15 posts - 5,626 through 5,640 (of 7,429 total)