Viewing 15 posts - 37,651 through 37,665 (of 39,456 total)
April 2, 2002 at 9:45 am
Ran this in Northwind:
alter procedure spTwo
as
declare @i int
select @i = orderid
from orders
return @i
go
alter procedure spOne
as
declare @j-2 int
exec @j-2 = spTwo
select * from orders
where orderid = @j-2
return
spOne
Created DTS package that...
April 1, 2002 at 3:06 pm
What is the package? does it work when you run it manually from the server? I have had some issues with ActiveX tasks that use the FileSystemObject. I have to...
April 1, 2002 at 2:58 pm
April 1, 2002 at 2:56 pm
Hard to move that port and match things up dyanmically. not sure it helps because anybody can still scan. The best thing is to VPN in somehow. Secure shell, PPTP,...
April 1, 2002 at 2:55 pm
April 1, 2002 at 2:29 pm
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
Viewing 15 posts - 37,651 through 37,665 (of 39,456 total)