http://www.mssqltips.com/tip.asp?tip=1824

Hope this helps

- Sachin samuel

Hi,

Can you also send me a copy of the guide to my email address? It's sachinsamuel@gmail.com

Thanks a million in advance.

Regards

sachin

You can download red gate sql compare which can do this for you gracefully.

This is a runtime error from SQL Server management studio and nothing to do with the command you are executing.

If you don't have sql server 2005 service pack 2, install...

The question you asked is very generic and open ended. As per my opinion, resource (Memory, CPU utilization, space etc) manangement is the biggest challenge when you manage VLDBs.

Ofcourse...

Most of the time sql server central. This is the first website comes to my mind when it comes to sql server online community.

Check if this helps.

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/f594adb7-1ced-42fd-aa69-4e34e7ecdf27/

Or may be you can execute below query to see total number of users/services connected to db.

Select count(distinct hostname) from sys.sysprocesses;

IO error means Input Output error. There can be many reasons for this error. However when a IO is pending for more than 15 seconds or more... then sql server...

Moving temp db is simple process but it will require a restart. This is because sql server core engine is always using tempdb for all its internal process.

There are many methods you can achive this.

1) Go to run, type "perfmon". Add counter for CPU. This will give a graphical representaion of load on CPU.

2) If you want...

You can even create jobs to update statistics.

Which database version you are running on?

Whats the service pack applied on it?

Regards

Sachin

Its fairly simple. You just need to create a user dsn and choose the provider. Visio will help you to reverse engineer the database schema to Logical model.

please check the...

Hi Victor,

Please find my reply below.

1. I am installing the SQL 2005 instance on the same physical box containing SQL 2000 instance. Are there any special precautions i need to...