So Steve, Jack and/or Denny has two now. One is me and the other is Jason....

Grant Fritchey (7/19/2010)

---

Steve Jones - Editor (7/19/2010)

---

Grant Fritchey (7/19/2010)

---

Jack Corbett (7/19/2010)

---

Thanks all for your confidence, but don't commit your votes until I make it past the nominating committee AND you...

The IO is usually the bottle neck in a DB Server and people tend to ignore this when setting up DB Servers. There fore keep in mind that the more...

Set up log shipping to the new server. Once every five minutes would be better since when you have to cut over, you dont have a big transaction log. Make...

Kit G (7/19/2010)

---

And, of course, I'm not bashing Indian programmers in general, just that developer specifically. The reaction would have been the same no matter the nationality/citizenship of the...

If I am not mistaken the BCP is trying to store the value 7986011679 as an INT. The max value for an int is 2147483647.

Try running sp_removedbreplication on your publisher. I think that will remove everything and then you can continue.

Ah...Indians...The company must be situated in Hyderabad.... Usually the companies situated in Bangalore are good when compared to companies in Hyderabad or north of India.

I am not sure what you are trying to do. You have database A. You created a Windows Group Apress_Product_Controllers and added the two login Omar and administrator to that...

Jack and Steve, Next year I am going to put some time aside for volunteering for Pass. So contact me if you need me next year for volunteer work... 🙂

Kit, You are Gus's wife? So there are two smart people talking about SQL Server all the time at home 🙂

Steve Jones - Editor (7/18/2010)

---

Jack Corbett (7/18/2010)

---

Glad to see that Steve is running for the PASS board of directors. I don't think that there are any better candidates out...

I think you should read about Powershell and you will get the answer to your question very easily. There are lots articles here in SSC itself about these scripting languages.

After...

Just adding to it, You could set up the snapshot agent to run in the night to snapshot the data again to your warehouse. But this is NOT recommended for...

Are you talking about NT privileges? If so there are couple of things you will have to give depending on the OS.

Here is a good link to help you...