Use telnet. Something like this:

[font="Courier New"]telnet MyMailServer 25[/font]

John

http://www.lmgtfy.com/?q=active+active+model+clustering

Mark

Wrong - you can use Cluster Administrator to create a file...

Have a read about sys.sysprotects and sp_helprotect for permissions GRANTed to users on objects. As for server level permissions (if you require that), I'm not sure, but you'll be...

I can't think of an elegant way of doing it in T-SQL for a table with 328 columns. Maybe someone else can?

This may be one of those things that's better...

This page looks as if it has all the information you need:

http://technet.microsoft.com/en-us/library/ms191183.aspx

John

Understood about temp tables - I should have spotted that myself.

It would indeed be hard to check which fields have changed, but you can write a separate routine to do...

Please will you post the final version of your query? It may help someone else who's having a similar problem.

Thanks

John

Creating a clustered index with fill factor 0 won't use any more space on disk (apart from any extra space that is consumed while the index is being built). ...

Arjun

I think I'd write a simple SSIS package. There are tasks in SSIS that are specially designed to manipulate text files.

John

I don't know of one, although I've never seen a requirement such as this before, so I suppose it's possible there is one.

John

If I understand correctly, you need to get the locale information from the local user (ie on the client computer) and pass it to SQL Server for it to be...

Nigel

I think I understand what is required - the data is grouped according to common headers such as "2...

I think your requirement would best be fulfilled in your presentation layer rather than in the data layer. I would recommend Reporting Services for presenting data in this format.

John

The easiest way to improve performance would be not to insert Inserted and Deleted into a temp table. There doesn't appear to be any value in doing that, so...