To those whom love Commerce Server 2007 as much as I do. Here is a little script to help you determine the Service Pack level of each database. use MSCS_Admin select s_PropertyName, s_Value From dbo.resourceProps This will return multiple values. This is helpful in knowing if you have Commerce Server 2007 installed correctly as well as helping you to identify the correct service pack upgrade number per database. SP1 Transaction Database = 7.0 Transaction Config Database = 7.0 Product Catalog Database...

I know what your thinking. Oh crap here he goes again with recommending tools and or services. My question is have I ever steered you wrong? Yes I normally deal in freeware tools. Mostly due to me being cheap and thinking my skills should push me past that latest issue with code. So why recommend a commercial tool? Good question. A friend recommended to me this tool. I had used tools like .net reflector to look into DLL’s to understand the application I am adding. I had heard rumor of NDepend however...

Most of you would rather the the first title before or. Can't Remember where I got most of this script(if you know please send me a hate email) however I did some enhancements and I am reposting it. DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int DECLARE DATABASES_CURSOR CURSOR FOR select DATABASE_NAME = db_name(s_mf.database_id) from sys.master_files s_mf where -- ONLINE s_mf.state = 0 -- Only look at databases to which we have access and has_dbaccess(db_name(s_mf.d... = 1 --...

So here is a question why would you want to add your Meta Tags via code? Kinda silly right? Cause if you were a great developer you probably have a whole list of meta tags you have created for your portfolio of web sites right? Well if you are the developer who has those templates you most likely will stop reading here and think this mikedopp character is kinda wierd or is one of those "because you can" type people. I know I am adding much too much fluff to this whole entry and spending too much...

This has been pooled together from a number of resources: What is ASP.NET? Microsoft ASP.NET is a server side technology that enables programmers to build dynamic Web sites, web applications, and XML Web services. It is a part of the .NET based environment and is built on the Common Language Runtime (CLR) . So programmers can write ASP.NET code using any .NET compatible language. What are the differences between ASP.NET 1.1 and ASP.NET 2.0? A comparison chart containing the differences between ASP.NET...

Getting back into the swing of things post MIX08. On another note. I have disabled my comments and track backs until further notice. Reason was over 3-4000 spam comments were effecting my database and slowing down my site. So please if you were offended I have been working to stay clear of the crap and deliver less crappy posts. On to the links: How to get Vista Breadcrumbs for Windows XP - Thinktechno.com 403day - An arrogant initiative in defense of the web Captain Obvious Mixtapes Public Domain...

Applications interact with the outside world. mmm? Mashups and such. ok Many types of outside data.... Images RSS Business services Intranet services Mashup API's silverlight1.1 xaml and fun -no easy way to connect to other services. What does client code look like? Custom services. Recommended uses of services in silverlight Using silverlight front end connecting to webservice or database directly. Using C# void list<product>getproducts (string searchstring) Create service Define What does...

So I have extra batteries on hand. Ready for the love of Silverlight2. Getting Video and trying to encode as fast as I can for the streaming. Woooh! Mix08. See the twitter feed for instant updates. www.twitter.com/mikedopp. Ray Ozzie Main points in keynote:Content, Commerce, Community. Making cracks about the yahoo purchase or working on purchase. Media Zune, PC, Xbox360 working better together. Xbox360 might finally get a the web? Microsoft going google docs with word excel and such Office Live...

So I get this email. I forgot/lost the sa password. What to do? So I scrub the google database. Looking for an answer: Source Forgot or lost your sa password? Don't worry, there is a way out. Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password: sp_password @new = 'will_never_forget_again', @loginame = 'sa' Technorati Tags: SQL 2000, MSSQL, Microsoft,...

So I finally convinced the rest of the developers and database admins to use subsonic and all the fast sweet love that comes with it. However I ran into a snag when trying to setup multiple databases using subsonic. Maybe I should clarify: <SubSonicService Default""> <providers> <clear/> <add name="DefaultDB" type="SubSonic.SqlDataProvi... SubSonic" connectionStringName="Conne... generatedNamespace="Default... <add name="DefaultDB2" type="SubSonic.SqlDataProvi...

So I have been working intensely with Subsonic lately and I need to change the database back end. Add a table and delete some columns. Oh boy! It is very simple just delete the .abp file and create a new one. Now rebuild the web project and enjoy the updated objects