I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP.
I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as
views and so on. But using Export in SSMS 2008 doesn't seem to do that. Instead it takes a query, runs it to create a table and then exports the table
with data. So instead of ending up with a query with its permissions, I end up with a table which is no use to me.
Obviously I can open the query, copy its sql, open a new local query, paste the sql and then set all the permissions, but this is a very long winded
way and can't be automated.
I'm sure there's something really obvious I am doing wrong, but I just can't find it!
There are lots of differences between 2000 and 2005/8, but I can't find any helpful web resource to give me a quick guide to what to do differently
with 2008. Books online gives you chapter and verse on the new product, but not the idiot's guide to what's changed. If anyone knows of a good web
resource, I'd love to hear about it.
Thanks in advance for any help.