Any SQL Gurus?

flares2

So I'm having an issue with our Card Control system. Long story short, ID badges are swiped to gain access to certain doors throughout the building. The access levels for each user is stored in a SQL Database. Upon loading the admin console to this system "Error Converting Data Type Varchar to Bigint" pops up over and over again for about twenty minutes, then the system freezes and needs to be restarted. While in SQL Management Studio though, I don't receive any errors. Is there a way to create a query of somesorts that searches through the thousands of rows of information with the two hundred tables in the Database so I don't have to? The error does no9t reference what table, what column, anything. It just says there's an error, then the system freezes.
It's late, my eyes hurt, I want sleep.
Can anyone help? Thanks.

Kaminsky

Found this which may be of some use:

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=44926

blargoe

You might be able to find something useful in the SQL logs too.

I do wonder, as a side note, why in the world your company wouldn't have support from the software vendor for something as important as the door control system.

flares2

Thanks for the tips guys.

Blargoe I ask the same thing everyday. Problem is we're a state oriented company so our vendors have to be licensed by the state. Its the end of the year so it's renewal time and needless to say, a lot of vendors are dragging their feet. Unfortunately, that means we can't do business with them.

brad-

it sounds like the program needs to do some converting, or you should convert one of the field types.

IDK about querying 200 tables though...i have a hard time believing you need to query that much, rather that you need to refine where the problem is. The problem is likely one field of one table. Need a developer to step through the process.