Duncan Pryde (3/9/2011)

No, TRUNCATE TABLE doesn't affect point-in-time restore, so you can restore to any...

Good question

i would like to ask, we can restore at 9:15 right?

But not after that?

Regards,

Sushant

OK ..

Now when i run hte code there is an error in hte line below:-

LEFT(LTRIM(RTRIM(IM.ITEMNMBR)), (CHARINDEX('-', LTRIM(RTRIM(IM.ITEMNMBR))) - 1)),

The error says :-

Incorrect syntax near '-'.

BUT when i run this code(t-sql)...

Gianluca Sartori (3/4/2011)

Sushant, if you look up sp_send_dbmail in BOL (Books Online, SQL Server's help) you will...

Also, i want the results in body , not in as an attachment.

Thanks.

Regards,

Sushant

When i put my code in the @query = '.......'

It says must declare the scalar varaiable @body1

Regards,

Sushant

I can't get 1 thing, how to put the value of the tsql code (result is a table) in hte content of the email...

Regards,

Sushant

ya its already created by my name...

Ok, i got it , wat abt other queries i asked.

Regards,

Sushant

This is wat from ur example:-

EXEC msdb.dbo.sp_send_dbmail

@profile_name='Default Mail Account',

@recipients='lowell@somedomain.com',

@subject = 'New Item Notification',

@body...

This is my code...

i am gettingg error "Incorrect syntax near @message..

create procedure dbo.rtw1

@receipent nvarchar(100),

@message nvarchar(30)

as

begin

INSERT INTO IV00104

(ITEMNMBR,

SEQNUMBR,

CMPTITNM,

CMPITUOM,

CMPITQTY,

CMPSERNM)

SELECT

IM.ITEMNMBR,...

I am using sql 2005 sp3..

Do u mean , tht i shld write a stored procedure or i can just do tht in t sql code.

Regards,

Sushant

Vernon Jimmerson-306463 (3/2/2011)

Log shipping is automated copy of transaction logs being applied to a database on the same or...

Isn't log shipping a clone of that instance of sql server.

Regards,

Sushant

Right clicking on server --> reports--> schema changes history

Why is it...

It is happening almost every minute

Regards,

Sushant