Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 how to change it

Author  Topic 

moats
Starting Member

1 Post

Posted - 2009-03-24 : 03:59:36
i made a store procedure... but it can't works... error 2760..
spesified owner name 'owner' either does not exist or you do not have permission to use it...

i think its about accesibilty..
but i work in windows authentication with no username and password..
i really need your advice...

thanx

best regards
farhan

Ashra
Starting Member

2 Posts

Posted - 2009-04-01 : 06:25:16
Use Quesry Analyser, Drop that stored procedure and then create again with
following syntax:

CREATE PROCEDURE [dbname].[dbo].[Procedure Name]
----
----
----
GO

_.'._.'._
__Ashra__
_________
Go to Top of Page
   

- Advertisement -