Showing posts with label text. Show all posts
Showing posts with label text. Show all posts

Wednesday, March 7, 2012

Connecting to a Full text catalog

I am trying to connect to a full text catalog in SQL.
How do I do that? I tried using the same format as connecting to a table but it did not work.

Full Text is an add on to SQL Server dependent on Microsoft Search Service, do you have it installed and the Microsoft Search Catalog must be populated to get search results. Try this link for a two part walk through. Hope this helps.

http://www.databasejournal.com/features/mssql/article.php/3441981

Sunday, February 12, 2012

Connect to SQL Server dialog box

Does anyone know if the SQL Server connection dialog box transmit the password in clear text? I know it's hidden from display but I'm wondering what it does behind the scenes
Thanks
Ray KurpielI am studying the MCP book, and in Ch 10 (regarding SQL
authorization) it says:
The user name and password are submitted to SQL Server
2000 in clear text unless both the client and the server
Net-Libraries are using SSL encryption for the
entire session.
>--Original Message--
>Does anyone know if the SQL Server connection dialog box
transmit the password in clear text? I know it's hidden
from display but I'm wondering what it does behind the
scenes.
>Thanks,
>Ray Kurpiel
>.
>|||Thanks for the response, Meryl.