Viewing 15 posts - 331 through 345 (of 616 total)
Thank Tony. I've re-read the info on the BACKUP DATABASE command and I see what you mean.
Lucky I've not had any files get corrupted YET!
February 15, 2013 at 8:07 am
TravisDBA (2/15/2013)
Abu Dina (2/15/2013)
TravisDBA (2/15/2013)
That is so rare today, with so many people disrespecting and bad-mouthing our country today, and only out for themselves here. Well, anyway he got hired.
Overdosing...
February 15, 2013 at 7:48 am
TravisDBA (2/15/2013)
That is so rare today, with so many people disrespecting and bad-mouthing our country today, and only out for themselves here. Well, anyway he got hired.
Overdosing on patriotism can...
February 15, 2013 at 7:36 am
I've replied to your other post:
http://www.sqlservercentral.com/Forums/Topic1420526-391-1.aspx
February 15, 2013 at 7:22 am
This will work:
DATEDIFF(day, CASE
WHEN appointment.effdate <= @enddate-27 and APPOINTMENT.Expdate between @enddate-27 and @enddate-21 THEN DATEADD(day,-27,@enddate)
when APPOINTMENT.EffDate < @enddate -27 and APPOINTMENT.Expdate> @enddate-21 then DATEADD(day,-27,@enddate)
when APPOINTMENT.EffDate between @ENDdate-27...
February 15, 2013 at 7:21 am
I don't know why I felt the need to over-engineer my problem.
LOL.... I do it all the time that I keep having to remind myself with regular mental notes 😛
February 14, 2013 at 9:56 am
Maybe this?
SELECT ordertotal
FROM #MoneyTest
where ordertotal - round(ordertotal, 2) > 0
February 14, 2013 at 9:29 am
Run this:
SELECT *
FROM Dimdate
WHERE ISDATE(datedesc) = 0
If this comes back with anything then you'll know which ones SQL can't convert to datetime.
February 14, 2013 at 9:19 am
Not sure that's the issue as the OP said that he could connect to the instance from another server which would indicate that allow remote connections is enabled.
I'm guessing this...
February 14, 2013 at 8:19 am
tut tut tut.... don't cross-post Kevin! 😉
http://www.sqlservercentral.com/Forums/Topic1419967-8-1.aspx
February 14, 2013 at 4:29 am
mr.neil.bryan (2/14/2013)
Any tips on making this career change?Has anyone done this?
Many thanks,
Yup, I made this decision in July last year however, as hard as I tired I couldn't secure a...
February 14, 2013 at 4:18 am
Could be firewall issue?
February 14, 2013 at 4:10 am
How about using the Execute Process Task to trigger the exe to unzip the file?
February 12, 2013 at 7:28 am
Viewing 15 posts - 331 through 345 (of 616 total)