Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Easily calculate the size of your tables Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, April 09, 2009 5:35 AM
 Grasshopper Group: General Forum Members Last Login: Wednesday, June 19, 2013 5:34 AM Points: 14, Visits: 340
 Comments posted to this topic are about the item Easily calculate the size of your tables
Post #693876
 Posted Monday, May 04, 2009 5:17 AM
 UDP Broadcaster Group: General Forum Members Last Login: Yesterday @ 5:41 AM Points: 1,470, Visits: 2,571
 You could just use this`EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "`
Post #709313
 Posted Monday, May 04, 2009 8:48 PM
 Forum Newbie Group: General Forum Members Last Login: Tuesday, June 16, 2009 8:30 PM Points: 1, Visits: 6
 I am getting eror( i m using sql server 2005):Msg 102, Level 15, State 1, Line 9Incorrect syntax near ' '.
Post #709869
 Posted Monday, May 04, 2009 8:58 PM
 Valued Member Group: General Forum Members Last Login: Sunday, December 01, 2013 8:34 PM Points: 64, Visits: 533
 It doesn't work - Msg 102, Level 15, State 1, Line 10Incorrect syntax near ' '.on spt_values.number = 1 and spt_values.type = 'E'
Post #709873
 Posted Tuesday, May 05, 2009 3:51 AM
 SSC Rookie Group: General Forum Members Last Login: Wednesday, March 02, 2011 9:02 AM Points: 49, Visits: 191
 Remove everything that looks like a space at the beginning of lines 10 and 11, i.e.`...on spt_values.number = 1and spt_values.type = 'E'...`Paul.
Post #710011
 Posted Tuesday, May 05, 2009 9:45 AM
 Grasshopper Group: General Forum Members Last Login: Wednesday, June 19, 2013 5:34 AM Points: 14, Visits: 340
 Thanks for the comments. Some non-printing characters got in there - it should be fixed soon.
Post #710398

 Permissions

 Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.