I have some Transaction Replications in which I select from TableA with a filter to select only those that are also in TableB:

SELECT <published_columns> FROM <<TableA>> WHERE 

Acct#  in (select Acct#...

Are users able to query the database ?  When we first switched to SQL Server, power users were able to run Query Analyzer selects against huge production tables that caused...

What I do is open EM using "Run As". This allows you to run an instance of EM as a different Windows account without logging off your machine or closing...

I think so

Do you really need 'AAA' and all those zeros ??   Why not just use an auto incrementing field ?

" ... Is it possible to script the database and still keep the lookup-tables-data? ..."

You're talking about 3 different things, and I think getting them a bit mixed up.  Scripting,...

I think you'll have to log on to your machine as the other user.

I would say "You SHOULD restore to a temporary database and then copy the table from there to the current database."

Then you're not impacting users or any other data in the...

It sounds as if you want to delete all the test data in the tables, and start fresh with empty tables ??      If it's small, you can type:

truncate table <tablename>

for each...

Same situation here. sp_reassign_dtspackageowner  and other workarounds aren't "sticky".  You can change the owner of a package, but next time it gets saved, it reverts back to the original...

Once I've used sp_addalias, is there a way after the fact to see what has been aliased ?

I can run:

SELECT  * FROM  sysusers

where  isaliased ='1'

To show me which logins...

Once I've used sp_addalias, is there a way after the fact to see what has been aliased ?

Don's post looked like it might be relevant.  Otherwise, Scott ....  I have the same take on this as you .....    There are a few references in BOL to "ad hoc"...

Also, when you detach, through EM, it gives you the option to kill all the connections.  You can use that feature even if you don't really want to detach. Kill...

Go to Books Online, and look at the "overview" section of PULL and PUSH subscriptions.  There's some good info there.