Reset your primary key column (identity) in your MS SQL table
I was working with a clients database earlier this morning, as they are in the process of cloning their primary web application for another client. Their internal DBA just took a backup of the database, and restored it to a new location. So as I was going through the database I realized that I would need to reset the primary keys for some of the tables in the database. I don't this very often, and I had to dive into my bag of script goodies to remember how to do this. So, I thought I would share:
DBCC CHECKIDENT('table_name', RESEED, 0)
Just replace the table_name with the actual name of the table in your database, and specify the number you want the primpary key (identity) to restart with, and BAM you are done.
View Article »Updating Replica Server Mount Paths
This past weekend I was apart of a massive upgrade of Windchill 9.1 to Windchill 10. One the things I ran into, and I thought I would share, was that the Vault Configuration UI under the File Server Administration module within Windchill 10 doesn't allow you to update the mount paths. For this specific upgrade we needed to move the remote vault root folders and replica folders to a more central location on all of the remote cache servers. Prior to the upgrade the root and replica folders was located under the Windchill 9.1 Windchill folder (D:PTCWindchill_9.1WindchillVaults). For this upgrade we moved these folders to the root of the D drive (D:Windchill_Vaults).
After the upgrade of the master server was complete all of the root and replica folder mounts were in...
View Article »
The latest rant from Patrick Lee of HyphenStudios / ExposureMind
I am going to keep this post short, even though it's been almost 6 or more months since the last time I have actually posted something on here. I had big ambitions for this site, but due to my real day job as a web developer / programmer / application administrator my work life balance went to out to sea. So why am I writing something now? Why not..... I mean, this is my blog / tech site. I am getting some traffic, and have even had an article or two written about my interactions with PTC's Windchill PDMLink tool. I have been contacted a few times by outside companies looking for help with their PTC Windchill implementations.
So what am I doing now? Well, I still have my day job, and I am still coding away on one off projects here and there. I am currently working ...
View Article »
