Viewing 15 posts - 48,751 through 48,765 (of 59,065 total)
Aw crap! They've scheduled a job for every blood Log Reader Agent!!! I'm going to need to disable those buggers, too, huh?
August 14, 2008 at 2:08 pm
GilaMonster (8/14/2008)
Jeff Moden (8/14/2008)
August 14, 2008 at 2:04 pm
Oh dear... I think I've found what you're talking about... it's in EM under {Replication Monitor}{Agents}{Log Reader Agents}... they've really really overdone it... there are 70 of the blighters... :blink:
August 14, 2008 at 1:49 pm
rbarryyoung (8/14/2008)
August 14, 2008 at 1:43 pm
Matt Klein (7/30/2008)
August 14, 2008 at 1:31 pm
Hehe. I always seem to pop by just when there's a throwdown about to go down....
All right all right. If you're going to challenge to a dual, you...
August 13, 2008 at 11:41 pm
What do you get for the following value?
'XA1 1AA'
August 13, 2008 at 10:52 pm
Since Day "0" was a Monday, I believe you'll find that the code I made also compensates for Monday. 🙂
August 13, 2008 at 9:57 pm
andrew gothard (8/13/2008)
But, there's even a way around that (and many similar problems not listed) without an explicit cursor or While loop OR UDF using a single set-based update...
August 13, 2008 at 9:39 pm
David Jackson (8/13/2008)
many, many thanks. I owe you a beer. 😀
declare @TestTab Table (add1 varchar(50) null, postcode varchar(50) null)
Insert @TestTab values('Glossop', 'SK13 8LY') --Valid
Insert @TestTab values('M1 1AA',NULL) --Valid but wrong...
August 13, 2008 at 9:04 pm
I need to see a couple of lines of what you expect the output to be and the CREATE statement for the source table.
August 13, 2008 at 6:01 pm
senthilkumar.v (8/13/2008)
select convert(char(4),datename(yyyy,'01/01/2008'))+convert(char(2),datepart (wk,'01/01/2008'))
Perfect... :hehe: Now, try that against Jenny's original request below... 😉
DECLARE @Serial CHAR(12)
SET @Serial = 'SER074400001'
August 13, 2008 at 5:55 pm
Sara_DBA (8/13/2008)
SELECT CONVERT(VARCHAR,GetDate(),112) 😛
Heh...ok, Sara... if you read Jenny's original request, tell me how your code converts the following, posted in that original request, to a date. 😛
DECLARE @Serial...
August 13, 2008 at 5:53 pm
Heh... did they also happen to have all the data in a single EAV table? 😛
August 13, 2008 at 5:49 pm
Heather (8/9/2008)
This makes sense for a reporting purposes, but why would someone do this for two operational databases?
Physical security, performance enhanced by having two boxes instead of just 1, different...
August 12, 2008 at 10:20 pm
Viewing 15 posts - 48,751 through 48,765 (of 59,065 total)