Forum Replies Created
Viewing 15 posts - 37,951 through 37,965 (of 39,490 total)
-
RE: Is 0% Downtime Possible?
Thanks guys, I have long felt that it was impossible overall and have adopted the items mentioned. There is always some maintenance window, sometimes on the spur of the moment...
-
RE: Assigning value of a search
You can't really do this because the exec() statement essentially "shells" to another batch. The best way would be to build a table (perm or global temp ) and then...
-
RE: Clustering
In reading Pauls reply, I just thought of something. Has anyone tried to simulate clustering using instances? Or can anyone? Be curious to see if the "shared disk" can be...
-
RE: DTS job Failed, Pkg started manually and work.
Sorry for the late reply. Can you log into the server as the SQLAgent account and exucute them? Have you checked that none of the other packages have started running...
-
RE: Trigger Problems Part 2....
I agree with Brian with one addition. Identities can change so scope_indentity is a better choice.
Steve Jones
-
RE: sp2 to install or not to install
I tend to agree with Robert. Personally, I'm at SP1 (ss2k) and SP2 (sql7). Luckily we have Brian here who does extensive beta testing and reports feedback here.
I install on...
-
RE: Changing Destination name
You will need an Active X script or a Dynamic Properties Script that can alter the connection. Dynamic Properties is the easiest.
Steve Jones
-
RE: Security
I usually leave this one in as a precaution for forgetting or having the sa password changed. This way you can get back in.
Here he have an administrative poliy that...
-
RE: Abstracts for Articles
That would be nice. It would also help us in scheduling articles for publication.
Steve Jones
Viewing 15 posts - 37,951 through 37,965 (of 39,490 total)