Apr 8 2010 16:00 EST
This took me way too long to figure out, so I'm blogging it. If you want to find the columns in the user defined type you just defined and forgot about here's what you do:
create type ImGoingToForgetThis table ( [id] int, [ie] int, [if] int ) --Now close your query window... exec [sys].sp_table_type_columns_100_rowset 'ImGoingToForgetThis'
Likewise, if you want to run the iisapp.vbs utility in IIS7 - it was replaced. Instead drop this vbs script into %systemroot%/system32:
sub shell(cmd) dim objShell dim result Set objShell = WScript.CreateObject( "WScript.Shell" ) Set oExec = objShell.Exec(cmd) Do While Not oExec.StdOut.AtEndOfStream output = oExec.StdOut.Read(1000) WScript.Echo output Loop end sub shell "C:\Windows\system32\inetsrv\appcmd.exe list wp"
required, hidden, gravatared
required, markdown enabled (help)
* item 2
* item 3
are treated like code:
if 1 * 2 < 3:
print "hello, world!"
are treated like code: