Geeks With Blogs
mikedopp Geekswithblogs (edition) May 2009 Entries
How to get a random record using MSSQL
This is a very short post. so bear with me. SELECT * FROM Northwind..Orders ORDER BY NEWID()The Magic here is NewID() Flickr Tags: NewID(), Random Records in MSSQL BuzzNet Tags: NewID(), Random Records in MSSQL Technorati Tags: NewID(), Random Records in MSSQL del.icio.us Tags: NewID(), Random Records in MSSQL IceRocket Tags: NewID(), Random Records in MSSQL LiveJournal Tags: NewID(), Random Records in MSSQL 43 Things Tags: NewID(), Random Records in MSSQL ......

Posted On Wednesday, May 20, 2009 7:49 AM

Commerce Server 2007: Determine the Service Pack (Lookup Script)
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 ......

Posted On Tuesday, May 19, 2009 11:36 AM

Shutdown Server Services on your Server
Um so you know its your dream to use windows server 2003/2008 as your desktop Operating system right? So most of you just said no. However for the small amount that might just be curious here is a little script to stop installed server applications built into these server installs. @echo off :start set /p _input="Server? [y/n]" if %_input% equ y ( echo Starting server services… sc start HTTPFilter REM HTTP SSL sc start IISADMIN REM IIS Admin sc start lanmanserver REM Server sc start MSSQLSERVER REM ......

Posted On Thursday, May 14, 2009 11:06 AM

Copyright © mikedopp | Powered by: GeeksWithBlogs.net