If you're new to SQL Server then use SQL Server Management Studio (SSMS) GUI to point-and-click your way through the configuration. Open SSMS, connect to the database instance...

I support half a dozen SQL Server 7.0, around 10 SQL Server 2000 instances, around 30 2005 instances and 30 2008 instances, about 5-10 2008 R2 and no Denali.

All in...

Thank you! I knew it would be something simple. And you're right, my script was built on the fly whereas Michelle has obviously put a lot of work...

You're nicer than me. The tinyurl in my post above is a lmgtfy to the BOL.

Marvellous work there. Thanks Grant & Ninja 😎

I think he means 'login' rather than 'log in'

404 error, could you check the link please?

That's right, yes. From Microsoft:

TIMEOUT integer

Specifies the time-out period in seconds. The time-out period is the maximum time that a server instance waits to receive a PING message from...

Odd. It could be something obscure, page size difference or something daft like that?

It's long winded but have you tried restoring to a quick install of SQL 2005 express,...

Be careful with this. One of my customers wrote a VBScript-based app to send automated e-mails using ASP and coded in plaintext connection strings (passwords and all) to a...

http://tinyurl.com/3fq4d5d

top link

If you want to use SSMS and you know where the table(s) are that are using FTIs, use the context menu (right-click) on one of the tables, go to Full...

just include SET PATH = %PATH%;C:\thisfolder\thatfolder as a line in the script, to where sftp2 resides.

It only sets it for the session, not as a global permanent setting, so no...

You could mitigate against this by writing a try/catch into the application code, parsing feedback from SQL Server for 'SQLServerException', 'Connection refused' or similar. You could alter it so...

http://msdn.microsoft.com/en-us/library/ms186865.aspx