Viewing 15 posts - 38,356 through 38,370 (of 39,901 total)
Probably when you run this, there is more of a hit than you need, but if it doesn't run that often, might not be worth it. Of course, it depends...
February 25, 2002 at 11:55 am
It should be possible technically, but over dialup there may not be enough bandwidth. Also, it the sizes grow there may not be enough time to send this via dialup...
February 25, 2002 at 11:50 am
backup database <db name> to disk <disk file path and filename>
backup transaction <db name> to disk <disk file path and filename>
If you need to shrink the log, it doesn't always...
February 25, 2002 at 11:43 am
Yikes? How often would this change? If not often, I'd spend the effort to write the stored procs to handle each case and return the right results. It is a...
February 25, 2002 at 11:37 am
It's pretty easy to build a web interface to allow edits. That would allow you to trap the changes.
Alternatively you could get a copy of Log Explorer (see our newsletter...
February 25, 2002 at 11:35 am
In SQL this would be a compound PK. You could setup two fields as the PK with
ALTER TABLE dbo.<xxx, char( 32), TblName> ADD CONSTRAINT
Table_PK PRIMARY KEY NONCLUSTERED
(
FieldA Int
...
February 25, 2002 at 11:19 am
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...
February 25, 2002 at 11:17 am
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...
February 25, 2002 at 11:13 am
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...
February 25, 2002 at 11:10 am
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...
February 25, 2002 at 11:08 am
I agree with Brian with one addition. Identities can change so scope_indentity is a better choice.
Steve Jones
February 25, 2002 at 11:06 am
February 25, 2002 at 11:04 am
February 22, 2002 at 10:05 am
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...
February 22, 2002 at 10:03 am
February 22, 2002 at 9:59 am
Viewing 15 posts - 38,356 through 38,370 (of 39,901 total)