alter databse TestDB set TRUSTWORTHY on fails

Hi all,

When I try to execute the following command:

alter databse TestDB set TRUSTWORTHY on

I get this error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'databse'.
Msg 195, Level 15, State 5, Line 1
'TRUSTWORTHY' is not a recognized SET option.

Can someone tell me why?

Thanks in advance.

in which version u r executing this query, makesure that it is SQL Server 2005. I thing u r running it on SQL Server 2000. SQL 2000 does not support this Option.

Madhu

|||

Hi Madhu,

Thanks for the quick response, but there is no SQLServer 2000 on my PC or my laptop. My laptop has Win XP and SQL Server 2005, and my PC has Vista Ultimate, with SQL Server 2005. The command was executed in Management Studio, which SQL Server 2000 does no have.

Thanks.

|||

which edition of sql server u have. i suppose SQL 2005 express edition. in that case it has some limitation with regards to Service Broker. Check whether u can enable broker on database or not.

Ref the link also :

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

See service broker, it says that it can only be a subscriber.

|||Standard edition. I see the "Trustworthy" option in database property, but it is disabled and set to False.|||

sobo1 wrote:

Hi all,

When I try to execute the following command:

alter databse TestDB set TRUSTWORTHY on

I get this error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'databse'.
Msg 195, Level 15, State 5, Line 1
'TRUSTWORTHY' is not a recognized SET option.

Can someone tell me why?

Thanks in advance.

oh... god it is typo error... it is Database not databse

alter databse TestDB set TRUSTWORTHY on

run this alter database TestDB set TRUSTWORTHY on

Madhu

|||

Hi Madhu,

Thank you so much for catching the typo. It is interesting that Management Studio faild to detect it, and instead, blamed it on something else.

Thank again, I really appreciate it.

|||

sobo1 wrote:

I get this error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'databse'.
Msg 195, Level 15, State 5, Line 1
'TRUSTWORTHY' is not a recognized SET option.

Can someone tell me why?

Thanks in advance.

SSMO has detected it and reported it correctly. but we did not notice that..

Madhu

|||

When I see the statement Incorrect syntax near 'databse'., I am thinking that the problem is near 'databse' and not 'databse' itself