Archive for May, 2009

How to create system stored procedure in SQL Server 2005

Thursday, May 28th, 2009

In other words how to create a procedure visible in any user database.
1. Start the server in single user mode:
   sqlservr.exe -m -s SQLEXPRESS
2. Make mssqlsystemresource writable:
   alter database [mssqlsystemresource] set read_write
3. Create the procedure:
   create proc sys.sp_demo
as
return 9
   NOTE: The procedure name must start with sp_ to make create statement [...]

Wireshark Version 1.0.7 (SVN Rev 28014) on Mac OS X 10.5.6

Sunday, May 3rd, 2009

After installing Wireshark on my iMac I was getting the following errors:
The following errors were found while loading the MIBS:
-:0 1 module-not-found failed to locate MIB module `IP-MIB’
-:0 1 module-not-found failed to locate MIB module `IF-MIB’
-:0 1 module-not-found failed to locate MIB module `TCP-MIB’
-:0 1 module-not-found failed to locate MIB module `UDP-MIB’
-:0 1 module-not-found failed [...]