Hello,
I hope you can help me.
We have a SQL Server 2000 database at work, (which works with a VB6
frontend) which grew to a considerable size, so one of my past colleagues
sent me this truncate statement to use on the database.
I ran it like this, and all appeared to be well, it shrank the database,
Shortly afterwards, after I ran this I noticed something not quite right.
for example, one of the tables we keep is a User_Admin table which has 50
records in there, when I accessed this using the frontend it only showed 1
record, and this happened with every table in the database accessed by the
frontend.
The data in the tables is still there, but only shows one record through the
frontend.
Can anyone help me, and check this statement I ran, as its weird that all
this happened after I ran this statement.
Thanks,
Jayne Heger
sp_dboption PBTDEV,'trunc. log on chkpt.', true
checkpoint
--sp_dboption sadev,'trunc. log on chkpt.', false
sp_dboption PBTDEV,'autoshrink', true
--sp_dboption sadev,'autoshrink', false
DBCC SHRINKDATABASE (PBTDEV, NOTRUNCATE) 2 2350
Hi
It is unlikely that your error is caused by this, although you may want to
run DBCC CHECKDB on the database. If you know the statement that you are
running (or use profiler to get it) you may find that you have deleted some
data that it is dependent on to get the expected results.
John
"Little PussyCat" <SP******@NOSPAM.com> wrote in message
news:f9************@tiger.sphynx... Hello,
I hope you can help me. We have a SQL Server 2000 database at work, (which works with a VB6 frontend) which grew to a considerable size, so one of my past colleagues sent me this truncate statement to use on the database. I ran it like this, and all appeared to be well, it shrank the database, Shortly afterwards, after I ran this I noticed something not quite right. for example, one of the tables we keep is a User_Admin table which has 50 records in there, when I accessed this using the frontend it only showed 1 record, and this happened with every table in the database accessed by the frontend.
The data in the tables is still there, but only shows one record through the frontend. Can anyone help me, and check this statement I ran, as its weird that all this happened after I ran this statement.
Thanks,
Jayne Heger
sp_dboption PBTDEV,'trunc. log on chkpt.', true checkpoint --sp_dboption sadev,'trunc. log on chkpt.', false sp_dboption PBTDEV,'autoshrink', true --sp_dboption sadev,'autoshrink', false
DBCC SHRINKDATABASE (PBTDEV, NOTRUNCATE)
I agree, the error is probably coming from the application or the sp which the
application runs. Hi
It is unlikely that your error is caused by this, although you may want to run DBCC CHECKDB on the database. If you know the statement that you are running (or use profiler to get it) you may find that you have deleted some data that it is dependent on to get the expected results.
John
"Little PussyCat" <SP******@NOSPAM.com> wrote in message news:f9************@tiger.sphynx... Hello,
I hope you can help me. We have a SQL Server 2000 database at work, (which works with a VB6 frontend) which grew to a considerable size, so one of my past colleagues sent me this truncate statement to use on the database. I ran it like this, and all appeared to be well, it shrank the database, Shortly afterwards, after I ran this I noticed something not quite right. for example, one of the tables we keep is a User_Admin table which has 50 records in there, when I accessed this using the frontend it only showed 1 record, and this happened with every table in the database accessed by the frontend.
The data in the tables is still there, but only shows one record through the frontend. Can anyone help me, and check this statement I ran, as its weird that all this happened after I ran this statement.
Thanks,
Jayne Heger
sp_dboption PBTDEV,'trunc. log on chkpt.', true checkpoint --sp_dboption sadev,'trunc. log on chkpt.', false sp_dboption PBTDEV,'autoshrink', true --sp_dboption sadev,'autoshrink', false
DBCC SHRINKDATABASE (PBTDEV, NOTRUNCATE)
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: NOSPAM |
last post by:
Hello,
I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the...
|
by: LineVoltageHalogen |
last post by:
Greeting All, I have a stored proc that dynamically truncates all the
tables in my databases. I use a cursor and some dynamic sql for this:
......
create cursor
Loop through sysobjects and...
|
by: New MSSQL DBA |
last post by:
I have recently been assigned to take over several MSSQL environments
and found some of the existing practice confusing. As most of my
previous experiences are on Oracle and Unix platform so would...
|
by: ronin 47th |
last post by:
Hi group,
In one of the books 'Gurus Guide to Transact SQL' i found this info:
------------------------------------------------------------
TRUNCATE TABLE empties a table without logging row...
|
by: Sumanth |
last post by:
Are there any implementations of truncate in db2. Is it going to be
implemented in the future?
Is there an alternate way of doing a truncate of a table that has a high
record count without using...
| |
by: Stefan |
last post by:
Hi all,
two questions:
- is there a way to call the INSERT-Statement from Java (JDBC).
(import from file of del replace into table)
- in db2 there is no truncate-statement, is it?
Is in db2...
|
by: Sala |
last post by:
Hi
I want to truncate all data in database ... pls help me how i ll
truncate?
|
by: hedgracer |
last post by:
I would like to allow a particular user to truncate a log file in a
stored procedure that the user runs every day. At this moment the only
personnel that can truncate the log file are personnel...
|
by: ananthaisin |
last post by:
How to reduce the table size for any table while using truncate or delete statements. In oracle 8i it was truncating the storage space but in 10g it is not ....
I have given truncate statement in...
|
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,...
|
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...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |