So if you have installed MSSQL as late you will notice the server wants your Firewall disabled. Woot eh? Just think open databases for all. I decided to look a little closer than just opening ports up to the world. Or just disabling my firewall all together. Found I could just easily open up the [...]
sp_changeobjectowner [ @objname = ] ‘object’ , [ @newowner = ] ‘owner’ SELECT ‘EXEC sp_changeobjectowner ”’+ SCHEMA_NAME(schema_id) + ‘.’ + OBJECT_NAME(object_Id) + ”’, ”dbo”’FROM sys.tables In order to change the owner of an object in the current database, use the sp_changeobjectowner system stored procedure. The basic syntax is as follows: sp_changeobjectowner [ @objname = ] [...]
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 .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, “Courier New”, courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode [...]
Before I start I have to give a huge hat tip to Wade Wegner for these scripts as they are not mine. I am simply just helping to make them more accessible. Truth be known these scripts should be included in every install of Commerce Server 2007. Create CS 2007 Local Users VB Script: ‘ [...]
So Hard To say GoodBye! Today Was a promise to be a good Data Day! On the Agenda was first ADO.NET Futures(Jasper.NET Project) Heirarchial Data Binding using CLR and ADO.NET Technologies. Using New IronPython Dynamic Data links and Reflection. **Spoiler for you C# fans like me… NO SUPPORT… *** Basically You have to be A [...]
