SELECT dbid FROM master.dbo.sysdatabases WHERE name = 'database_name'

Read More »

Need to make a clone of a database structure, but have too many procedures/functions/tables to do it all manually? I believe this is a good answer to that problem:

Read More »

EXEC sp_MSforeachtable "exec sp_spaceused '?'"

Read More »

Use this SQL server script from the SQL query window to rename an existing database. The script below will place the database in single user mode then rename the device and put then new device name back into multi user mode for use.

Read More »

Run a query against sysprocesses to figure out what is going on on a SQL Server

Read More »

qwista / rwinsta command line tools

Read More »

Configuration Options for an RDP file (which is really a txt document).

Read More »

If you haven't already checked this software out.. you should. The ultimate enterprise email software

Read More »

If you have access to your Imail registry, and need to decrypt the hash passwords in order to convert to another (better) mail software, here's what you would need to know....

Read More »

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Read More »

Search error log for "Return value 3" and trace to find out what you're missing, then install that, then go with it.

Read More »

ex: ./SiteCode to ./Backup-YYYY-MM-DD-WKD

Read More »

set VAR=%VAR:/=-% would replace any / with - in a variable..

Read More »

Found this article, and have had to search this out each time, so this time I'm blogging it so I don't have to find it again.. besides, others may like it.. How To Add the "Export To Excel" option To Internet Explorer if it isn't there, but excel is installed.

Read More »

For example a service left over rootkitreveler or psexec service like ASHDBDK linked to a non-existant temp file in the users temp directory (sysinternals services) using SC

Read More »

SET UtilPath=%~dp0

Read More »

Redirects output of command line tools to the Windows clipboard. This text output can then be pasted into other programs.

Read More »

Here's a quick how-to (for those technically inclined) on: How to Get the Current Activity for a Single Database (SQL2000) when running as a DBO not as a sysadmin

Read More »

Great for queries where you need > date < date results..

Read More »

This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or technical support provider for troubleshooting purposes.

Read More »

Ex: MRTG Calculation on a switch port showing the BW rate, to determine the GB Equivalent amount of Data Transfer.

Read More »

To Load from a Text File into MSSQL

Read More »

Custom Module Developer

Read More »

Closes the current error log file and cycles the error log extension numbers just like a server restart. The new error log contains version and copyright information and a line indicating that the new log has been created. MSSQL.1\MSSQL\LOG\ERRORLOG

Read More »

Shared servers usually have many databases belonging to different customers, and MS SQL Server Management Studio (SSMS) will display all those databases when used by a valid login to connect to SQL Server 2005. If you seek to change that default behavior, you can do so with a SQL Server 2005 configuration change.

Read More »