Viewing 15 posts - 1,966 through 1,980 (of 2,462 total)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 4:31 am
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/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 12:56 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 12:49 am
Rob Schripsema (3/30/2010)
JOHN JONES will end up as John JONES.
But you could use your idea...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 11:45 pm
i replaced "| |" with | (single)
SELECT DISTINCT
A.[StaffNo],
A.[Name]
,REPLACE( STUFF(( SELECT ' | ' + StartDate +' | ' + EndDate +' | ' + CAST(Salary as VARCHAR (15))FROM...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 8:52 am
Carolyn Richardson (3/30/2010)
SELECT DISTINCT
A.[StaffNo],
A.[Name],
STUFF(( SELECT '...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 8:27 am
ben-564110 (3/30/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 7:42 am
@lowell : you have shown great feature, thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 6:27 am
i tried , its not working for me also
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 6:04 am
Sp3 would be fine , ignore my previous post
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 5:39 am
SP3 or SP2 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 5:37 am
Click:A Normalization Primer[/url] and From MSDN
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 5:30 am
Andrew Gothard-467944 (3/30/2010)
It's enabled by default
you are right, thanks for correcting me
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 5:14 am
Andrew Gothard-467944 (3/30/2010)
THe following gives a good guide to pulling the relevant info from the default tracehttp://blogs.msdn.com/cindygross/archive/2009/12/16/sql-server-s-default-trace.aspx
But for this Default trace should be enabled Default trace - A Beginner's...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 5:02 am
i needed to play with data.
Declare @tbl table ( main_text nvarchar(200), Without_Roman_values nvarchar(100),Roman_values nvarchar(50) )
insert into @tbl (main_text)
select 'BHUVH III'
union
SELECT 'DEXY V'
UNION
SELECT 'JACK TONY VIII'
update @tbl
set Without_Roman_values = reverse(substring(reverse(main_text),charindex('...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 30, 2010 at 4:59 am
Viewing 15 posts - 1,966 through 1,980 (of 2,462 total)