Viewing 15 posts - 37,876 through 37,890 (of 39,901 total)
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
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
Viewing 15 posts - 37,876 through 37,890 (of 39,901 total)