Viewing 15 posts - 3,346 through 3,360 (of 6,216 total)
You can query master..sysprocesses where dbid=x. Or where db_name(dbid)='yourdb'. Then based on the count decided whether or not to allow the connection. Im curious why you're enforcing this restriction?
Andy
September 3, 2002 at 5:00 am
Usually you end up with a bit of both. If you can easily encapsulate business logic in a stored proc I dont see that as a bad thing. Easy to...
September 2, 2002 at 7:48 pm
Cant disagree with using scripting, though under the hood I imagine DTS is doing the same.
Andy
September 2, 2002 at 5:45 am
Can you update that thread with what you have for code now? We'll work on it some more! Also, what would you consider good examples of complex issues?
Andy
September 2, 2002 at 5:43 am
It is possible. One way would be if he explicitly created the tables with an owner name.
Andy
August 31, 2002 at 5:16 am
Doesnt matter where it installs to, its just uncompressing. From there you can run the setup.
Andy
August 30, 2002 at 5:01 pm
The table object has an owner property that is read write. If you want to change it using just pure TSQL use sp_changeobjectowner.
Andy
August 30, 2002 at 5:00 pm
I like the posts - not everyone subscribes to the security bulletins, good to do our part to make sure everyone knows!
Andy
August 30, 2002 at 2:22 pm
You can look at the log reader/distrib agent to see the latency. It'll vary depending on tons of things but the average is usually what they want. You can do...
August 30, 2002 at 2:21 pm
Didnt it used to be SQLConnection? Or was that a different one? Just in case, I did attend SQLConnection..last year? Wasnt bad. Havent looked at their speaker list lately, I...
August 30, 2002 at 4:11 am
Depends on what you're doing I guess. You can always compile it to an exe and run it from a job. Or probably use sp_oa~~ to run code in a...
August 29, 2002 at 1:56 pm
BCP is the fastest way. I'd start by getting that to work from a command prompt, once you have that, see if there is native support for it in DMO...
August 29, 2002 at 1:52 pm
Is there a bulk insert in 6.5? Not very familiar with DMO on 6.5 either, probably a few differences! What data format are you importing from? Can you use BCP?
Andy
August 29, 2002 at 1:22 pm
August 29, 2002 at 10:16 am
Probably worth looking into the deadlocks more. Shouldnt be replication, regardless of number of publications you're only running one log reader per db. It is common to have deadlocks in...
August 29, 2002 at 4:59 am
Viewing 15 posts - 3,346 through 3,360 (of 6,216 total)