Viewing 15 posts - 37,921 through 37,935 (of 39,720 total)
Not through SQL . There might be acess with some extended stored procedures. If you can put the batch file on there, you can access it through xp_cmdshell.
Steve Jones
April 1, 2002 at 2:28 pm
April 1, 2002 at 2:27 pm
Sounds like a bad network connection. Do you ahve any other network issues with other apps?
Steve Jones
April 1, 2002 at 10:48 am
Not sure what this is, but my thought wouldbe a data mirror is like a replication technology that would keep a mirror of the data somewhere.
Steve Jones
April 1, 2002 at 10:47 am
April 1, 2002 at 10:45 am
You are calling more than 32 procedures. The nesting is a stack of the callers of the program and it is limited to 32. The DTS package may be one...
April 1, 2002 at 10:42 am
there is Bulk Copy.
You can also use xp_cmdshell and isql to do this. Use the -Q and -o options with isql.
Steve Jones
April 1, 2002 at 10:38 am
Can't do this unless you can get command access and script something to hit the registry.
I have a method to access using Secure Shell (secure Telnet) if you have a...
April 1, 2002 at 10:36 am
You could use recursion,but it be very dangerous and I do not recommend it. I've easily screwup up a desktop with recursion and I'd hate to whack my db server...
April 1, 2002 at 10:33 am
Haven't tried this, but since you have a partial log, I'd doubt you can do this.
Steve Jones
April 1, 2002 at 10:29 am
April 1, 2002 at 10:19 am
Are you sure these are orphaned? Are there still sessions running on Citrix? You can disconnect and your session on Citrix wouls stay open, so your connection would be open....
April 1, 2002 at 9:58 am
March 29, 2002 at 9:47 am
Great information above and some good points. Something else to consider, there are some business processes that are better not performed in SQL. The server is a limited resource and...
March 29, 2002 at 9:28 am
March 29, 2002 at 9:20 am
Viewing 15 posts - 37,921 through 37,935 (of 39,720 total)