Viewing 15 posts - 3,991 through 4,005 (of 6,216 total)
I've had this same issue on my list for a couple weeks hoping to get to it. Best work around I've though of so far is to use replication -...
June 18, 2002 at 3:32 pm
Not sure its a bug, after all, doesnt changing the password solve the problem? Deny makes sense for NT logins since SA doesnt have any way to force a change...
June 18, 2002 at 3:29 pm
Most people use both. I've got an article coming out next week that talks about this topic some.
Andy
June 17, 2002 at 5:29 pm
Certainly there has to be a bit more overhead with a GUID, but not much, and you can leverage the fact that you can create them client side which is...
June 17, 2002 at 10:51 am
With SQL2K you can use a Bigint - that might buy you a little time. Uniqueidentiers should give you unlimited usage.
Andy
June 17, 2002 at 7:24 am
Not sure what you're asking. How to come up with the scripts or how to apply them? If it's something you're doing that frequently I'd look at having a more...
June 17, 2002 at 5:51 am
Couple comments, I sure others will have more. First thing I see is you need to confirm that you have space to support 5 weeks worth of backup - 5...
June 17, 2002 at 5:50 am
Nothing wrong. It can take anywhere from a few seconds to several hours for SQL to generate the snapshot, which consists of scripts for the tables and indexes, plus BCP'ing...
June 17, 2002 at 5:13 am
If you're trying to retrieve description info that was added to the db schema, you'll find it in sysproperties.
Andy
June 16, 2002 at 10:45 am
With ADO you should get a meaningful error message back if the record has been deleted. If you do an update via stored proc you'll need to return status, either...
June 16, 2002 at 10:42 am
Try this one (this is actually an article about using it):
http://www.fawcette.com/Archives/premier/mgznarch/vbpj/2001/08aug01/gs0108/gs0108.asp
Andy
June 15, 2002 at 5:27 pm
The command line version of PKZip should work, there is also a freeware dll that you can use I think. I'll see if I can find it for you.
Andy
June 15, 2002 at 5:06 pm
Sorry to complain but it gives me a headache! On my workstation with nothing much in SQL at the moment it shows a table scan across 17k rows, but returns...
June 14, 2002 at 8:14 pm
June 14, 2002 at 7:24 pm
What happens if the empowered user logs in and then leaves the app open, same problem isnt it? We normally use a screen saver lock to make sure nothing gets...
June 14, 2002 at 1:43 pm
Viewing 15 posts - 3,991 through 4,005 (of 6,216 total)