Two years ago I started supporting a Classic ASP application that used SQL 2000 for the data base. One of the complaints of the owner was that the previous person supporting the application did not keep track of program changes. The development environment was undocumented. A test system existed but it was in an unknown [...]
SQL Server and Subversion
April 10th, 2010 · No Comments · sql
Tags: sql·sqlserver·subversion
Script all data of a table – SQLServerCentral
April 3rd, 2009 · No Comments · windows
I made a couple of minor changes to the provided script and I got Script all data of a table – SQLServerCentral to work with SQL 2000. I like the idea of creating scripts to transfer/update/re-create tables. I have been using Excel to create scripts to update shipping costs for some time. Nice work Florian!
Tags: sqlserver
How do I run sp_spaceused for all tables in a database? – TechNet Forums
November 5th, 2008 · No Comments · SBS2K-SBS2K3
I was looking for a way to list the size of all the tables in database again and I found this nice bit of code. I made a small change on the select statement to create a calculated integer field so I could get a nice descending sort on size. It worked for me! select [...]
Tags: SBS2K-SBS2K3·sqlserver
SQL 2005 Express Tips
March 17th, 2008 · No Comments · SBS2K-SBS2K3
My version of SQL 2005 Express was installed when I installed Visual C++ Express Edition. Today I was trying to use the Upsizing Wizard included in Access 2003 when I ran into SQL Server problems. So here are my tips: Go into the SQL Configuration Manager and enable TCP/IP if it is disabled. Someone wrote [...]
Tags: sqlserver