I have default instance not named instance. In my case it is not possible to rename it, right?

I need to encrpt a user database not object on SQL 2005. Is it possible? if so, which way is best way for encrption, in database level or file system...

I tried to install SQLEXPR32.exe SP4 on this 32 bit system, it also started installing a new instance. Not sure which SP4 needs to be installed on this edition.

Do you know what's different between SQL 2008 Express SP3 (SQLEXPR_x64_ENU) and SQL 2008 SP3 (SQLServer2008SP3-KB2546951-x64-ENU)? Thanks.

How to manage the jobs on the Express edition?

The sa account has been mapped to db_owner role on some of the databases, I just want to uncheck the role from the user mapping since I created the new...

The existing SQL 2000 with SP4.

1. I deleted all the DTS packages under Local packages,

2. There is nothing under Meta Data Services Packages.

3. When I click Meta Data, it show...

How could I find out if there is another job backing up sql dbs?

I will give a try to switch to Quorum disk group. To answer Brian's question, yes, we did enable Network Access. OS is window 2003, SP1.

Only the applications that are using Domain account are having problme connecting to the database. Others are fine using SQL account. I don't know if this caused by changing the...

Yes.

Brian,

I can register SQL using my NT account and sa account. There are only messages information below in error log, because I installed MAPI client on SQL server for the email notification. The...

Good point. Can SSMA be used for Oracle to SQL 2005?

If SS2k ENT support 8GB of memory on Window 2003, does AWE or PAE still need to be enabled?

It all works now. It was my mistake on the DSN creation. BTW, can FTP task be used to connect to UNIX servers on DTS? If so, what is the...