yes, the wizard can do this

Which one...

Push seems to be the default. The optional settings under #6 show a pull sub.

sp_addsubscription has a default of push: http://msdn.microsoft.com/en-us/library/ms181702.aspx

Stefan Krzywicki (1/5/2012)

---

jcrawf02 (1/5/2012)

---

Brandie, not sure what you're referring to exactly, but nothing I've seen on the Thread would make me decide to not hire someone. Make them question my...

jcrawf02 (1/5/2012)

---

A large part of the healthcare issues are because everything is so disorganized. Doctors don't talk to patients, bill things incorrectly something close to 20% of the time (out...

Jack Corbett (1/5/2012)

---

I have it...

I would make sure you socialize this to clients and your help desk/support. If there is something using "sa" it will break after the update if you change the sa...

http://msdn.microsoft.com/en-us/library/ms147834.aspx

TOP 10 can grab one page (or a few) and return 10 rows. Any 10.

The order by means you must load the entire table to ensure you have the top...

A few free books we offer:

http://www.sqlservercentral.com/articles/books/76296/

http://www.sqlservercentral.com/articles/books/67441

Tx, corrected the typo.

Insurance sucks, in general

Ninja's_RGR'us (1/5/2012)

---

Steve Jones - SSC Editor (1/5/2012)

---

In terms of depreciation, it sucks, but it's real. The value of your stuff is lower over time, and if you had to replace...

jeff.mason (1/5/2012)

---

That brings up an interesting question -- how many DBAs have their backups go straight to tape? In my professional career I have never had a backup infrastructure...

Interesting. I wouldn't think it would matter since all editions can restore compressed backups, but apparently the header stores this.

Since I use separate media sets for all backups, not an...