thank you !

Thank you so much !!! Great points I didn't consider and being new to sql2005, thanks for that tip!!

Juanita

Thanks!

Juanita

Thank you very much Jeffrey!

Juanita

Jeffrey

Are you saying that once you restore to a sql 2005 server, your database is actually 'converted' at that time to sql2005?

Juanita

Thanks a bunch Elliot and Lynn...

This helps alot!

Juanita

HI Lynn,

So by keeping the level to 80 this is considered 'not converting' to sql 2005?

Thanks,

Juanita

HI Adam,

Actualy on this particular sql server instance he has his own windows login and then there is a windows group that he is also a part of. Thank...

Thank yall so much !!!

Exactly what I needed and worked like a charm !!

Juanita

Thank you so much!!! Exactly what I needed to see. I went on a test sql2005 server and did the exact same thing and I didn't have any problems so...

Okay, not sure what is going on but I went back into management studio and did a refresh on the sql server instance and it allowed me to 'attach' the...

Thank you!

Thank you so very much !!!

Juanita

Thanks a bunch!

Juanita

HI,

Actually I am logged in as a non sysadmin. And the default schema is 'myschema'... but still shows all destination files as schema DBO.

Do you have a link for the...