You have to follow the full upgrade path thru each major version, I never went that far back but did do an upgrade in a test lab from 6.0 to...

Or if looking at a particular table this is shorter.

SELECT * FROM syscolumns where [id] = object_id('tbl_paging') and colstat & 1 = 1

Or the better thing to use is the...

Acutally, there is another thread on this very subject which I was involved in but I cannot find right now.

However, the reason = NULL does not behave the same as...

You will need an OLE or ODBC driver for MySQL then you should be able to use Export wizrd to pick and choose the data to move. Or if done...

Your syntax looks invalid and not sure why would work in one but not the other. Try this insted and see if works in both, I think the (SELECT CHARDINDEX...)...

Begin and end date, I was referring to the date they would start having access to the objects of a DB in a role and the date it should end,...

You might try installing the latest MDAC, this is a problem coming from the connection library.

Also, verify the connection parameters for the login account are valid.

Finally take a look here...

Still no issue. What I suggest do to test on your end is as follows.

Set up a test database.

Using the DDL you provided create this table in the test DB...

As SQL has no real error handling you may need to create a job with ActiveX Scripting and use VB script. This way you have a better set of error...

Overall sounds sufficient to keep up with when and why a person was given access. I do agree set this up in a seperate database. Also, if this is an...

Definently in the standard agreement we are not supposed.

Hard to know but when you get rebuilt let us know if it happens again. If they all use the same VB dll then could be the dll is returning...

I second for Davids suggestion. Of the most used options it is the easiest to read, and least code to write.

Opps foudn a missing ) in my item should read

REPLICATE('0',overalllength-LEN(CAST(numericcol AS varchar(overalllength)))) + CAST(numericcol AS varchar(overalllength))

didn't have a way to test when I wrote.

I would say about the same. CAST...

Glad you found your fix and it was so simple.