May 2008 Blog Posts

A Cheap, DIY way to document SQL Server databases

I've always had a problem with documentation. I agree it's absolutely necessary; it's just often the requirements for documentation are so vague that I never know if I'm done or not. One way to enforce standards when documenting tables and views in SQL Server is by using extended properties and auto-generating the documentation. I've used many free tools to do exactly this over the years; currently I favour SQLSpec. If you're interested in a cheap, do-it-yourself method of documenting SQL Server databases, check out this article titled "Create a SQL Server Data Dictionary in Seconds using Extended Properties" at MSSQLTips. Although...

posted @ Tuesday, May 27, 2008 8:08 PM | Feedback (0)

Adding Object Permissions to SQL Server 2005 Script As...Create Right Click Menu

One annoyance I have with SQL Server 2005's right click "Script As...Create" is that permissions on the object(s) to be scripted are not included by default. You can change this in SSMS by going to Tools, Options and then selecting "Scripting" from the tree. There are lots of options for changing how scripts are generated - see this MSDN entry for the full rundown on scripting options. To add permissions to the "Script As...Create", scroll down to "Object scripting properties", and set "Script permissions" to "True". Done! Now if only I could get a DROP in the script before the create... Tags: sql server,...

posted @ Sunday, May 18, 2008 11:00 PM | Feedback (0)

«May»
SunMonTueWedThuFriSat
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

Subscribe

Recent Posts on Thomas Williams Tech Blog
Recent Posts on my personal blog, Thomas Williams.blog

About
Archives
Post Categories
Syndication:

RSS