But if i am not wrong we could add instances in SQL Server 2000, by right clicking

enterprise manager and create and register new instance by giving name of the instance.

i...

agreed with marsh.

seems permission related issue. please check for permission for the account from which you are running.

Manoj

http://www.netlib.com/sql-server-encryption.asp

Manoj

please check is there any application configured with same port?

stop all applications and services.

start sql server.

this will permit sql server to take control over port 1433.

Manoj

Steve,

i think default port is 1433.

Manoj

same way if you want to check existence of file

use xp_fileexists 'path'

by using Transfer Logins Task package

and sp_change_users_login

Manoj

you can use below query:

select spid, status, loginame, hostname, blocked, db_name(dbid), cmd from master..sysprocesses where db_name(dbid) = 'yourdb'

Manoj

SQL Server Performance Monitor -> add counter Total Server Memory(in KB)

will display how much memory is allocated by an instance of SQL Server

Memory-Available Bytes

will display how many...

seems this is a memory problem.

please provide some more detail like size of your mdf,ldf and location of both.

configuration available.

if space is not a problem check integrity of your...

i am not in a favour of recommending covering index. As according to your information you are fetching a records by specifying single column filter. by creating separate index will...

you can enable it from

Database Mail Configuration Wizard -> the SQL Server Surface Area Configuration tool OR sp_configure.

Database Mail is enable for Database Instance?

Lets Hope For December

This is a problem with microsoft product. please wait for new SP or consult MS for the same.