Hi Arul,

Sorry for the mistake the command start as attrib not attrin.

from

killer

I did restore from the back at sqlserver20005.

I tried another way also attach and detach database(with move option).In sqlserver2005 show how it upgrades database of sqlserver2000 to sqlsever2005.

It also shows a...

The server collation acts as the default collation for all system databases that are installed with the server, and also any newly created user databases. The server collation is specified...

Hi,

Thanx for ur reply , i already did that.I want to know how to backup from command prompt.

from

killer

what is the service account for the SQL Agent.

Dont use windows authentication.

If u are using BCP then use Truststed connection.

see books online for the syntex.

from

Killer

There are few objects whoses compatibility level is not matched with sqlserver2005 compatibility specially when u use DTS.

Change the compatibility level to sqlserver2000 (9.0) and then try to tranfer the...

Thanx Rudy,

I had that help file.

from

Killer

Hi,

Did u changed the port No for SQL Server.

From

Killer

IT would be great help if u give me the address for Analysis services 2005 forum.

from

Killer

HI Karim,

As i dont know much about that but event id 17177 is issued when a cursor is closed.

17077 is issued when any process is failed (specailly when job get...

In ur case AWE is enabled.If it is not enabled thevalue will be 0

from

Killer

Hi ,

Did u restarted ur SQL Server after enableing awe.

Every OS has a BOOT.ini but is hidden.

U can unhide it by this command

c:>attrin -r -a -s -h boot.ini

then go...

In Database maintinance plan when u define backup disk directory there is a option remove file older then no of days.

There u can define number of days.It will delete the...

Hi,

Can u pls tell me did u enabled awe.Is OS Boot.ini is configured to use 4 GB of RAM.

It may or may not be a memory leak because u have...

What SP is installed on the server.

from

Killer