Viewing 15 posts - 37,696 through 37,710 (of 39,506 total)
April 2, 2002 at 10:04 am
I've thought about using a COM component and am not opposed. The thing I really like about this method is I can copy a single file (.DTS) to a SQL...
April 2, 2002 at 10:02 am
I have seen this before when the SQL Server cannot see the domain controller. It cannot authenicate the use.
Can other users connect with NT Auth? Check the server event...
April 2, 2002 at 9:58 am
If there is only one log file, you can delete it and only restore the database file. The system should create a new log file for you.
Steve Jones
April 2, 2002 at 9:55 am
I have a resource page about SQL mail at:
http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp
There is a procedure for Notes. I have not tested it, but you can email the author and see if he will...
April 2, 2002 at 9:51 am
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
Viewing 15 posts - 37,696 through 37,710 (of 39,506 total)