Keep an eye on this link[/url]- Steve Jones keeps it up-to-date when new updates are released.

Search the site for the 2005, and 2008 versions of the build lists...

karthik.catchme (11/30/2010)

---

Thanks for the Script. It is very useful. While scripting out the object level permissions, i think, the below line that has been highlighted (Underlined) should have been "QUOTENAME(SCHEMA_NAME(obj.schema_id))"....

I believe this would get you the schema permissions you are looking for. I'll have to update my script to include that as well.

select state_desc+ ' ' + permission_name...

Thanks for the feedback. That's a good update to it so that it sorts without displaying the sort counter. I knew it could benefit from some updates.

Thanks!

Steve

This is a good script script. I think it would be useful for checking for old backups as you suggest. Typically, we try to place backups we retain...

We were thinking the same way! - I submitted it immediately after I re-posted.

Thanks!

Steve

This one should work- I posted on another forum post a while back but can't find the link. You'd need to run it on each database you are scripting...

Ok thanks for the reply. I didn't think I'd gain much, but wanted to see what people who use SSAS had to say about it. Seems like I...

No comments on this one?

We have an administration server, and we maintain a list of the SQL Servers we support. We have an SSIS periodically connect to every instance in the list to...

barsuk (3/30/2010)

---

Well, I don't want to hurt his feelings if he is reading that thread, but basically because he wasn't fast enough, couldn't do more then 1 task at...

The resources would likely try to move to node 2 but won't come online. When node 1 comes back online, you should be able to move the resources back...

CirquedeSQLeil (8/24/2010)

---

Here are some important points for me (some already mentioned):

1. Source control.

2. Ensuring that QA or beta is exactly like production (some automated process would be good...

Thanks for taking a look at the article!

iqtedar (8/23/2010)

---

I have something similar to do but my scenario is little different, any suggestion would be highly appreciated. Lets say i need...

clementhuge (8/23/2010)

---

Thanks for your feedback on my two remarks.

I think we are on the same page as you enable then disable xp_cmdshell.

When I meant within the line, I was referring...