It somehow can be related to the noise words.

If you read the Books Online article Noise Words

http://msdn2.microsoft.com/en-us/library/ms142551.aspx

it says that these words "are left out of the full-text index"...

Ping implements ICMP protocol which is different from TCP/IP ports for SQL Server (1433 default), Kerberos (88), Named Pipes (445) and NTLM

Please read this article

http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

SQL Protocols

It says that Kerberos is...

I asked our Oracle admin and he explained that the Oracle server may be set up to allow all users connect to one process or to have each user have...

I do have 'Allow Inprocess' checked and it works.

What version of Oracle you are connecting? We are connecting to 10G

I have the same setup, but in Security I did specified a local login, remote login and remote password. When using this linked server I do have to connect Management...

I answered correctly but I don't understand the question. Is the question asking "what was the layout before the change" ?

Please see my previous reply here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=381504#bm381527

you have to read this:

http://msdn2.microsoft.com/en-us/library/ms160854.aspx

that has a link to installing samples and says that if the samples were not installed (including the sample...

You don't have to give sysadmin rights to the domain users.

Ask your network admin to create a global group with people who have to access your SQL Server. In Management Studio...

The question explanation is not one of the answer choices:

Explanation:

Only the High Availability mode provides automatic failover in SQL Server 2005 database mirroring.

You can use rs utility.

http://msdn2.microsoft.com/en-us/library/ms162839.aspx

http://msdn2.microsoft.com/it-it/library/ms152874.aspx

Samples are in here:

http://msdn2.microsoft.com/en-us/library/ms160854.aspx

one of the samples:

I did not use...

Hi,

Services have a name and a display name. In the Computer Management ->Services  or in Services Control Panel what is on the list is a Display Name which is SQL...

Is it under category Administration?

Hi,

I added ## to the table names to make tables temporary and it returned the following:

1. The message that it skips Foreign Key constraint that is not allowed on temp...

To Mark:

I don't agree with you too: if the department boss pays out of his budget he will not allow another deparment apps on it. The secure app and database servers...

Lynn,

EE is Express Edition or Enterprise Edition?

I assumed it was Enterprise but if it is Express then I think you download the Express Edition SP1 from here:

http://www.microsoft.com/downloads/details.aspx?familyid=11350B1F-8F44-4DB6-B542-4A4B869C2FF1&displaylang=en

Also in the...