Viewing 15 posts - 37,426 through 37,440 (of 39,456 total)
Sylvan-Faust makes one. Also SQL 2000 has one built into query analyzer.
Steve Jones
May 30, 2002 at 10:10 am
run sp_configure and up the number of connections. Also, check sp_who for an accurate count of users.
Steve Jones
May 29, 2002 at 9:18 pm
Not sure. I've started it, but can't find time to finish it. I hope to have it by end of June.
Steve Jones
May 29, 2002 at 3:48 pm
May 29, 2002 at 3:41 pm
Increase your timeout as well. If the network or server are busy, the defaults don't cut it.
Steve Jones
May 28, 2002 at 9:44 pm
You can do this, but you need a domain account at the remote facility. If it's a standalone server, then you need a local account on the machine.
Steve Jones
May 28, 2002 at 9:42 pm
Tend to agree with replication. It works well. I prefer log shipping, but you have to have the tolerance for some data loss.
If you have a high speed link, then...
May 28, 2002 at 1:22 pm
Inside the trigger, you can select * from inserted to see the new values, select * from deleted to see the old. You can compare these, join the tables, even...
May 25, 2002 at 11:56 am
May 24, 2002 at 10:21 pm
There is a bug that the text columns have to be the last columns in the query returned. For ASP/ADO.
Steve Jones
May 24, 2002 at 10:20 pm
Not sure about PB, VB isn't bad. Visual Fox will have a higher learning curve and easier to get into trouble without great benefits of VB unless you are doing...
May 24, 2002 at 5:54 pm
select rights will give them the structure. Not sure about FKs, Rules, defaults, etc.
Steve Jones
May 24, 2002 at 5:52 pm
I had some bad indentity issues in SQL v6.5, but nothing in v7/2000. Of course, they havne't crashed either.
Steve Jones
May 24, 2002 at 10:36 am
Interesting. I vaguely remember the Pet. Was that before the Vic-20? I remember having one with a tape drive.
Manuals have definitely gotten worse, maybe because of the info available on...
May 24, 2002 at 10:35 am
There is no array construct in SQL, but there is a table datatype, which is similar.
If you are looping, you are not really using SQL, instead, you would want...
May 24, 2002 at 9:40 am
Viewing 15 posts - 37,426 through 37,440 (of 39,456 total)