SQL Server Performance Forum – Threads Archive

Unable to fire DDL in Master

hi, we have sql server MSDE installed on one of our servers. Whenever i try to create a new stored procedure or a table in any of the databases i get this error ‘DDL statements are allowed’. We have given the dbo permission on the master database.
Please help. also we have sharepoint installed on the server. is this the problem?

Can you confirm which version of MSDE and version of MDAC you’re using? Why do you want to create an user object in the system database, it is not recommended. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Which edition of sharepoint are you using , WSS or SPS??? AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS

Hi Satya, the MSDE version is 8.00.884 (SP3). But now the problem is i am not able 2 create any SPs in any of the databases. what is the problem?

What was the exact error when tried to create the objects?
Ensure you’re using SA account to do so. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

No I am using the windows authentication with server admin and system admin access. this is the error I am getting. DDL Statements not allowed.

]]>