Hi,

Check event log for more info and error message on why it is not starting.

Hi,

Sure... Post your tweaked script here so that it will help others... Thanks!

Thanks Jack... It works!

You cannot add wildcard % to a IN() clause!

IN clause compares value but LIKE command looks for pattern. You may need to use LIKE only!

Add a step in between which does the job of sending mail. It should work!

Also note that Any changes to Logon settings for SQL Server and Agent Should be done through Configuration Manager because behind the scenes it adds new groups to local system...

Without knowing what to do and how to do, you have done so much? 🙂

I suspect that the database name you have given in Initial Catalog is not available or...

So SQL 200 to 2005 migration is possible? 😀

so manually specify the port in your connection, then you dont need SQL Browser's help!

N Denotes that variable in nVarchar... No performance issue is related to this!

Right Click Publication Properties --> Articles --> Click on ... on table name --> Snapshot --> Tick on "Include declared referential integrity"

Check for pros and cons of doing this since...

As said by Krishna,

You can't take LOG backup for Master because Recovery Model is set as SIMPLE and even if you change it...

Is it one time requirement like Database Refresh or you want to implement standby solutions like Mirroring, Log shipping?

Can you ensure that you have providers properly installed by performing below operation?

In SQL Server Management Studio, expand "Server Objects->Linked

Servers->Providers" to see if there is a provider named

Microsoft.Jet.OLEDB.4.0.

Is there any...

ok ok don't worry... We are here to help you...

Go to security option of linked server select "Be Made using this security context" and type username and password both as...