Calling an external EXE inside a trigger is never recommended. I think you may do it in another way, for example, insert a record to a "control" table, which will...

In a publisher, you can have multiple publications, and each publication can have multiple subscriptions on different servers.

For your requirement, if you publish different columns from one table (publisher side)...

Andy (and Steve, Brian), why not start a new SQL Server Professional Organization with your ideas put into practices? Maybe it can be another great success, same as SSC...:)

After two years since sql 2k5 was released, who can say Production DBA is at an end? Alex, you are great because your comments are proved to be true.

I...

Phil, I think your comment is very valuable here. Yes, I totally agree that a data warehouse DBA should have some different perspective / knowledge in terms of managing VLDBs,...

It is because now posting jobs will be charged.

Personally, I doubt this is the right way to go.

Thanks a lot to everyone who makes a comment here, your comments are great!

I'd like to shed some lights on why I coined this DBAA term here. My personal background is...

I guess the concern here is "not to do snapshot for reinit" work, if this is true, I'd use a backup file from the publisher side and restore it to the...

You can always count on the performance counters to see where and what the bottle neck is.

But one thing in your case is to make sure that your db log is...

I grew up in China and now worked in Vancouver, Canada where it is about 6000 miles away from where I was born.

For the last 8 years, I worked across Canada...

SQLBill, could you make sure that your IE allows cookie? It seems I experienced exactly the same thing one month ago. But after I enabled the cookie, it works fine...

From your description, I guess you feel a little bored with your current work. My thought is: 

As a sole DBA, I think you have sole authority in deciding how to...

I surf through SSC almost daily from the earlier days it was launched. I just cannot remember what brought me to SSC at the time.

How about this:

If @@servername = 'DEV-Environment'

   exec link_server_1....

if @@servername = 'Test-Environment'

   exec link_server_2...

if @@servername = 'Prod-Environment'

  exec link_server_3...

It is "simple and stupid" conforming to KISS (keep it simple and stupid)...

Can a Canadian citizen (with TN1 visa) apply?