Use an int and make it an identity column.

Duplicate post.

No replies to this please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic601923-146-1.aspx

You've got some nasty database corruption there. I don't suppose you have any idea when that started?

I'm not sure how to fix it. Let me see if I can...

Huh? Why would you want to do that?

I don't think you will be able to restore it with corruption. On the SQL 2000 server, please run the following and post the results.

DBCC CHECKDB(< Database Name > )...

Using braindumps is cheating and can get your...

The trigger has to go on the table that the insert is been done into. In this case, that'll be on Table_1 in DB1

The trigger just has to insert the...

Indeed. With an update, the inserted table contains the rows as they are after the insert and the deleted contains the rows as they were before.

Sorry, I misread your question...

Add the /Q switch to the del command. It puts delete into silent mode so it won't prompt.

Try removing the square bracket from the end of the URL

Thing is, without seeing the exec plan I can't give you more than vague...

Run it on the SQL 2000 server in the database that you are trying to upgrade.

The query will always return a result on SQL 2008, as that's one of the...

What does the query I posted return when run against the original SQL 2000 database?

Phil Auer (11/12/2008)

---

Thank you very much for the on-point answers.

1. Is removing the inactive entries on a full backup an option (which I would want to NOT select) in SQL...

Looks like a conversion problem. If I'm interpreting the error correctly, it's saying that it can't create one of the new system tables because an object with that name already...