Tuesday, April 22, 2008

It's always nice to learn something new

A co-worker recently introduced me to sp_MSforeachtable system stored procedure in SQL Server. I was suprised to find that it has been available for years and I am just now figuring that out. I usually use a cursor to iterate through tables using system objects but I think that this would be much easier to use. As an undocumented stored procedure, I knew that this was a "use at your own risk" but I thought I'd do a little research anyway on the proc to see what kind of things people are doing with this proc and found this forum

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2920286&SiteID=1

stating that sp_MSForEachDb and sp_ForEachTable are both on the deprecation list. Too bad. I wonder what they will replace these procedures with.

Monday, April 21, 2008

Starting out

I want to start my blogging by posting things that have helped me in recent projects. I will continue this over the next few posts. Some will be code and some will be helpful hints when working with day to day software. And to that end.....

In recent projects, we used Sharepoint for a portal and Team Foundation Server. I found that whenever I wanted to access a word 2007 document from either place, it would prompt me for a login even though I had set up my local network in my trusted sites. A co-worker showed me how to resolve this so I would like to pass it on


Open Word 2007
1. Click the last icon in the file menu (pulldown)
2. Select more commands
3. Select Trust center from the left side menu
4. Click Trust center settings button on the lower right
5. On the trusted locations tab check 'Allow trusted locations on my network'
6. Click the add new location button
7. Click Browse
8. Click Desktop
9. Click Network
10. Click on your server that houses TFS
11. Click OK
12. Click OK
13. Close trust center settings.
14. Open a TFS document without entering your password.

I hope this helps someone out there.