I imagine so, yes, but I'm not sure. You should be able to open up the package and script out what it's going to do.

John

The ALTER INDEX statement that was the deadlock victim will roll back. What happens after that depends on the severity of the error and how your code handles it.

John

Since SSIS isn't designed to run interactively, I would recommend running this as a report in SSRS, so that users can pass in the required date as a parameter. ...

Without seeing your data, I'd be just guessing. But I think you need a splitter function. Search for that and see whether you find anything that helps.

John

Mark

It's not just performance - if columns are added to or removed from a table then your application may break.

But with regard to performance itself, get a copy of your...

GO isn't a T-SQL command - it's a batch separator. It's recognised by SSMS but not by many other providers. When you use EXEC('...'), you're not running your...

Right-click on the table in SSMS and go to the storage tab. You'll see the size of the table and the number of rows: from that you can calculate...

Have a look at this. Make sure you do this on a test server.

John

Yes, as you acknowledge, you never quite know what you're getting when you use the GUI, which is a good reason to shy away from it in many circumstances. ...

OK, so for the operation to be allowed, you need City to be other than Sandnes, or you need P_ID to be other than 0. So just change the...

I think he's confused his requirement: he mentions "already inserted rows" and "already inserted columns" almost in the same breath. I think Gianluca's solution will work for him; alternatively...

Have a read through this[/url].

110 is the compatibility level for SQL Server 2012. You need to change to it to ensure you can use all the new features.

You can...

You'll need SQL Server to be running under a domain account on the source server and for that account to have write permission on the share.

RESTORE FILELISTONLY won't restore the...

Unless there's something I've missed, I think you just need to use the REPLACE function.

John

Don't know whether this[/url] helps?

John