Solved

any help in this case will be appreciated

Posted on 2008-10-22
2
322 Views
Last Modified: 2013-12-13
i am trying to delete everything that is there in the temp table and there are around 4724012 rows of data each time i run the page.
i know this much data will be coming each time but my major concern will arise as the no of rows will keep on increasing on daily basis but when i try and delete it in an SQL-Window query it executes perfectly but when i try the same with php code it shows an error message that query failed.

Any help in this case will be appreciated
$qdel = "delete from dbo.temp DBCC CHECKIDENT('dbo.temp', reseed, 0)";

$rdel = mssql_query($qdel);

Open in new window

src.txt
0
Comment
Question by:jhawarmayank
2 Comments
 
LVL 11

Expert Comment

by:bmatumbura
ID: 22783616
Try this:
$qdel = "delete from dbo.temp; DBCC CHECKIDENT('dbo.temp', reseed, 0)";

$rdel = mssql_query($qdel);

Open in new window

0
 
LVL 18

Accepted Solution

by:
jmoss111 earned 500 total points
ID: 22785068
Why don't you TRUNCATE the table?
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now