Tag Archive

assembly Best Practices BitVector32 blue screen Buggy Software C# Cellular code crash DNS duplicate e-mail eating Facebook find files food Google internet Java Job Linux Mail Mask Microsoft mobile Movies Offset Opinion programming script Software Development source code Sprint SQL SQL Dump t-sql Tips versioning vista web development wifi windows Windows Mobile WMI Workplace

How to alter table column to increase varchar size

Published on August 16, 2011 By RobK410

The top results in a general search through Google for keywords in the title of this post will return results which will not work with SQL server. Some suggest using the ALTER tablename MODIFY column syntax for which SQL Server does not support MODIFY. In order to change the size of a varchar column (or [...]

SQL Dump 2007 Build 2.1.2.11267

Published on November 26, 2007 By RobK410

MSSQL Dump is a backup tool that will let you create a SQL script database dump of a MSSQL (Including Express) database, similar to a mySQL sql dump with INSERTs included. This program will allow you to connect to a server, select a database; tables, views, sp’s, triggers, functions, and users and write SQL script [...]

Retrieving Column Descriptions from MS SQL

Published on September 20, 2007 By RobK410

Building a schema report of one’s database is a requirement for version control in any businesses CM system. Often developers will use the Description extended property of MS SQL server to detail the purpose of a column. When it’s time to write their schema report they usually wind up having to retype or copy and [...]