Script you provided is not complete...

Here is the method to pass something to textfile....

GO

IF OBJECT_ID ('DT_ARC_PASSTOFILE') IS NOT NULL DROP PROC DT_ARC_PASSTOFILE

GO

CREATE PROC DT_ARC_PASSTOFILE (@PASSTOFILE VARCHAR(4000) )

AS

SET @PASSTOFILE...

Wanted to know what options you tried...

run this line and see if space get freed or not if space is freed then use shrinkdb

BACKUP LOG mydatabasename

WITH TRUNCATE_ONLY

have you...

Have you verified execution plan?

put create table script for Product Level 5 Table and create view script for Product Level 5 View

This will help to diagnose...

Prakash

Chandu????

Is the problem solved? If yes what method works???

Prakash

Agree with kknudson..."Even in simple recovery everything is still logged"

Check your log file usage while this transaction is going...

Check sp_who and see waht is the waitresource coluymn saying

Check if...

Thanks to all for responses.

I have verified with microsoft that if I put tempdb on raid 0 and tempdb disk crash then sometime sql server will also not start as...

Server crash is an important one.... Ok I assume if it happens then we need someone to repair raid array immidiatly... well that's a problem, availability of that person is...

default for "autocommit" is on check if it is off for you.......

or may be some other batch had left an open transactions which is creating blocking

or

close all the query...

I dont know about log explorer but with your query you can restore old backup to another database and restore full tlog backup and now copy the tables accidently truncated...

Hi simonsabin,

Really stumped by what you talked about

selall bit On, if the object is used in a SELECT * statement.

resultobj bit On, if the object is being updated.

readobj...

you can use sp_refreshview to refresh the changed in underlying table daat structure

Cheers,

Prakash

Prakash

VB return an msgbox to raise error right and there uis no way a message box is shown at xp_cmdshell. but on that machine you will see that messagebox. You...

Try putting w2k sp3

or

set value of fixed memory size to 256 mb and then check

or

set value of fixed memory size to 256 mb and then uncheck Reserve physical...

Thanks..Antares686

If i do the reinstall of sql server than my existing databases will not get affected. right?

Prakash

I am handling a datawarehousing database of 600 GB of data at HDFC bank (India). Total size of the database is 1TB.

Prakash