AutoNumber Reset in SQL 2005

This post is pretty much just a note for myself, but it might help someone too. When appending rows from an Access Database table to a SQL Server table of the same structure, sometimes SQL will not retain the ID's for AutoNumber fields. This can be a big problem for our ParaPlan application. In Access you can compact and repair to reset your autonumber fields back to 0 or 1 obviously. However, I never really figured out how to do that in SQL 05 until now.

To clear a table's records and reset the autonumber in SQL 05, just use the following syntax in a query on SQL db:

"truncate table dbo.drivers"

Comments

Transferring Outlook Data

Tim showed me how to use the Microsoft 'Save My Office Settings' tool, which worked like a champ as I was setting up my new machine. So if you want to have the same settings, toolbar locations, rules, etc. on a different machine...just go to Microsoft Office Tools->Save My Settings. Then transfer that file (*.OPS) to the new machine and load it the same way, very nice. Now to Outlook... I wanted to transfer all of my outlook data to the new machine also, which required messing with the infamous 'outlook.pst' file. This file can be found at "C:\Documents and Settings\Kyle Archer\Local Settings\Application Data\Microsoft\Outlook\". I found out that PST stands for 'Personal Store' according to Microsoft. Anyway, this monster file contains all your emails, events, contacts, notes, etc. It can get quite large and mine was appraoching a Gig. Even when you clean out your junk mail, delete stuff then remove your 'Deleted Items', it doesn't do m...

The Ole Village Greens Golf Course

Peez took me out to one of our old college favorites 2 weekends ago. The course is called THE VILLAGE GREENS and it resides in lovely Ozawkie, KS near Perry Lake. We played this course quite a bit in our later days in college because it was cheap and fun. All we had was Alvamar when we were at KU and she’s a little pricey for college kids. Anyway, it was humid and hot but good times. After, we stopped in Oskaloosa to watch the final round of the PGA at some local ‘downtown’ bar called Angie’s?

Simulating A Right-Click From The Keyboard

I have been doing quite a bit of LogMeIn (IT Reach and Rescue) lately and sometimes my mouse right-click does not work to get context menus. Therefore, if you ever have this issue, just select the icon or item you need and press [Shift] [F10]. I am sure Tim could have told me this, but he wasn't here :)

Kyle Archer

Search This Blog