Viewing 15 posts - 38,056 through 38,070 (of 39,720 total)
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
March 7, 2002 at 11:34 am
Doesn't appear to like functions in the constraint. Either ignored or always fails.
Tried some variations:
1. Reverse logic
2. Change to char() and return the email in the function, check that the...
March 7, 2002 at 10:55 am
Some things I found:
From Neil Pike:
Q. What does sp_sdidebug do?
A. It is used to turn on or off TSQL debugging. There is no user interface for it and no documentation....
March 7, 2002 at 10:16 am
March 7, 2002 at 10:05 am
you are welcome and it was interesting. Hopefully others will learn as well.
Steve Jones
March 7, 2002 at 10:01 am
haven't seen anything and don't see a pwd column in the table.
I'll keep looking.
Steve Jones
March 7, 2002 at 9:58 am
Viewing 15 posts - 38,056 through 38,070 (of 39,720 total)