script object-level permissions

From: cengiz (cengizu_at_globis.com.tr)
Date: 06/25/03 

Date: Wed, 25 Jun 2003 01:22:18 -0700

I've a database on SQL Server 2000, when I want to
generate scripts of my objects, even if I choose "script
object level permissions" , Sql Server does not script the
permissions that I've on my object.

thanks in advance

Relevant Pages

  • Re: Any Help Please
    ... Then check the "Script all objects" checkbox. ... This way you get a script of all object-level permissions which you can run against the SQL Server 2005 database. ... While the object level permissions are at the database level and should be restored with the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot Open SQL Server Table in Access.ADP File.
    ... Other possiblities would be that you didn't refresh the database window ... I have an SQL Server 2005 database which functions properly with my ... the Generate Script Wizard to recreate the SQL Server Database. ... Then, If I attempt to open another table, it opens. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Project Server 2003
    ... when I got to the run script step, I ran the script from the copied database ... I was also wondering about the create database ... For example, type Project Server, and then click OK. ... In the left pane of SQL Server Management Studio, expand Databases, ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Access
    ... Do you create the group in SQL Server on the NT Domain? ... >> from a client script to ... > the database server would not be possible from client machines. ... You will want the sqloledb connection string. ...
    (microsoft.public.scripting.jscript)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)