If a table exists, use sp_spaceused.

If a tabe does not, then you need to include additional factors that take into account ... does the table have a clustered index or...

I just guessed "B" but thought "D" was the logical answer based on the limited information. However after thinking about it, "E" (none of the above) would have been correct...

... see you on the dark side of the moon ...

It's almost a case of de-evolution ... it seems that the sound process of waiting until SP2 has been out in GA for 3 months may be the key and...

A great 'constant' in the universe is 'change'. What makes criminals and the crimes they commit exempt from this immutable concept ? What makes IT professionals and IT users exempt from...

Thinus ... a few due dilligence questions ... SQL version on the client and server, and OS information please ... by the way ... too many typos on my last post in...

Beware though ... you are looking at an outage ... you most bring the instance down to add a new disk resource.

For Hans Brouwer: I'd try to reinstall EM and SP3a on your client computer. It's quick and easy. If it works, then problen solved assuming the access violation is on...

You can only turn off this option by file. First you need to execute sp_helpdb for the database in questino to get the logical file names for the mdf and...

Don't linger too long at the 'wasarrested' web-site ... it gave me a few pop-ups on exiting ... MagicKillah took care of the rest ...

Could it be that space is an issue ? You have to have enough free space on the given disk to support the uncompressed file, the compressed file and any other...

I understand that you do not need an email address to read the FAQ (and a number of other sections of the site). I was speaking about the this section...

I don't really know ... if the 'Fair Tax' is really 'fair' (and sinmple) then why does the web-site want to email me my taxes in 2-3 days ? I...

Ther are only a few 'sure things' in life ...

• Change is a 'constant'
• Taxes will always be there
• Death occurs - every moment we  live, we die a little more (see 'change')
• The...

Your spam folder is the last place things will be. GFive youe email/exchange administrator the from address. Depending upon the software in use (email and other) he has places to...