Viewing 15 posts - 37,786 through 37,800 (of 39,456 total)
A linked server is your only real option if you cannot copy data. This merely allows one server to query the other server.
If you do not want a linked server,...
March 12, 2002 at 9:57 am
If you have a second server, here's what I did:
1. Install SQL 7 on server B
2. Script all objects on Server A, execute this on Server B
3. bcp all data...
March 12, 2002 at 9:40 am
Thanks for the notice. I went through this last August. I guess they've raise prices. Not sure I'd do it at $699. I did learn quite a bit and it...
March 11, 2002 at 11:31 am
March 8, 2002 at 4:31 pm
I believe you can distribute the DTS componnents, but don't have a list of stuff. I'll try to look for one.
Steve Jones
March 8, 2002 at 11:33 am
March 8, 2002 at 11:29 am
I know it's a pain, but can you post all the vlaues from the Agent properties tab?
Also, where is SQL installed? physical path.
Did SP1 get installed?
Steve Jones
March 8, 2002 at 10:35 am
1. at a low level, loading an integer into the CPU register is a one step operation. The comparison is the third (the second load is for the other...
March 8, 2002 at 10:00 am
Somewhat. A table type allows you to manipulate a set of data in a stored proc. Tempdb is vastly improved. In v6.5, there was contention on sysobjects when adding a...
March 8, 2002 at 9:52 am
That's really interesting. Didn't know that.
I have another suggestions which is what we used when migrating to a new server in another state.
1. We copy a backup to the new...
March 8, 2002 at 9:50 am
If you are stuck with Word, I would think you could use automation and scripting to do this. I'd tackle one in a .vbs file first and then work on...
March 8, 2002 at 9:47 am
Couple things. Is the server running as Local System or a domain account? How are you connecting? Your account, rights, etc.
Steve Jones
March 8, 2002 at 9:36 am
I did some checking because this intrigued me. It appears that UDFs are valid in check constraints, but it doesn't want to work. Tried a bunch of variations, even returning...
March 8, 2002 at 9:34 am
Mostly agree with Antares. If you can do downtime, detach, copy, attach. If not, backup/restore
Steve Jones
March 7, 2002 at 7:35 pm
Have you rebooted? Did this start today? Was it working ever? When was it working?
Something changed.
check the account under which it runs. Try running it as LocalSystem and see what...
March 7, 2002 at 3:34 pm
Viewing 15 posts - 37,786 through 37,800 (of 39,456 total)