emptying database - Microsoft SQL Server

Phung

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.

Oct 22 '07 #1

Subscribe Reply

1439

Greg D. Moore \(Strider\)

"Phung" <pu***@purwadhika.comwrote in message
news:11**********************@e9g2000prf.googlegro ups.com...

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.

You could drop and recreate the DB.

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Oct 23 '07 #2

Jack Vamvas

If you are dropping and recreating , don't forget to take a script backup of
the db

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com

"Phung" <pu***@purwadhika.comwrote in message
news:11**********************@e9g2000prf.googlegro ups.com...

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.

Oct 23 '07 #3

Similar topics

3314

ERROR in Standby database setup with RH9

by: Cherrish Vaidiyan | last post by:

sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps in this site : ...

Oracle Database

7302

SQL1224N A database agent could not be started to service a request

by: Marvin Libson | last post by:

Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database...

DB2 Database

7881

Database Physical Location in UDB 8.1

by: Kamlesh | last post by:

Hi, How do I know the physical database path of a database. When I goto the DB2INSTANCE users's directory (/home/db2inst1), I see following folders: /db2inst1/NODE0000/SQL00001...

DB2 Database

5945

proble database

by: pintur | last post by:

The message is: SQL1036C Errore di I/O durante l' accesso al database. SQLSTATE=58030 what is the proble? what for restore tables? thanks

DB2 Database

1122

Emptying out an Image Variable

by: jcrouse | last post by:

How do you empty the contents of a variable the contains an image? Thank you, John

Visual Basic .NET

2923

PHP Dynamic Database Code

by: josh.kuo | last post by:

Sorry about the subject, I can't think of a better one. I recently wrote some PHP classes that I think might be of interest to this group. Since I have been reaping the benefits of reading news...

PHP

11171

Printing priority_queue without emptying it?

by: Eric Lilja | last post by:

Hello, I have a the following priority_queue: priority_queue<pair<int, string pq; AFAICT, priority_queues doesn't support iterators. My question: is there a way to print its contents without...

C / C++

4118

Database Business Layer and Database Sync Design

by: morleyc | last post by:

Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well....

C# / C Sharp

2582

Emptying index advisor cache

by: Quasar | last post by:

Hi Gents, I'm trying to tune our DBs using the Desing Advisor feature. I'm interested just in the indexes area. Following the IBM infocenter I came to this page:...

DB2 Database

7225

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7123

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7383

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7498

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5053

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4707

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3182

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1557

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

766

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP