I am new to this so please help

Full control

and it is newly configured and I am not able to telnet the database from my web server on port 1433 ..

Not same: -c is slow and another user are able to work on the server.

/console:...

Create a new user or login with existing users

Please login as change user in surface area configuration and try to use instance/system name rather than IP

Dear As I know Collation can only change on re installation.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/8dd1b91d-3e14-4486-abe6-e3a550bfe457

Dear All,

here ajayg is server name and intranet.nic.in is domain name.

Now the error is:

TITLE: Database Properties

------------------------------

An error occurred while starting mirroring.

------------------------------

ADDITIONAL INFORMATION:

Alter failed for Database 'abcv_Mirror'. (Microsoft.SqlServer.Smo)

For...

Dear Lynn,

I am getting this error as you suggest...

TITLE: Database Properties

------------------------------

An error occurred while starting mirroring.

------------------------------

ADDITIONAL INFORMATION:

Alter failed for Database 'abcv_Mirror'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing...

"Transaction log is created for all..DBs"

This line is my mistake but I was not able to edit it....Sorry for this..

Gail...I have only the port 1433 open between client and server...

I am getting same problem but I have to use it....How can I do...I want to use select into..

Lynn is right

DBCC Memorystatus...I am not able understand it comletely can anyone help....

Thanx dyke You are genius

Thanx...

Yes it is working, Can u please tell how to decrease the time lag...