OMG! CPS 3!

What an amazing feat those guys managed to achieve! The almost-unbreakable CPS3 system has been cracked! On to some SF3 outside of the Playstation -- and just when I thought I was going to have to do without :-)

More SQL fun -- a copy statement

Here's a simple copy / paste T-SQL statement. This uses the Northwind Database, but you could adapt it for your needs -- and just remember, you can't do the select *, because of the identify/auto-numbering on CategoryID

insert into categories
select CategoryName, Description, Picture from categories where categoryid = '1'

Helpful T-SQL Hints!

Found an excellent guide for some of the quirkier moments when you can't get at the Enterprise Manager -- this is one, just to list the tables in a SQL database!

Select Table_name as "Table name"
From Information_schema.Tables
Where Table_type = 'BASE TABLE' and Objectproperty (Object_id(Table_name), 'IsMsShipped') = 0

I myself might change the Objectproperty we're looking for (perhaps erroneously!)

Select Table_name as "Table name"
From Information_schema.Tables
Where Table_type = 'BASE TABLE' and Objectproperty (Object_id(Table_name), 'IsUserTable') = 1

Oh Wait -- How Unhelpful!

You actually can't install Exchange 2007 on Longhorn Beta 3 -- thanks for telling us! :-D Time to install 2003...

Well that would have been helpful!

What's a poor boy to do if he's running the Longhorn Beta 3 and the Exchange Server 2007 trial tells him he needs Powershell? Why, follow the awful directions of course! That lead to nowhere, of course! :-D

You can actually now add Powershell as a feature, if you go to the server manager, it's there under "Windows Powershell" -- how helpful!