Would like to know what type of replication you have ?

According to BOL, Reinitializing a...

Thank you all for helping me out. code is absolutly running fine.:-D

This statement will return all the rows with the SNA value..

I need to pass...

I have dissabled firewall, Checked the TCP/IP is listening on 1433, NAme pipes is enabled, SQL browser service is running

Remote connection is enabled.

what else to check ?

No cube is defined.

I think when you drop a database all the physical files associated with that database get automatically deleted ( mdf & ldf). There might not be in pointers in the...

I think when you drop a database all the physical files associated with that database get automatically deleted ( mdf & ldf). There might not be in pointers in the...

Too many replies

This indicate a thread is locked out.

You need to apply the hotfix for Windows Server 2003 SP1 that is described in Microsoft Knowledge Base 919341.

Check the link http://support.microsoft.com/kb/922658

Verify with...

To get these report you need to install SQLServer2005_PerformanceDashboard.msi by running setup. This...

You need to consider scaling up your processor, RAM, Netwrok Speed, Fast disk subsystem apart from DB load balancing. If number of users increase then start thinking for database load...

This means some other backup or job running which is using the same file.

Following are the few things which are not supposed to be running while the database backup is...

When an index is rebuilt the new index is written to the data file, and the space for the old index is de-allocated. But the process of writing the new...

It might eat up all of disk space available. While considering this option you should analyze your database growth which depends on numerous factors. Which mainly depens on the capacity...

What is SQL Server 2005 version? Is it with SP2 and latest update if not plesae go ahead and apply.

>> You can compare both the execution plan and find...