Category Archives: SQL Server

ReSeed Identity column – TSQL

By Woody | November 9, 2009

Randomly I didn’t remember the code to reseed the identity column in tsql, this works though on ms sql 2008 – DBCC CHECKIDENT (tbl_crazyTableName, RESEED, 20000) TSQL

Also posted in Transactional SQL | Leave a comment

xp_fileexist Network Drive – T SQL Based File checking

By Woody | May 7, 2009

If you didn’t already know you can check whether files exist, find file sizes and all sorts of other useful things directly from within Transactional SQL Query. In this example I had a table containing a few columns that gave me the network drive location and filename of a few thousand files and I wanted [...]

Also posted in Social Media, Transactional SQL | Leave a comment

SQL Server Reporting Services

By Woody | April 9, 2009

SQL Server Reporting Services – Microsoft Reporting Services – Microsoft Visual Basic Reports – Microsoft Visual Studio Reports Whatever name you want to give them there is a great capacity in cutting edge Microsoft developer’s tools. You have to give it to them; they do continue to roll out tool after tool aimed solely at [...]

Also posted in Report Writing, SSRS | Leave a comment
Woody Hayday

    Join my mailing list!

    We respect your email privacy

  • Categories

  • Archives