Viewing 15 posts - 37,486 through 37,500 (of 39,510 total)
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
AFAIK, you have to do this with some application. The Services applet in Control Panel is the most frequently used one. There might be a command line as well.
Steve...
May 24, 2002 at 9:26 am
You would use a text or binary column and do a standard insert. You might need to replace some items, like single quotes within your file.
Once inserted, you can query...
May 22, 2002 at 1:28 pm
May 22, 2002 at 1:25 pm
Good advice above. Keep in mind when explaining that the KISS principle also helps maintain a stable environment. This tends to violate that.
Steve Jones
May 22, 2002 at 1:23 pm
I saw somethign similar and it was a client installation issue. You might try reinstalling the client tools.
Also, what SP?
Steve Jones
May 22, 2002 at 1:20 pm
I don't think there is anything. You could develop some audit item if you switched to stored procedures that would capture the spid.
Profiler will do this, but that might be...
May 22, 2002 at 1:19 pm
Viewing 15 posts - 37,486 through 37,500 (of 39,510 total)