Viewing 15 posts - 3,331 through 3,345 (of 6,216 total)
You can execute scripts using DMO pretty easily. Make a lite QA for them to apply changes with, or possibly even build into your app - have a pickup folder...
September 4, 2002 at 4:21 pm
September 4, 2002 at 4:19 pm
September 4, 2002 at 4:18 pm
On the contrary, I did read the thread and even posted earlier. Everyone will have different opinions on what is best, mine not any better than anyone elses. So what...
September 4, 2002 at 10:15 am
September 4, 2002 at 10:11 am
Without too much more waffling, I'd recommend that you go with three tiers, put the business logic in the middle tier, use procs for all data access, keep in reserve...
September 4, 2002 at 9:06 am
We ran into this a long time ago, increasing the registry value did help for a while but eventually just proved unworkable. Combination of issues with not enough threads and...
September 4, 2002 at 8:44 am
I tested on SQL2000, I think changes required for SQL7 but I think concept might still work! I'd suggest making a backup of master at the very least before trying...
September 4, 2002 at 5:13 am
I think if you just checked for the number of connections to the db along with the app name (to rule out maint jobs, etc) you'd be ok, assuming you...
September 3, 2002 at 6:27 pm
Its undocumented, officially anyway. It along with the foreachdb are procs provided by MS that basically hide a cursor that cycles through all the tables (or databases) to run a...
September 3, 2002 at 6:22 pm
For the second param all you need is dbo, not dbo.t1.
Andy
September 3, 2002 at 12:27 pm
Trade offs everywhere, no way around that and no one answer fits all. Makes sense in some cases to take load away from your db server, let it do what...
September 3, 2002 at 9:59 am
You'll also get an error if there was more than one log file. Attach doesnt like it if one is missing, but you can work around.
Andy
September 3, 2002 at 5:06 am
Com or .Net, take your pick. We're moving to .Net at work for new projects, no plans to migrate everything. Yukon is rumored to have support for .Net languages in...
September 3, 2002 at 5:05 am
I dont think (have to dbl check!) that if you've got the user aliased some place that sp_dropuser will do it, might need sp_dropalias. Note also that sp_dropuser is deprecated,...
September 3, 2002 at 5:03 am
Viewing 15 posts - 3,331 through 3,345 (of 6,216 total)