I second vilyana's point. To my knowledge, we will not loose data when w we are increasing varchar size.

Hi,

You can monitor the below

1.replicaton monitor (in sql server management studio) available to see if the replication is going on successfully or not

2.check the replication jobs and history of...

Thank you Jeff 🙂

Hi,

As per my Knowledge, If your using transactional publication and push subscription, records

will travel from publisher to subscriber. whenever the new snapshot is generated, subscriber will be in sync...

jeff,

I tried the below solution, will it effect the peformance ?

select

employee.employee_id ,date_joined ,aa.date_ , ROUND((sal+due_amount),2)

from employee

inner join (select employee_id,MAX(date_) 'date_' from employee group by date_joined,employee_id)aa

on aa.date_=employee.date_ and...

Hi,

Try the below solution

SELECT row_number() over(order by linknumber) 'RowNumber',

linknumber,

Split.a.value('.', 'VARCHAR(100)') AS Item

FROM (SELECT linknumber,

CAST ('<M>' +...

in our environment also , we faced the same issue. The solution we found is, we have split the files into multiple files and executed those in the same order....

2012-07-29 04:22:37 - ! [382] Logon to server 'MLIVSDSDSSDBD\DSS' failed (ConnAttemptCachableOp)

2012-07-29 04:22:37 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]

2012-07-29 04:22:37 - ! [382]...

You Can try the below query.........

select * from test a inner join test1 b

on a.id=b.module_id

where a.id=@id

and a.name=@name

and (CONVERT(CHAR(8), a.start_dt, 112) <= case when @age>12 then dbo.fCM_Get_UTC_Date_Str(GetDate(), GetUTCDate())

when @age<12 then dbo.fCM_Get_UTC_Date_Str_Latest(GetDate(),...

IF EXISTS(SELECT 1 FROM prices P WHERE P.Avg = T.Avg AND P.Colour = T.Colour)

BEGIN

UPDATE P

SET Stock = T.Stock

FROM prices P INNER JOIN #prices T ON P.Avg = T.Avg AND...

Hey....

I got the solution...

I have reused sp_helptext and renamed it and modified

the length of the column width

I think it is working fine now.

Thanks for the help

Yes I did but it is not able to handle " /* " which makes the script into green lines (takes a comment) and it is making the entire...

The problem is if the sp has any comments with "--"

it is commenting the entire sp, thats why I need an exact output like

the way we generate script using...

sorry for the typo error, please find the corrected one below

Hi,

I did not find any entry with my db name in sysprocess or sp_who2 or sp_who4

any help

Thanks

Hi,

I did find any entry with my db name in sysprocess or sp_who2 or sp_who4

any help

Thanks