Browse by Tags

Find stored procedures that reference a table column

We recently moved away from SQL Server replication and the database still has all of the rowguid columns and their associated indexes and constraints in it. We wanted to gain all of that disk space back so we went ahead with scripting out the delete of...

Posted 16 June 2011 10:22 AM by Jeff Widmer | with no comments

Filed under: SQL Server, SQL, SQL Server 2008

ISO 3166-1 Country Data SQL Script

I am creating a standard sign up form with one of the fields being a country drop down. So I created my Country database table and then needed to fill it with information. I found the ISO list of countries here , but then the issue was how to get that...

Posted 09 November 2009 09:15 PM by Jeff Widmer | 5 comment(s)

Filed under: SQL Server, SQL Script, SQL, ISO Country Codes

Search

This Blog

• Home
• Contact
• About

News

Jeff Widmer's Home Improvement Profile
OrcsWeb Windows Cloud Servers
Vaasnet - Instant pre-configured virtual machines:
IE6 Virtual Machine
IE7 Virtual Machine
IE8 Virtual Machine
Firefox 3.6 Virtual Machine
Firefox 4 Virtual Machine
SharePoint Foundation Virtual Machine

Tags

• .NET
• .NET 4.0
• .NET Target Framework
• Amazon
• ASP.NET
• ASP.NET Membership
• ASP.NET MVC
• AspNetHostingPermission
• Automated Build System
• BabySmash
• Bing
• C#
• Canon Scanner CanoScan Toolbox
• CMS 2002
• Community News
• CruiseControl.NET
• CSS
• Elmah
• executionTimeout
• GDI+
• General Software Development
• Getting Things Done
• Gmail
• Google
• GTD
• Headsets
• Home Improvement
• HTML
• HTML Tips and Tricks
• httpRuntime
• HTTPS
• Hyper-V
• IEnumerable
• IIS
• IIS App Pool
• IIS6
• IIS7
• IIS7 Authorization
• Instant Church Directory
• jQuery
• Linq
• Linq2Sql
• Machine Setup
• OneNote
• Orchard
• osql.exe
• Outlook
• Outlook 2010
• Personal
• QuickBooks
• QuickBooks Online Edition (QBOE)
• random.org
• Recommendations
• Remote Desktop
• Sample Book Chapter
• Sample Code
• ScrewTurn Wiki
• Seinfeld
• SendTo
• SEO
• Sharepoint
• SharePoint 2010 Correlation ID
• SharePoint Foundation 2010
• SharePoint Workspace 2010
• Silverlight
• SMTP
• SourceGear
• SQL
• SQL Azure
• SQL Script
• SQL Server
• SQL Server 2008
• SQL Server Full-text Index
• SQL Server Management Studio
• SSL
• StackOverflow
• Subversion
• SVN
• Tiff
• Tips & Tricks
• Tips & Tricks
• Unicode encoding
• User Account Control
• Utilities
• Vaasnet
• VB.NET
• VB6
• Viral Marketing
• Virtual Machines
• Visual Basic
• Visual Basic 6.0
• Visual Studio
• Visual Studio 2010
• web.config
• WebConfigurationManager
• Windows 7
• Windows Azure
• Windows Character Map
• Windows Server 2008
• Windows Server 2008 R2

Navigation

• Home
• Blogs

Archives

• December 2011 (1)
• November 2011 (4)
• October 2011 (1)
• June 2011 (3)
• May 2011 (3)
• March 2011 (1)
• February 2011 (3)
• January 2011 (2)
• December 2010 (2)
• September 2010 (3)
• August 2010 (4)
• July 2010 (3)
• May 2010 (5)
• April 2010 (2)
• March 2010 (5)
• February 2010 (8)
• January 2010 (8)
• December 2009 (14)
• November 2009 (5)
• October 2009 (15)
• September 2009 (17)
• August 2009 (6)
• June 2009 (2)
• May 2009 (3)
• October 2008 (1)
• August 2008 (1)
• December 2007 (3)
• November 2007 (1)
• August 2007 (1)
• April 2007 (1)
• March 2007 (1)
• September 2006 (1)
• August 2006 (1)
• January 2006 (1)
• December 2005 (3)
• September 2005 (1)
• August 2005 (1)
• July 2005 (2)
• October 2004 (1)
• March 2004 (1)
• February 2004 (2)
• January 2004 (6)