For more detail, create an output file for each step in the job.

Open the job -> Steps -> Edit -> Advanced

Then go down to "Output file" and specify a file...

I'm not sure of your question ....  Are you trying to find them in Enterprise Manager ?  I only have pull subscriptions, and they are on the subscribing server. In...

Easy

Right click the publication and generate sql script to delete the publication. Paste the portion of the script that has "exec sp_drop article"  for the article(s) you want to remove...

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 ?