@megan, in that situation I usually take advantage of the SID property: I copy the login from Prod to Dev servers, changing the password on Dev. Whenever we...

Comparing to Oracle is a bit overkill. I work with both and the "one instance = one db" which exists until 11g does more harm than good: if you want...

I agree @Aaron, SPs used to contain new features and require more testing. My point was about the effort to get people involved and documenting the whole process...

Jim P. (1/28/2014)

---

(...) Install any OS from the RTM disk/image and then run the Window's updates. There where be hundreds of MB downloaded to get the OS to the current...

I'm sorry to spoil @gary, but even if he is not directly affected by the CUxSP question, a lot of developers worldwide will be (in time). This is...

nice article, it's good to see those papers re-published.

can anyone help me on how to get the "hostname" from EVENTDATA() ?

ty

thank you very much! I was running a security assessment and your scripts will help me validate my results!

I've twitted it and will do a blog linking the article later...

Thanks for the reply Leo! I will evalute this method, because our current "insert-delete" takes forever to run every day... thanks for the article!

oh, this process is considering we can empty the table then? this is not my case, we need to archive a table where some records are current and can not...

I was a bit confused in the step that says to rename the table, and later to drop the renamed table. But maybe I missed something, will try to read...

just got SSMS installed at home. it works!!! too bad my corporate firewall blocks it... 🙁

MS says Management Studio 2008R2 is able to connect to Azure. 2008-non-R2 is NOT however.

(I forgot to try to access last night 🙁 )

Thanks for the quick reply, Steve, but I still can't access it. Maybe there is some firewall interfering, because I'm on a corporate network right now. I'll try again from...

I can't connect 🙁

I cecked the server name, login, password and database and all is correctly filled, but I can't connect in any way. I'm using SSMS 2008 R2, but...

Hi. This is a bit of an old thread, but this error happened to me today. And I confirmed that it is caused by missing the select permission on the...