You can also use the Transfer logins task in DTS Designer. It's pretty straight forward to use.

Markus

No, the presence of a database called distribution is not enough. Three reason for this are:

1. The distributor could be on another server

2. Replication might no longer be used

3. You...

Hey,

finally somebody coming back to the original topic of this post.

As you can find somewhere in the beginning of this post, I was searching for the record in a...

I usually don't use any of these preconfigured roles. If you choose application server it will install IIS and ASP.net. If you want to use Reporting Services you will need...

Use sp_changedbowner to map another account to the user dbo.

Markus

Yes,

on large databases it will take a while, to get the results. In my case that was not such an issue, but any improvements on the script(s) are welcome.

Markus

Jai,

have a look at this post

http://www.sqlservercentral.com/Forums/Topic385732-9-1.aspx

It might help you with your question as well.

Markus

David,

to disable your alert run:

EXEC dbo.sp_update_alert

@name = N'Test Alert',

@enabled = 0 ;

You could run this before your maintenance jobs start and...

Andy,

the problem is that when you use dynamic SQL (which you shouldn't) you have to grant permissions to the base tables. Exec on the procedure is not enough.

You can find...

If you database is in FULL recovery mode, a database backup is not enough to keep the transaction log small. You also need to take regular log backups.

If point...

Brad,

you cannot lock out or disable an account in SQL 2000. So even if you would read the error log for failed login attempts, there's no action to block an...

Just to clarify why I recommended Solid Quality.

Being a MCT myself and having talked to a lot of students, I noticed that the standard MOC courses often don't satisfy...

I would suggest to script out all the database objects, constraints, permissions,users etc.

When drop and re-create the database using the scripts.

This approach has as an advantage over truncating all tables,...

This will place a filter aon the database id.

declare @intfilter int

set @intfilter = 5

exec sp_trace_setfilter @TraceID, 3, 1, 0, @intfilter

One tip, if your not sure about the paramters and values...

You're right about the @sync_type parameter. A value of 'none' should indicate that the subscriber already has the schema and data is synchronised.

What parameter value are you using?

Markus