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
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
