what kind of error ?

its working in my side , please test before run it ; "PRINT @cmd"

for it USE [master]

GO

SET NOCOUNT ON

DECLARE @cmd varchar(4000)

BEGIN TRY

Create table #Orphan_User_Tbl

(

[Database_Name] sysname...

Sorry i just saw there is no option i ADD REMOVE programs.

refer below link .it might help you http://www.sqlservercentral.com/articles/Service+Packs/sp3/138/

Which server it is ? any details from error log ?

I pray that should not be production server, as far as i think we can roll back SP3 by...

Rob Schripsema (3/30/2010)

---

Great idea, Bhuvnesh, but that won't work when there are no Roman numerals at the end.

JOHN JONES will end up as John JONES.

But you could use your idea...

i replaced "| |" with | (single)

SELECT DISTINCT

A.[StaffNo],

A.[Name]

,REPLACE( STUFF(( SELECT ' | ' + StartDate +' | ' + EndDate +' | ' + CAST(Salary as VARCHAR (15))FROM...

Carolyn Richardson (3/30/2010)

---

You could play around with this to make it more readable but I think it does display the data in the format you want.

SELECT DISTINCT

A.[StaffNo],

A.[Name],

STUFF(( SELECT '...

ben-564110 (3/30/2010)

---

Ok an update: when I try with osql instead of SSMS it works. It seems SSMS overrides this setting unless you explicitly turn SET NOCOUNT ON in the query...

@lowell : you have shown great feature, thanks

i tried , its not working for me also

Sp3 would be fine , ignore my previous post

SP3 or SP2 ?

Click:A Normalization Primer[/url] and From MSDN

you are right, thanks for correcting me

But for this Default trace should be enabled Default trace - A Beginner's...