Thanks Lynn Pettis. I think it's working....

Months before I posted this thread and Vivek posted this url for to understand the permission on SQL job:

http://msdn.microsoft.com/en-us/library/ms188283.aspx

URL was informative.

I didn't get chance to work...

Thank you very much Vivek. Link is really helpful.

Maksuda...

Hi,

I am just wondering if anyone can help me regaring my this posting.

Thanking,

Maksuda...

yes ,I should provide scripts for the tables. Here is my script

CREATE TABLE [dbo].[C](

[C_ID] [int] NOT NULL,

[C_Name] [varchar](50) NULL,

CONSTRAINT [PK_C] PRIMARY KEY CLUSTERED

(

[C_ID] ASC

)WITH (PAD_INDEX = OFF,...

Thanks SS for the reply. Actually I need it for creating some kind of report. I tired using dataset but

the alignment was bad for two seperate datasets. I don't...

Thanks for the reply.

SQL:BatchCompleted and SQL:BatchStarting are not for tracing delete event right? In that case server performance may go down and also it'll be very tough to find the...

Thank BitBucket. I read SQL 2005 online books about Profiler, but which event is for tracing delete event is not cleare to me.

Can you help for finding this.

Thanking You,

Maksuda...

Thanks Drew for the reply.

I tried and it giving me Cartesian Product.

Thanking you,

Maksuda

Thanks John. You are right. I should provide enough information to get the quick response.

Here is my table:Qtr_Event_TotalInfo(T1)

CREATE TABLE [dbo].[Qtr_TotalInfo](

Qtr_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

Event_Qtr varchar(7) ,

Event_Total int NULL

)...

Drew I tried your code. It's fine and working ok. Just need to make a small change.

In place of insert statement

INSERT INTO TagTemp (TagNameID,TagName,SeverityID)

SELECT @TagNameIDBase + Row_Number() Over( ORDER...

Thanks a lot Steve.

Maksuda...

Thanks Jeffrey.

You are right. I need to find it out what's going on my model db.

For now I follow the instructions and I recover my server space.

Do you thing...

Thanks guys. Jeffrey, here is the result of the query-

Select name

,d.recovery_model_desc

,d.log_reuse_wait_desc

From sys.databases d

Where...

Thanks Jason.

Very begining I didn't look at the model db log file (It's my fault). When I ran out of space I looked at all files and then found model...