adding datafile to database

sql server 2000 sp4
Hi
I have a database that was initially created for 70MB. It has a application
associated with it and can not be deleted. I need to increase size of the
database to 440 GB. What is the best way of doing it.
--
ontario, canadaDo you want to add another file or increase the size of an existing file? Anyhow, both operations
are very straight forward:
ALTER DATABASE db ADD FILE (...)
ALTER DATABASE db MODIFY FILE (...)
You find exact syntax in Books Online. It will take a while to add or grow a file close to half a
terabyte...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"db" <db@.discussions.microsoft.com> wrote in message
news:0030A5B4-3B73-440A-9710-9A210DBBD9D9@.microsoft.com...
> sql server 2000 sp4
> Hi
> I have a database that was initially created for 70MB. It has a application
> associated with it and can not be deleted. I need to increase size of the
> database to 440 GB. What is the best way of doing it.
>
> --
> ontario, canada

adding another system administrator

Hi all

I deleted the sa account

how do I add it with all the correct permissions (plus include it in all the tables )

TIA

Guy

Recreate the login 'sa', then add it to the sysadmin server role For more information about sa, take a look at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_8soe.asp