– SQL Server tables and row counts declare tables_cursor cursor for select name from sysobjects where xtype=’U'declare @table_name sysname open tables_cursorfetch next from tables_cursor INTO @table_name while @@fetch_status = 0begin exec sp_spaceused @table_name fetch next from tables_cursor INTO @table_nameendclose tables_cursordeallocate tables_cursor
Archives for March 2008
Restoredb.bat
Using osql and trusted connection for SQL Server 2000. @echo off if {%2}=={} ( call :Usage goto :EOF)net stop mssqlservernet start mssqlserverosql -E -d master -Q “restore database %1 from disk=’%2′ with replace” goto :EOF::Subroutine area :Usage @echo Syntax: call restoredb.bat DatabaseNameFullDatabaseBackupPath goto :EOF
"Playtime" project: Porting Didiwiki to C#.NET
I’m hoping to find time to throw at least a quick port of DidiWiki to C#.NET together. Reference 1: Creating your own Web Server using C# – This article is from 2001, so there might be a significantly better way of doing things. Update: This CodeGuru page looks like a more original version of the [...]
Importing a runningahead log.xml into SQL Server 2005 using OPENXML
I don’t currently have a work-based use for 2005, so I thought I’d use the only readily available collection of data that I have at my disposal… my running log. This is an export file from RunningAhead.com. I don’t think I’m completely loading the XML data yet, and I don’t have database tables to load [...]
Posts