script to get all tables an sizes

Question

Post reply

script to get all tables an sizes

neneco56

Ten Centuries

Points: 1232
More actions
December 12, 2008 at 10:40 am

#125755

I need a script to get all tables and sizes to analyse a server
just script
thanks

Viewing 15 posts - 1 through 15 (of 26 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

http://www.sqlservercentral.com/scripts/Miscellaneous/30830/

ps. One Orange Chip Points: 29422 More actions · Answer 2

select name from sysobjects where xtype='U'

Declare @tab1 varchar(255)

Declare Space_Cursor Cursor for

select name from sysobjects where xtype='U'

open space_cursor

fetch next from space_cursor into @Tab1

while @@fetch_status=0

Begin

PRINT sp_spaceused @tab1

fetch next from space_cursor into @tab1

PRINT ''

end

close space_cursor

deallocate Space_cursor

-- i didnt test the script

Pradeep Singh

neneco56 Ten Centuries Points: 1232 More actions · Answer 3

I cannot use cursor or loop or create table, I need a simple script to do the job,any ideas?

neneco56 Ten Centuries Points: 1232 More actions · Answer 4

I need a script to analyse the intire sql, all the tables,sizes,logs

spaceused,unusead, free space everything please

help !!!!!!!!!!

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

This should do it. You can use it either as a query or a View: http://www.sqlservercentral.com/scripts/tables/62545/

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 6

neneco56 (12/12/2008)
I cannot use cursor or loop or create table, I need a simple script to do the job,any ideas?

Trade ya... tell me why you cannot use a cursor or loop or create a table and I'll give you the script I use... I'd give you the script first, but learned my lesson on things like this... no one takes the time to explain even though I've helped... 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 7

rbarryyoung (12/12/2008)
This should do it. You can use it either as a query or a View: http://www.sqlservercentral.com/scripts/tables/62545/

Heh... dammit... now I'll never get the answer to my question...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

neneco56 Ten Centuries Points: 1232 More actions · Answer 8

it's because the application running is DELPHI and it cannot run procedure,cursor,create table, just need a script to run

I did not build the application I'm just a DBA

RBarryYoung SSC Guru Points: 143329 More actions · Answer 9

Jeff Moden (12/12/2008)
rbarryyoung (12/12/2008)
This should do it. You can use it either as a query or a View: http://www.sqlservercentral.com/scripts/tables/62545/
Heh... dammit... now I'll never get the answer to my question...

Have faith, my son, the answers will come...

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

neneco56 Ten Centuries Points: 1232 More actions · Answer 10

neneco56

Ten Centuries

Points: 1232

December 12, 2008 at 12:07 pm

#911859

I answer already, please give me the script

thanks

neneco56 Ten Centuries Points: 1232 More actions · Answer 11

neneco56

Ten Centuries

Points: 1232

December 12, 2008 at 12:10 pm

#911863

I answered already

RBarryYoung SSC Guru Points: 143329 More actions · Answer 12

Try the one that I pointed you to. Let us know if you need anything that it does not provide.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

neneco56 Ten Centuries Points: 1232 More actions · Answer 13

Doesn't work, this is the problem, we are trying to build a report

with a sql script to run that script at the customer to check is

sql server and all tables, we cannot create a table or procedure

or anything else at the customer, I need a simple scriptthat go true

all the tables and give us the report, it's possible?

whitout loop because the delphi does not suppot that also.

thanks

RBarryYoung SSC Guru Points: 143329 More actions · Answer 14

Yes, my script does work. It is exactly what you are describing, it is "just a simple script", in fact it is a single Select statement. So, you should try it first, and then if you have a problem tell us what that problem is.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]