I recently upgraded from SQL7 to 2000. One of the tasks in my database was to go out and retrieve a couple tables from an Access database. I used the default name in my SQL7 database which was the same as the table name in Access, namely, '_EAN13Codes'.
SQL2000 doesn't complain about the DTS import, but when I try to use or look at the table, I am told I don't have permissions to view it.
First, I renamed the table by removing the leading '_'. I was then able to use it as before.
Second, I went back to the design of the DTS import job and changed the destination table from the default _EAN13Codes to EAN13Codes. Again it worked.
Apparantly, SQL2000, at least in this instance, just doesn't like leading '_' in table names (neither do I for that matter, but that is what the other db designer did...).
SQL2000 doesn't complain about the DTS import, but when I try to use or look at the table, I am told I don't have permissions to view it.
First, I renamed the table by removing the leading '_'. I was then able to use it as before.
Second, I went back to the design of the DTS import job and changed the destination table from the default _EAN13Codes to EAN13Codes. Again it worked.
Apparantly, SQL2000, at least in this instance, just doesn't like leading '_' in table names (neither do I for that matter, but that is what the other db designer did...).