As Chris says, nobody's laughing or joking - just trying to talk you out of what would be a bad idea.

Is the "Lead" you refer to a technical lead? ...

Thanks Gail. If anyone else is reading this and is struggling with it as much as I was, here's a full discussion:

http://www.sqlskills.com/BLOGS/KIMBERLY/post/UnderstandingDuplicateIndexes.aspx

John

GilaMonster (8/23/2012)

---

No. The include columns are what you specify in the INCLUDE section of the index definition

"Each index row contains the nonclustered key value, a row locator and any included,...

opc.three (8/22/2012)

---

Is this to say that in a not unique index that SQL Server will attempt to insert new index entries with an existing index key in the order of...

GilaMonster (8/22/2012)

---

The thing is, they're not quite the same indexes. The unique index (for reasons of index architecture) is essentially an index on the key column, include the clustered index...

Juanita

Can I just clarify - are both indexes on the same single column?

To answer your question, I think you need to assume that one of the indexes was created unique...

You won't get any performance improvement from doing this, and will just end up with a load of objects you don't need. I advise you not to do it.

If...

Don't use Profiler. Set up a server-side trace. It uses less resource than Profiler.

John

Did you restart the Integration Services service after making the change? Is the SQL Browser service running? Do you have a named instance, or a default instance? ...

Could be to do with your config file. Have a look at this:

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

John

You need to add extra logic to the CREATE LOGIN section of your script to obtain the SID of the new (or existing) login. Then, in the CREATE USER...

Doug

Are you saying you clear out the log before you do the restore, or after? There's no point in doing so before, since the restore operation will plonk an...

Still makes me think it's permissions. When you start the service interactively like that, it runs in the context of the account you're logged in as, not the service...

In that case, I'm stuck. I would recommend that you get hold of a utility by Microsoft (I think it's called sysinternals) and run it while you're attempting to...

There are only two reasons I can think of for this:

(1) Another full backup was taken between the first full backup and the differential

(2) The differential backup is actually a...