Run the job as a CmdExec job that runs sqlcmd that directs the output to the desired file. Include SET NOCOUNT ON to get rid of "1 rows affected".

So you are physically moving all the machines, not moving SQL Server instances from one machine to another? Assuming that SQL Server databases are on a SAN, are you moving...

Does this happen repeatedly? That is, if you scratch the table and start over, does it happen again?

I found http://blogs.msdn.com/b/sqlserverfaq/archive/2009/11/04/s.aspx although that article is not entirely easy to understand. But...

As long as you don't have more then four fields, you can use parsename, although this function is specifically intended to parse object names in SQL Server and only accepts...

You can see when a login was created in the catalog view sys.server_principals.

The default trace records events like creating or dropping a login, but keep in mind this information is...

So this is not entirely...

I would device the import process so that the columns are always there, but if they are not in the spreadsheet they would be NULL.

A table is supposed to model...

I've done this with PowerDesigner, but PD is not exactly cheap.

There is a diagram feature in SSMS, altough it's much to get excited over.

It helps if you give the context. What do you try to do? Do you need the distributed transaction?

Also, are the two servers in the same domain? In a workgroup?...

Are there other applicaitons running on the server? Else I see little reason to see Max Server Memory to 2GB when you have 4GB in the machine. Set it to...

I have already given it. When the user is done with the grid, populate the sorter column...

We are helping. You are refusing to be helped....

deepkt (7/10/2013)

---

Thanks for the reply.

In UI I am binding data to a grid.. all the logic will be processed using stored proc and from back end.

In UI user will modify...

Your function returns 1 if any of the columns exists in the table, not if all columns exists in the table.

But it is not going to work out anyway. If...

Change your stored procedure to work with input in a table-valued parameter which holds the new sort order for all values. Or at least all values for which the sort...