Thanks for the reply...

So you want to say if my mdf file size is 1mb after rebuilt it has to becomes 1.5.

and my ldf if size is 0.5 mb so...

this is my test server which i m using in my local system.. I m using gmail for this... please help me on this.. I have 6 Instance running on...

Thank you for your reply.

My database mail was stooped working from 19th.

When I ran given code by you. I got below result. Please help me on this..

The mail could...

Yes ............ Database is in same server. Please help me on this

I am again getting error as

EXEC xp_cmdshell 'bcp "SELECT * FROM database.dbo.table1" queryout "C:\TextFile.txt" -t, -c -S SONY-VAIO\PROD -U sa -Password@12345 '

result -

'bcp' is not recognized as...

Yes i have tried and got result below

Msg 102 , Level , State 1 , Line 17

incorrect syntax near 'queryout'.

I ran below command

bcp"select * from t1" queryout "e:ew folder\textfile.txt"...

Thanks for the reply....

But how to run this from SSMS

SET NOCOUNT ON

DECLARE @procName VARCHAR(MAX)

DECLARE @getprocName CURSOR

SET @getprocName = CURSOR FOR

--Build our dynamic insert statements to populate the table: we want to get the top indentity value for certain tables...

Hi...

In my case i have four table t1,t2,t3, and t4 for all primary key is (ID)

I have changed the code again as you have given.

But code executed with...

Hi... I changed my code

i have four table t1,t2,t3 and t4 and in all table Primary key is ID.

When i changed the code and ran it again its giving...

/****** Object: StoredProcedure [dbo].[uspReplicationSyncMonitor] Script Date: 06/04/2015 11:37:40 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF OBJECT_ID('uspReplicationSyncMonitor') IS NOT NULL DROP PROCEDURE uspReplicationSyncMonitor;

go

CREATE PROCEDURE [dbo].[uspReplicationSyncMonitor]

AS

/* This proc will fire an alert to whoever...

I have changed my code dynamic SQL portion.

Database Mail profile = DB_MAIL

I have 4 table = [dbo].[t1],

...

---->>>>>> Please find my code which i am using <<<<<<<< -----------------

/****** Object: StoredProcedure [dbo].[uspReplicationSyncMonitor] Script Date: 06/04/2015 11:37:40 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF OBJECT_ID('uspReplicationSyncMonitor') IS NOT NULLDROP...

Hi Thanks for reply.

My result is - Command(s) completed successfully.

Yes i have changed link server name , My link server name is [FOR_PROD]

- I ran this code in...

Hi.. Thank you for your reply and your code.

I ran the code in below steps but i didn't get any result.

1. I change email address.

2. I ran the code from...