So when you walk through the ODBC configuration for that DSN and you get to the end what happens when you hit the TEST button? Curious.

Not familiar with Sybase...

\\YourServerName\YourShareName\ should work.

Ultimately this is an ODBC configuration issue with the link being to Sybase. So, open control panel, administrative tools, Data Sources. Find the data source associated with the error and...

Ya know, I fought for 3 years at a company to prove that SQL Server could compete with Oracle (actually not only did I prove it but proved it could...

The MS documentation for creating linked server and the associated security is a good place to start. http://msdn.microsoft.com/en-us/library/ms175537(SQL.90).aspx

Getting the security right with the linked servers can be a bit more...

Woo Hoo! Huge sigh of relief on my end as well. Glad to be of help.

Hope you find it as I am just about out of ideas.... 😛

Just a guess but there might be a "PriceList" table that would then contain more information that those ID's would relate to which the application would then build it's select...

Being that this is only one table I might have assumed something incorrectly. However, you mention that there are id's 3, 13, and 14. What do they relate to and...

...or,

select db_name(dbid), count(*) from sys.sysprocesses

group by db_name(dbid)

Getting the exact moment could be pretty tricky. There are clearly scripting methods to "query" windows services, which SQL Agent is, but even the best of monitoring apps do that...

My immediate question is whether those tables have an identity column on them and if so, did you do an insert with the original identity value in the previous table...

Assuming that you have a datetime column on the table that is default based on the insert date / time then you could write a fairly simple query to do...

Here are some links on scalability of ESX server primarily. Some rumors of IO issues that are addressed in the links.

http://www.vmware.com/products/vi/esx/esx_features.html

http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/

http://blogs.vmware.com/performance/2008/05/100000-io-opera.html

As with everything test. I did find the first...

Sounds like you have some relational data issues, not corruption as Paul stated. How did you go about copying and what method did you use in order to ensure that...