Re: DTS Owner

This may help you although I don't know that dbo will ever be able to own them

Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"SQLServer Dev" <SQLServerDev@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:99906A1D-126B-40B8-BC84-084F4F2DFAF8@xxxxxxxxxxxxxxxx
> Hi All,
> We are using windows authentication to login to SQL Server, when I
> create DTS packages it shows my userid as the owner, I want dbo to be the
> owner of the package. I know we can use dbo.XXX for other objects
> (procedures/tables) to make dbo the owner, but don't know how to for DTS, I
> need help in this if someone can answer my question please help.
>
>
> Thank you
> Sincerely,
> Developer One


.

Relevant Pages

  • Re: User names
    ... > With SP3 will tables created by upsizing from access also be dbo owned as ... >>dbo by default. ... byjust specifically giving the owner name in QA. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: DBO Best Practices
    ... lines of always owner qualifying objects... ... someone who are just "a" dbo. ... > doesn't explicitly reference the object's owner (because SQL Server will ... The startup account defines the ...
    (microsoft.public.sqlserver.security)
  • Re: Allowing Fully Qualified Queries
    ... If the owner is dbo you can ... When preforming a select I'm supposed to be able to refer> to a database table in the from clause by it's fully qualified name> eg.> ... > How can SQL Server be configured to allow me to specifiy a database table> by it's fully qualified name? ...
    (microsoft.public.sqlserver.setup)
  • Re: Confused about dbo
    ... Jasper Smith (SQL Server MVP) ... > database within a SQL Server instance. ... > There are several ways you could have the username dbo. ... > the true owner of the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Error saving DTS Package
    ... There should not be a problem with the package owner - we ... I tried taking all the SQL Server resources offline and ... and trying saving the package again - same ...
    (microsoft.public.sqlserver.dts)