December 12, 2008 at 10:40 am
I need a script to get all tables and sizes to analyse a server
just script
thanks
December 12, 2008 at 10:48 am
December 12, 2008 at 10:54 am
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 ''
PRINT ''
end
close space_cursor
deallocate Space_cursor
-- i didnt test the script
December 12, 2008 at 10:56 am
I cannot use cursor or loop or create table, I need a simple script to do the job,any ideas?
December 12, 2008 at 11:08 am
I need a script to analyse the intire sql, all the tables,sizes,logs
spaceused,unusead, free space everything please
help !!!!!!!!!!
December 12, 2008 at 11:19 am
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]
December 12, 2008 at 11:23 am
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
Change is inevitable... Change for the better is not.
December 12, 2008 at 11:24 am
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
Change is inevitable... Change for the better is not.
December 12, 2008 at 11:26 am
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
December 12, 2008 at 11:31 am
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]
December 12, 2008 at 12:07 pm
I answer already, please give me the script
thanks
December 12, 2008 at 12:10 pm
I answered already
December 12, 2008 at 2:34 pm
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]
December 13, 2008 at 3:20 am
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
December 13, 2008 at 8:37 am
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]
Viewing 15 posts - 1 through 15 (of 26 total)
You must be logged in to reply to this topic. Login to reply