personal is my computer name.

in the report services configuration manager- reports server virtual directory-- reportserver$sql2005

so, as per your suggestion --- in url--- entered -- http://personal:8080/reportserver$sql2005

--- nothing...

resolved this issue.

logged into SQL Server with sa

assigned sysadmin to my user

connected to SQL Server and did the same ooperation. It passed !!!

Thanks for your response.

my computer name: home

my login name: mano

when I install SQL Server 2005- user name displaying as home\mano

I am trying to drop login but sql is displaying this message: User does...

Looks like this collation change (db: AdventureWorks) to SQL_Latin1_General_CP1_CI_AS is hell like a task. Dont understand why MSFT can provide simpler solution? appreciate everybody, if there is a simple procedure...

Hello Gail,

There are not just these 4 objects. I could not paste the entire error message here. There are about 100 objects are there with this same error message.

Hello Azad--- can you tell me what is the procedure to do it? Thanks

I have AdventureWorks database. I want to change its collation to SQL_Latin1_General_CP1_CI_AS

I am trying with this command:

ALTER DATABASE AdventureWorks COLLATE SQL_Latin1_General_CP1_CI_AS

getting hell lot of error message: some of them -->

Msg...

Yes. I have AdventureWorks database and I want to change the collation for this database. what is the procedure? I am kinda new to SQL Server.

Hi Gail Shaw: here is the error message:

Msg 5075, Level 16, State 1, Line 1

The object 'ufnLeadingZeros' is dependent on database collation. The database collation cannot be changed if a...

ALTER DATABASE AdventureWorks COLLATE SQL_Latin1_General_Cp1250_CI_AS

The above command is giging error message.....can someone tell what is wrong? Thanks