How to create database from script file?

Hi
I use SQLServer 2000 with SP3
I have script file that has been created using "generate SQL script"
command from SQL server Enterprise manager.
But I can't find how to create database using this script file. Is there
any way to create database from script file?
I appreciate your help!check out www.dbghost.com
>--Original Message--
>Hi
>I use SQLServer 2000 with SP3
>I have script file that has been created using "generate
SQL script"
>command from SQL server Enterprise manager.
>But I can't find how to create database using this
script file. Is there
>any way to create database from script file?
>
>I appreciate your help!
>
>.
>|||Copy the script to the clipboard during the "generate sql script" command.
Start the query analyzer and past the script
Run the script.
(You could also save the script and open it in the query analyzer)
--
Nico De Greef
Belgium
Freelance Software Architect
MCP, MCSD, .NET certified
"JK" <invalid@.address> wrote in message
news:e0JzX2Q$DHA.808@.TK2MSFTNGP12.phx.gbl...
> Hi
> I use SQLServer 2000 with SP3
> I have script file that has been created using "generate SQL script"
> command from SQL server Enterprise manager.
> But I can't find how to create database using this script file. Is there
> any way to create database from script file?
>
> I appreciate your help!
>|||In the Options tab of generate script, you have the option to "Script
Database". This will include the CREATE DATABASE statement.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JK" <invalid@.address> wrote in message
news:e0JzX2Q$DHA.808@.TK2MSFTNGP12.phx.gbl...
> Hi
> I use SQLServer 2000 with SP3
> I have script file that has been created using "generate SQL script"
> command from SQL server Enterprise manager.
> But I can't find how to create database using this script file. Is there
> any way to create database from script file?
>
> I appreciate your help!
>

how to corrupt a db

I want to purposely corrupt a db for some testing. Any ideas on how this can
be accomplished?
--
SQL2K SP3
TIA, ChrisRhow about mashing up the mdf using Notepad as your editor?
"ChrisR" wrote:
> I want to purposely corrupt a db for some testing. Any ideas on how this can
> be accomplished?
> --
> SQL2K SP3
> TIA, ChrisR
>
>|||> I want to purposely corrupt a db for some testing. Any ideas on how this
> can
> be accomplished?
sp_configure allow, 1
go
reconfigure with override
go
update dbo.sysindexes set FirstIAM = 1234
where id = OBJECT_ID('YourTableName')
go
sp_configure allow, 0
go
reconfigure with override|||Perfect. Thanks.
"RADl0PASlV" <RADl0PASlV@.seznam.cz> wrote in message
news:en9sdjz9EHA.3592@.TK2MSFTNGP09.phx.gbl...
> > I want to purposely corrupt a db for some testing. Any ideas on how this
> > can
> > be accomplished?
> sp_configure allow, 1
> go
> reconfigure with override
> go
> update dbo.sysindexes set FirstIAM = 1234
> where id = OBJECT_ID('YourTableName')
> go
> sp_configure allow, 0
> go
> reconfigure with override
>

How to copy production master db into test environment

SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
My goal is to re-create our production environment in a test environment, on
a test sql server.
What is the proper method for copying the contents of our production
'master' database to a test server?
I've tried multiple DTS exports into the test server's 'master' database
without success.
Appreciate any help and suggestions.
ZawI prefer using BACKUP and RESTORE for this. You then have to handle your
users/logins mappings. Read about sp_change_users_login in Books Online for
more info on that.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"zaw" <threewise@.comcast.net> wrote in message
news:uYurJ5IqDHA.1960@.TK2MSFTNGP12.phx.gbl...
> SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
> My goal is to re-create our production environment in a test environment,
on
> a test sql server.
> What is the proper method for copying the contents of our production
> 'master' database to a test server?
> I've tried multiple DTS exports into the test server's 'master' database
> without success.
> Appreciate any help and suggestions.
> Zaw
>|||i don't know what you want out of master, but if it's just logins use
sp_help_revlogin.
if it's jobs, script jobs on prod and use script to recreate on test after
editing appropriately.
if it's dts packages, save them to test server and then edit appropriately.
if it's databases, backup on prod and restore to test.
if it's publications and subscriptions, good luck ;)
zaw wrote:
> SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
> My goal is to re-create our production environment in a test environment, on
> a test sql server.
> What is the proper method for copying the contents of our production
> 'master' database to a test server?
> I've tried multiple DTS exports into the test server's 'master' database
> without success.
> Appreciate any help and suggestions.
> Zaw