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!
Script all data of a table – SQLServerCentral
April 3rd, 2009 · No Comments · windows
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 ‘Database [...]
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 a [...]
Tags: sqlserver
