Hi,
sp_helpdb <DBNAME> will show you the available space per database device_fragment.
In order to increase the Database Size, try executing (I think you must be in master DB)
alter database <DBNAME> [log] on <database device> = <size in MegaByte>
Hope this helps,
Alexandre Murranga
-----Original Message-----
From: shashidhara.[Email Address Removed] terça-feira, 30 de Março de 2004 12:27
To: LazyDBA.com Discussion
Subject: RE: Dump database objects without owners
Hi,
Please let me know how to check tablespaces size in Sysbase and How it increase it. It is very Urgent
Thanks and Regards
Shashi
Team CSI
Transco-ODC
Bangalore
Tel:internal 8520408 Xtn 6117
Dial com:7121-707
-----Original Message-----
From: labuk das [mailto:[Email Address Removed] Tuesday, March 30, 2004 4:25 PM
To: LazyDBA.com Discussion
Subject: RE: Dump database objects without owners
Hi Sridhar,
In the development machine the user 'A' owns all the
tables and scripts. I want to give the script file to
the client who may use user 'A' or User 'B' or user
'sa'.
So i want to dump the database objects without owner
information. Is there anyway to get such ddl ?
Thanks for ur help.
Regards
Kumar
________________________________________________________________________
Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more.
Go to: http://in.insurance.yahoo.com/licspecial/index.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email Address Removed] immediately
and destroy all copies of this message and any attachments.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message may contain confidential information or privileged material,
and is intended only for the individual(s) named. If you are not in the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message
which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
Vodafone (Portugal)
MS Sql Server LazyDBA home page