Viewing 15 posts - 36,376 through 36,390 (of 39,771 total)
Hmmm, that's an interesting one. I suspect the only way is to block 1433 at the NIC level using the Windows networking setup. Use the IP config for the nIC,...
April 28, 2003 at 12:59 pm
Are you running the application terminal services or the remote admin? We run remote admin here and it doesn't impact very much. Running app mode will impact more as the...
April 28, 2003 at 10:08 am
You can also move on a backup and restore, but I would follow Allen's advice if you just want to move an existing db.
Steve Jones
April 25, 2003 at 10:18 am
Is there a reason you can't schedule it to run every minute?
You could do an xp_cmdsheel and "dtsrun" it, but I wouldn't recommend it. If you schedule it, then you...
April 24, 2003 at 11:48 am
Sorry, you're right. For some reason I misread your post.
But the last posts isn't right. Your W2K std will use all 4 CPUs, but the first virtual or logical processor...
April 24, 2003 at 8:44 am
you can set showplan_text on and post that. I'd be intersted to see as well. Pls include table DDL, insert trigger, indexes.
Steve Jones
April 23, 2003 at 9:23 am
Incorrect, the BIOS should enumerate:
CPU #1, Logical #1
CPU #2, Logical #1
CPU #3, Logical #1
CPU #4, Logical #1
CPU #1, Logical #2
CPU #2, Logical #2
CPU #3, Logical #2
CPU #4, Logical #2
http://www.microsoft.com/windows2000/docs/hyperthreading.doc -...
April 23, 2003 at 9:20 am
Thanks. It was one of those little trivia things, but still it might help someone.
Steve Jones
April 23, 2003 at 9:15 am
This isn't a SQL Server thing, it's a SQL thing. The join clause is used first to pick the rows, at which point the rows with Master(5) and null details...
April 23, 2003 at 9:14 am
You can also use the Dynamic Properties task to change the target file based on a select select, which could build the file name.
Steve Jones
April 23, 2003 at 9:05 am
One note, if the log was this big initially, then you can't shrink below the initial size.
That being said, shrink it and see, you may need help and there's a...
April 23, 2003 at 8:59 am
Agree wtih Andy. Can't do it if they are sysadmin. I doubt they need sysadmin access, most apps don't. I'd lean on them to use a regular user.
Steve Jones
April 23, 2003 at 8:51 am
Setup a job to copy and or email them. Give them access to the new location. Could easily be another server. You could even automate this to run every hour.
Steve...
April 23, 2003 at 8:43 am
The search includes the forums. Doesn't break them out as a separate item though. Try searching for "oracle" and you'll see.
Steve Jones
April 23, 2003 at 8:40 am
Viewing 15 posts - 36,376 through 36,390 (of 39,771 total)