Re: Keeping object selection when changing login

i'm sorry. the flags property is from another task.
in the "Copy SQL Server Objects" task, it's DestUseTrustedConnection
and SourceUseTrustedConnection.
for SQL Server login, set it to 0

i just tried it, and it didn't forget my object selection.

.

Relevant Pages

  • Re: Moving data with SQL Server 2000
    ... Server as char and is then converted to different data types. ... "Tom Moreau" wrote: ... SQL Server MVP ... I’m using the object “Copy SQL Server Objects ...
    (microsoft.public.sqlserver.programming)
  • Re: change decimal attribute to numeric
    ... SQL Server Objects task onto your canvas. ... I used the DTS wizard to select source and destination. ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: hide objects
    ... Regarding to SQL Server objects, in ADPs all the security is defined into SQL Server. ... Instead, regarding to Access objects you can use Access Security to define who can "see" what. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Copy sprocs to a remote server
    ... Actually I used the Copy SQL Server objects task. ... I will try the second method after I will find out how exactly to script out ... >> procedures are actually copied to the remote server. ...
    (microsoft.public.sqlserver.dts)
  • Re: Just copy a table structure or structure and data to another database
    ... If you want a more granular level the Copy SQL Server Objects Task may ... using Enterprise Manager to generate scripts (Right-click DB, All Tasls, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)