I have setup a new installation of SQL Server 2005, parallel to our
production server. SQL Mail works fine on the production server. On the new
server, configured as identically as we know how, we can get the "test"
function to work.

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as ????.
My website connect to MS SQL Server 2005 and all the chinese data are
displayed as ????.

I'm installing SQL 2005 developer and de setup proces thinks something
else is already being installed at te moment... I have rebooted a
couple of times en killed almost all processes via the task manager.
The first time I tried to install SQL 2005 the setup proces stopped

1st question:  I have a new HP DL580 with 6 drives.  I need to configure the
array.  I've been told that the Database and the Log file should be on
separate harddrives, not on the same drive.  Is this the best practice?  Is
performance seriously affected when using one logical ...

I am having series issues installing a couple of patches namely KB932557 and
SQL 2005 SP2. I keep getting authentication failure even though the same
login works for the management studio and the account is a Windows SA and a
SQL SA. I think I am to the point where I am going to ...

My slq 2005 express edition was not properly installed
and i can't install a new one because
sqlsupport.msi  is no more on my pc
where can i get one ?

Windows 2003 x64 edition with service packs. SQL 2000 with SP4 installed
supporting Microsoft Groove Server.  After OS and SQL, created a special
account for use groove and gave the acct server and security admin and create
DB perms, installed fully patched both and then ...

I have SQL Server 2005 Enterprise installed on my server. I would like to
install a copy of Management Studio on my workstation to manage the database.
The only download I can find is Management Studio Express. Does anyone know
where I can find what I am looking for?

A user wants to store some data from the federal government.  The federal
government agency requires
- All data be encrypted using modules that are Federal Information
Processing Standards (FIPS) 140 compliant.

Hi,
I have a strange behavior that maybe has something to do with sql server
2005 express.
Is it possible that SQL Server 2005  express "locks" the computer for

I've SQL 200 server in SBS 2003 server, after I set up a DB maintaines plan
which run every night.
But in the morning I saw the job log that shows me failed ( Status)
How do I fix it or run it again??

Looking for a best Practice Guide when installing SQL Server 2005 Enterprise
Edition
Non - Cluster
Windows Server 2003 Standard

I am thinking about how to setup alert and database mail. In the compamy,
what kind of tool can we use for sending alert and database mail? use third
party tools or microsoft sql server build in tools? Is that good to use if I
use sql server build in alert and database mail? ...

Hi Newsgroup,
I have an application that stores its data on MSSQL 2005. The application
needs its own MSSQL 2005 instance.
Is it possible to run about 4-5 different instances on a single physical

I have a problem connecting my SQL Server 2005 from a ASP Webpage.
When I trying to connect using the following connection string:
"Provider=SQLOLEDB; Data Source =2xx.xxx.xxx.xxx; Initial Catalog = xxx;
User Id = xxx; Password=xxx"