can sombody help

Thanks it worked for the missing tables.

But when i ran it showed me the procedures which are depedent of other procedures. First shot i thought the "called" procedure are missing...

thank for the link. That what i wanted.

I am using bcp command for puting data (minimumn 15 million rows) in such case is it better to use

1) disable...

Hi

I am uisng following code. How do create a table for insert into when 2 resul sets are differnt? Please advice.

CREATE procedure PROC1 as

begin

Select 'aaa',1

select 1,2.22,'xxx'

end

go

DROP PROCEDURE PROC2

go

Create procedure PROC2...

thanks 🙂

i am repalcing the roll back with raise error. Using follwing code. And it gives me error as shown below the code.

I want the code not to return error but...

BEGIN TRY

CREATE TABLE #aaa

(

Id BIGINT IDENTITY(1,1) NOT NULL PRIMARY KEY ,

xyzmasterCode VARCHAR(15) NOT NULL )

INSERT INTO#aaa (xyzmasterCode,NumberOfRows)

SELECT DISTINCT xyzmasterCode, COUNT(*)

FROM xyz

WHERE xyzmasterCode BETWEEN '0'...

Result of EXEC sp_spaceused 'tablename'

Rows = 12309864

REserverd = 6976112 KB

Data = 5038728 KB

Index = 1795848 KB

Unused = 141536 KB

Result of DBCC SQLPERF ( LOGSPACE )

Log size...

using sp_spaceused

I get -

DB size - 10011.13 MB

Unallocated space - 288.22 MB

Data - 3779736 KB

Index - 5912608 KB

Unused - 140264 KB

Reserved - 9832608 KB

(Note: I am doing...

No am not manualy chaging. I have set log file size groth as 500MB and i am deleting almost 3 million rows. I has

i have just deleted 1.5 milion...

even if i am using simple recovery model it will log it and increase the .ldf file size?

the script given gives me the size of the log file and used space. I would line to know why delete operation should increase the log file?

After addind checkpoint also its increading the log file size

thanks. I will check the perfromace and the size of log after adding the checkpoint

How do u write it,

Begin tran

Commit tran

checkpoint

if i have 2 begin tran / commot tran then...

recovery model - simple