I am told that when using SQL Server 2000 native authentication, the password
is encrypted even if you don't use SSL.  Is this true?  I can't find anything
about it BOL or any articles on Microsoft's website.  
This is a hot issue right now for us as we're told we use it because ...

I'm upgrading legacy system using java 1.4,  MS SQL 2000, and Jturbo
3.0.2 to MS SQL 2005 and jTDS 1.2.2.  While testing I found 'Invalid
State: Result Set already closed'.  Found a number of multiple
resultsets tied to a single statement:

Quick summary:
Recently built Server 2008 Standard box
SQL Server 2000 SP4
No default instance installed.  Two named instances.

I have been scouring the boards all over and am only finding issues where
people are attempting to remote onto another server to conenct to SQL.  So...
I am on my dev machine and attempting to use the following ConnectionString
in a C# console app to connnect to the SQL server ...

I am not able to connect to several sql server instances over the network.
I have SQL 2000 and SQL 2008.
Where should I look for a misconfiguration?

I am looking for websites and newsgroups that focus on helping with
composing complex SQL statements.  In others words, I need help
somewhere with writing some though SQL.
Please help.

WHere is the best SQL samples and practice site available?

So, I have SQL 2005 installed and running.  I have a 3rd party software
package that connects to it using Windows Auth and everything works great.  
Problem is I have another 3rd party software that doesn't use Windows auth
and it can't connect.  The user has been setup on the SQL ...

good day all,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
And if this is the wrong message borad please let me know where the best
place to find this info.

I want to set up SQL Mail, for which I have changed from local account to
domain account after which I cannot start MS SQL server service, but again
if I change from domain to local account I could connect to the service. My
question is how to set up SQL Mail using domain account ...

Please help. SQL Server 2005, a simple stored procedures that include one
simple INSERT INTO, but this insert is inside a transaction.
begin transaction
insert into....

I was wondering if it is possible to import data into a SQL Server
2000
table from a command button in excel.
Basically I need to send users (over 50) an excel spreadsheet for

i've made a self signed ssl certificate with selfcert, but now i can'tlogin
into sql server: i get this error:
The connection with the server was set correctly, but then there was an
error during the handshake pre-login. (provider: Provider shared memory,

I am running MSDE 2000 to backup a Microsoft Office SharePoint Server 2007.
Blow is the .vbs script that I am using to back the server up.
Can someone help me edit the script to do a restore?
What the script does is backup the data each day and place it in a folder by

I am trying to use Upsizing tool to convert Access 97 database to SQl server.
Can anyone help in this aspect?
Any help is appreciated...
Thanks,