You might also consider using the EXCEPT keyword to keep your code neater and more concise. I don't know whether there are any performance differences between that and Chris's...

Are you saying it works when you execute a RESTORE statement, but not if you use the GUI? Have you tried running a Profiler trace so that you can...

My advice is to plan properly and then only install what you need. Anything that is installed for no particular reason and then configured as an afterthought is likely...

Sree

Please will you post your query so that we can see whether there is any better way of doing this. I don't think your SELECT INTO syntax is correct.

Thanks

John

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