Identity property doesn't guarantee uniqueness. Did that query I posted return any rows?

John

Have you checked your data? Does the ID column have a unique constraint on it?

Does this return anything:

select ID, COUNT(*) from MyTable group by ID having COUNT(*) > 1

John

I'm not sure he is. If he were, I'd expect to see an error like this: Restore operation for database MyDB...

OK, so instead of saying SELECT *, say SELECT N'<TD>' + ISNULL( + '<p class="datarows">' + CONVERT(NVARCHAR(MAX),[eventtime ]),'<p class="datarowserror">Not Avail') + N'</p></TD>'

+N'<TD>' + ISNULL( + '<p class="datarows">' + CONVERT(NVARCHAR(MAX),[eventid]),'<p class="datarowserror">Not...

Yes, but why?

John

How are you restoring the database (GUI, T-SQL, third party), what command is being issued to do the restore, and what is the exact error message that you get?

Thanks

John

I think I'd do it by running the query in SQL and then using an Excel macro to change the name of the column.

John

Where are these results appearing - in SSMS, in an application, or in Reporting Services? This is the kind of thing that is best handled by the application (presentation)...

I don't think you can. I believe there's a utility (dtsutil?) that you can use to export a maintenance plan from one server to another, however.

John

cengland0 (8/4/2011)

---

I just found the pay for Doctors in NHS (http://www.nhscareers.nhs.uk/details/Default.aspx?Id=553):

Doctors in training

In the most junior hospital trainee post (Foundation Year 1) the basic starting salary is £22,412. This increases...

pwalter83 (8/4/2011)

---

Ninja, do you know how to convert the data in the tables to an insert using SQL automatically ? I dont know where to go with this ? repenting...

OK, I think we've come as far as we can without your providing any table DDL and sample data. Please post the former in terms of CREATE TABLE statements,...

I would advise against doing that, since it would make the condition...

Something like this?

SELECT <column list>

FROM MyTable

EXCEPT

SELECT <column list>

FROM MyTable

WHERE PORT_CD = 'BEZEE'

AND ARRIVAL_SCHEDULE_DT < dateadd(mm, 3, getdate())

John

You're probably going to have to do a bit of trial and error. Expand the Errors and Warnings category, and hover your cursor over each event for a description....