This is an often a debated topic. Store the .jpgs in the filesystem and the path in the db or store the image in the db. I vote for the...

You cannot do this. You need to setup a linked server to access another sql server from T-SQL.

Steve Jones

steve@dkranch.net

secure shell, vpn, export to file and encrypt the file and then ftp the encrypted file (or other transport).

Steve Jones

steve@dkranch.net

OK, I'm slightly confused, but here are some things to note.

For each SQL Server instance, there is an MSSQLServer service and a SQLAgent service. There may be others, but these...

Put them in a temp or perm table and then Bulk Copy them out.

Steve Jones

steve@dkranch.net

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...

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...

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

steve@dkranch.net

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...

need a go after use master.

Steve Jones

steve@dkranch.net

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...

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...

Agree with both above, in case anyone is readng this thread.

Steve Jones

steve@dkranch.net

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,...

Not in T-SQL. You would have to do this with some fancy scripting.

Steve Jones

steve@dkranch.net