Have you also checked the DTC configuration on Server B?  We had similiar issues between our servers running PeopleSoft, and we had to modify the DTC settings on both servers...

Check BOL, DBCC CHECKIDENT.

Looks like this:

DBCC CHECKIDENT('DAWNTEST', RESEED, 500000)

You can create UDT's in SQL Server 2000, sp_addtype in BOL for SQL 2000 shows how.  Used this a few times at a previous employer.

glad you figured it out, but it would be beneficial to others that read this post to know what the issue was, as there be others with a similar issue.

I am assuming that there was significant work done prior to the full backup.  A full backup does not truncate the transaction log, that is only done by the transaction...

I think I figured it out.  If you alias a COLUMN in your select statement, you can't prefix that ALIAS with a table alias.  Not a problem for me as...

I haven't used SQLUA, but I am wondering why it would issue a warnig FOR prefixing your columns in an order by clause?  By prefixing column names with a table...

True.

Never say never.  If the view only returns, say the TOP 10 PERCENT, the ORDER BY is used to determine which top 10 percent is returned.  Again, test, test, and...

Michael, I knew there had to be another way to get the upper bound for the where clause.

Try this:

where

datefield >= dateadd(mm, datediff(mm,0,

I'm just a little confused, what is the criteria for select records again?  My guess is you are looking for all records in the current month based on the value...

It depends.  If the select in the view is written SELECT TOP 100 PERCENT ..., then yes.  If it actually returns a small subset from the target table(s), then I...

Based on the OP, the question being asked is which car has both diesel and Petrol types.  The Skoda has only diesel, so fails the criteria where as the ford...

I played with it a little more, if you change the = to >= you will get the results you are expecting.