Viewing 15 posts - 271 through 285 (of 541 total)
Thanks guys, I also got the call on the drive home after a night out 🙂
We recently had a developer write code for a complex report (took a few days...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 7, 2009 at 11:37 pm
Thanks Jack I will give that a try.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 5, 2009 at 2:07 pm
Thanks that worked a treat.
Kind Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 5, 2009 at 11:59 am
I was advised by a developer to use:
Public Function getHeaderText(ByVal purchaseOrderId As String) As String
Select Case Left(purchaseOrderId, 3)
...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 18, 2009 at 5:21 am
Can anyone with me a lesson in adding custom code for such a scenario?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 18, 2009 at 3:50 am
Thanks Niraj. When executed returns error:
[rsMultiReportItemsInPageSectionExpression] The Value expression for the textbox ‘textbox37’ refers to more than one report item. An expression in a page header or footer can...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 18, 2009 at 3:42 am
I worked out what the issue was. When I scheduled the task it created a job. I was unaware of this and was reviewing sql jobs. I noted 2 jobs...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 11, 2009 at 8:20 am
Steps taken:
--From Principal
ALTER DATABASE DBName SET PARTNER OFF
--Set Recovery Mode for Principal
ALTER DATABASE DBName SET RECOVERY FULL
--Backup the Principal Database + Transaction Log copy over to Mirror Server C:\Mirror
--Then...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 11, 2009 at 7:22 am
OK all is now happy and well.
I ran ALTER DATABASE DBName SET PARTNER OFF on the mirror.
I then ran SET PARTNER
I will do it all again so all is...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 11, 2009 at 7:05 am
Hi. I dropped the mirror database. I then restored the database + log using NORECOVERY.
Now when I try to configure mirroring I receive:
Neither the partner nor the witness server instance...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 11, 2009 at 6:50 am
I seem unable to do anything with the database on the mirror. Can I stop restoring?
Need to get this resolved ASAP......little beads of sweat appearing which is never good!
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 11, 2009 at 5:42 am
Thanks I will take a look.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 11, 2009 at 4:45 am
I created a stored proc with the intention of allowing a user to run a report passing the stored proc the ReportId.
What I hoped was to be able to do...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 10, 2009 at 8:56 am
Perfect, I played about with DATEDIFF.......
Many Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 10, 2009 at 8:31 am
Tried:
SELECT ReportSchedule.ReportID, CONVERT(CHAR(5),ExecutionLog.TimeStart,114) AS 'TimeStart', CONVERT(CHAR(5),ExecutionLog.TimeEnd,114) AS 'TimeEnd',
CONVERT(CHAR(5),TimeStart - TimeEnd,114) AS TimeTaken
FROM ReportSchedule INNER JOIN
...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 10, 2009 at 8:09 am
Viewing 15 posts - 271 through 285 (of 541 total)