Viewing 15 posts - 39,166 through 39,180 (of 39,509 total)
Not necessarily. There may need to be routing changes as well in the default gateway.
I can ping my def gateway, but one of my servers is on a another LAN...
October 29, 2001 at 2:33 pm
Alternatively, if this is something you will do and not change, or something that is a snapshot of data and not subject to concyurrency issues, you can create a temp...
October 29, 2001 at 11:14 am
If you want all items between today and some sepcified date, then DATEDIFF will work.
This script:
-- today - today's date
-- future date - end of time for which we search.
create...
October 29, 2001 at 11:08 am
Two ways:
1. you can schedule the 1st of the month (or any day) and say every 12 months. Easy in the GUI, have to search in BOL for the script,...
October 29, 2001 at 10:48 am
October 29, 2001 at 10:41 am
October 29, 2001 at 10:41 am
Also, Inside SQL Server by Kalen Delaney is a good resource for this. Pg 926.
Steve Jones
October 29, 2001 at 10:39 am
So far I haven't found one (I'd like to do this as well), but I'll keep looking. Pls post if you find one and I will do the same.
Steve Jones
October 29, 2001 at 10:36 am
Thanks for the info, however beaware that he can change the design of the cube and mis-represent data. Be sure someone reviews the code and application before distributing the data...
October 29, 2001 at 10:35 am
October 29, 2001 at 10:33 am
October 29, 2001 at 10:31 am
October 29, 2001 at 10:21 am
I'm not sure this is a worst practice for a couple of reasons. I tend to agree that a complete DB is a bad idea in almost all cases, especially...
October 29, 2001 at 10:18 am
try dbss freeproccache to remove all query plans, then recompile the sproc (or sp_recompile.
Are you sure this is the exact same code? I might try recompiling the actual code to...
October 26, 2001 at 4:19 pm
October 26, 2001 at 4:17 pm
Viewing 15 posts - 39,166 through 39,180 (of 39,509 total)