EdVassie (5/29/2009)

The only way to fully exploit the 64 GB memory installed on the box is to install 64-bit Windows and 64-bit SQL Server. With 64-bit SSAS on a 64GB...

That was a pretty good one...:-) Nice poem 😀

Jack, that was a pretty simple solution you gave him. I guess he did not even look at the solution you provided. Or did not understand... 😀

Or maybe he wants...

ooops...Sorry.. 🙂 I have never used powershell so I did not want to make a comment on that. Next time I will know better.

Or you can add it as a job if it is to be run at a regular interval.

Gopal Sharma (2/19/2009)

---

We follow pretty much the same as Steve mentioned, only significant difference being the stored procs. For stored procs we use p_ .

For user defined procs, we should...

Couple of things to keep in mind when doing this. Make sure that port 1433 is open and UDP port 1434 is open between the two server. 1434 is need...

You can specify where you want to do the snapshot. At the time of setting up the publication, you specify which drive on which server it should be. Make sure...

Gail, Look at the brighter side. Now you have something to do... 🙂 Figure out the drive to be replaced. 😀

When you add an article using sp_addarticle, there is a parameter called @del_cmd. if you give the value for this as 'NONE' then no action is taken. You can see...

I liked the thread about the table Status.... 😀

I love cricket. To be honest, that is the only physical sport I really love. I actually prefer watching the five day matches. The technique, the patience and the aggressiveness...

That has changed with the introduction of 20/20. Faster pace,...

GilaMonster (5/28/2009)

---

Grant Fritchey (5/28/2009)

---

Sorry to hear it. I love big dogs. We have an 80lb German Shephard,...

Kit, Iguana is a delicacy in my island.. 🙂 They make soup out of it. Tastes like chicken. They call it the Natural Viagra from Curacao ... 😛