Hi,

This topic has been covered many times before... A simple search of this site or indeed google will bring up many apps that will do the job. 🙂

Here are just...

Thanks Ashish also...

Don't really want to enable C2 at the moment as I understand there would be a significant performance hit in doing so.

We will be moving to 2008R2 later...

Many Thanks Bob!

Shame on you George! 😀

There are quite a few tools out there but one of the best in my opinion which was free the last time I looked was http://www.quest.com/discovery-wizard-for-sql-server/. Although as already...

Not entirely sure what your asking but I don't believe Microsoft has released SP3 for SQL 2008!? SP2 can be installed if required which will take your build version...

I too would be interested to know if there is a way to do this? Under SQL 2000 you had the Licensing applet within control panel that would inform...

Here in the UK it's Sky Sports News 😀

Nice one Alz!

Yes Anna, you would use the 'initial size' boxes to grow the data & log files accordingly. If you right-click on the database and go to Tasks, Shrink, Files...

Well i'm on Windows 7 using the SQL 2008 R2 Client tools and have NEVER had any problems connecting to any SQL 2000 instances.

Has this ever worked?

What messages do you...

You should be able to connect to any SQL 2000 instance using your 2008 SSMS Client Tools regardless of whether you use the IP address or DNS resolution.

I presume you would want to test connectivity to the SQL box from your remote site?

Try connecting to it using the same methodology as if you were still located there......

http://msdn.microsoft.com/en-us/library/ms144267.aspx

Look towards the bottom of the document under 'Next Steps'

Thanks a lot for your help! Perfect!

Easy when you know how!

Cheers.