I have question

Will SQL Server use Index Scan even though I have clustered index on table If I use NOT in clause in sql query?

Hi

instead of NOT in, can you join instead?

I will try query suggesion.

is there an index on ContractType?

There is non clustered index on Contract Type, I suggested dev team to create...

hey manu

thanks for modifying the query........

cheers.......

1. check how is the author for those two roles.?

2. Why you created those two roles?

3. What is the error message you are getting while connecting to SQL Server.?

4. What...

luckysql.kinda (7/22/2009)

---

I have three tables and I need to find to which DB these tables belong. I am not sure how to do this. There are 29 DBs and to...

Here my question is

In SQL Server 2005 while configuring log shipping we have two options

1. One for giving network shared path.

2. Local path if the backup folder is on local...

What is the use of the second option i.e

"If the backup folder is located on the primary server, type the local path to the folder"

When I try to access the URL (http://www.informationflash.com/) I am getting the error

Site Temporarily Unavailable

We apologize for the inconvenience. Please contact the webmaster/ tech support immediately to...

another thing is that SQL Server clients were able to connect to sql server all of sudden it happened and they are facing the issues.

It allows remote connections

Hi,

The error message is happening from the client computers, So I already verified the below things

Step 1) Make sure SQL SERVER is up and the instance you try to connect...

Jeffrey Williams (6/26/2009)

---

Why do you think it is not working? If you have a very large number as the restricted size of the file, are you aware that the...

Manu,

It is happening for the tempdev.mdf file, but It is not happening for the Log file.

May be I have to try by putting in single user mode......

Hey

I tried to create a maintenance plan through Maintenence plan wizard and it got saved.

I would like to know why I could not create a maintenace plan through...

First you need to find the root cause why the replication got failed..

Most of the problems will be solved by restarting the replication agents...like network issues etc...

You need to find...