Tx I'll check it.

Tx Roy, you are correct. JKSQL, was your work around based around this or did you try something else?

Please advise if this works as I'm also interested in your OS version.

Tx all much appreciated. I think I'll stick with what I have for now. Having both SP3 and 2k8 was just a want and to keep to the standard. In...

Also check if you matched columns correctly...

Hi, Ij know that I also had similar issues with table variable vs extended stored procedures in SQL 2k but I had some work around and in some instances I...

I suppose what Hanshi is saying, trying to connect with the credentials that are used to run the application would be one of my first steps for troubleshooting

sure according to what u said it seems as if you do not really care about the data for now, you can also consider scripting your table as is and...

glad everything works but did you change anything relating to security or roles?

LeonP, did you manage to post this where you said you'll post? I'm also interested in seeing the causes of this.

Try to check if maybe your setup file is not at fault, if the setup fails at initial phase.

Before doing anything try checking what could have caused this to be like this before fixing so that after fixing the db then the next step should be preventing the...

try sp_helpdb 'Database Name' as well

Anyone who's ever installed SP3?Would like to know whether to go for it or straight to 2k8.

More description will be helpful and what would you want to take data either from table1 or table2?