Ah you're correct. The individual who bought the SQL Server licenses is currently out on vacation so it didn't even occur to me about the processor license. I'll...

Thank you for your response John.

So no to the Integration Services, but I'd be able to install the SSMS tools correct?

Thank you for the replies.

Sean I think that should work as well. I knew there was a better way but just couldn't think of it 🙂

I actually just came...

Good Morning,

I'm not sure if this is possible using T-SQL, the following page discusses this a bit more:

http://stackoverflow.com/questions/58940/access-to-result-sets-from-within-stored-procedures-transact-sql-sql-server

Great, thank you both for your help!

And is this true for SQL Server 2000 and 2005 as well?

Here is an article on database mirroring in sql server 2005:

http://searchsqlserver.techtarget.com/tip/Database-mirroring-setup-in-SQL-Server-2005

Give the following article a read and see if it helps:

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

Thank you all for the insight on this. You have been very helpful.