Friday, 24 March 2017
AUSQLUG Forums Home   Search   Login   Register   Member List  

  Viewing User Profile for: philcart
 About  Contact
Joined: 20 Jul 2004 04:09 PM
Last Login: 13 May 2013 01:56 PM
Location: Unavailable to anonymous users.
Occupation: Unavailable to anonymous users.
Interests: Unavailable to anonymous users.
Signature: Thanks

Colt 45 - the original point and click interface ;)
Email: Unavailable to anonymous users.
MSN IM: Unavailable to anonymous users.
AIM: Unavailable to anonymous users.
Yahoo IM: Unavailable to anonymous users.
ICQ: Unavailable to anonymous users.
 Post Statistics
philcart has contributed to 345 out of 1,864 total posts (18.51% of total).
Most Recent Posts:
Re: Debugging SP 11/03/2009 2:42:27 PM   (Total replies: 0)
Follow through this walkthrough provided on MSDN [url][/url]

Re: sort by finacial year 5/01/2009 7:33:08 AM   (Total replies: 1)
Firstly, I don't see why you need to do the "tricky" stuff to sort by the month. ORDER BY DATEPART(yy, [ReportMonth]), DATEPART(mm, [ReportMonth]) will sort by year and month. For your financial year sorting, I'd suggest setting up a calendar table. Do a quick Google on "sql calendar table" and you'll find a number of examples.

Re: Upgrade 2005 Standard to Enterprise 25/11/2008 7:55:09 AM   (Total replies: 0)
I'm betting that you're Enterprise install is RTM or SP1. You'll need to get hold of an SP2 install, or uninstall SP's from your Standard edition. Myself, I'd just go for the reinstall. As long as you capture all the logins, jobs, etc... it should be pretty painless.

Re: Local OS Administration Rights for DBA 17/11/2008 9:02:40 AM   (Total replies: 0)
Working in a consulting company with clients in many varied industries. We generally have local admin rights on server, and in some environments we have domain privileges as well. There is only one client were we don't have local admin rights. For that client, we generally have to work through a client contact who then passes the request through to network/admin people as appropriate.

Re: Log Shipping broken 10/07/2008 4:48:52 PM   (Total replies: 0)
Steve Are you using SQL Servers inbuilt log shipping? Looking at your requirements, a custom script solution might have more flexibility for you. We generally use a set of scripts and matching jobs for each part of the process 1) backup locally 2) transfer to standby 3) restore files On the restore side your script can determine if the next file in the folder is a database or log backup and perform the appropriate restore. For the upgrade process, disable log shipping backup ...

Re: Script to split 1 col to 2 17/04/2008 11:42:38 AM   (Total replies: 0)
Something like, create table #tbl (col1 varchar(10)) insert into #tbl select '12345A' union all select '1234' union all select '1356B' union all select '156789' union all select '145767A' select col1 , case when patindex('%[A-Z]%',col1) > 0 then left(col1, patindex('%[A-Z]%',col1)-1) else null end as col2 , case when patindex('%[A-Z]%',col1) > 0 then right(col1, len(col1)-(patindex('%[A-Z]%',col1)-1)) else null end as col3 from #tbl drop table #tbl

Re: Powerpoint Slides for Memory Management Tuning by Greg Linwood 28/03/2008 10:44:05 AM   (Total replies: 1)
They are available at, [url][/url]

Re: Exporting to PDF produces Invalid Argument Exception 20/03/2008 11:29:24 AM   (Total replies: 0)
vidival Firstly, I'm presuming you're talking about producing an 18 thousand page PDF file. Have you run this report and got an error, or are you just asking if it’s feasible? What is contained in the report that makes it so long? Are people honestly going to look at 18 thousand pages? Can the report be broken down into smaller chunks? Secondly, it's good etiquette to start your own forum thread and not post a reply to a thread that is nearly 12 months old.

Re: Exporting to PDF produces Invalid Argument Exception 16/07/2007 8:59:44 AM   (Total replies: 1)
Daniel Don't you just love the real helpful .Net exceptions :) Buried in all that, the second "ERROR" line says that there is a problem with chart1. Are you dynamically changing the chart in anyway, or have formulas for any of the settings?

Re: Exporting to PDF produces Invalid Argument Exception 16/07/2007 2:40:19 PM   (Total replies: 0)
In that case I'd check the resultset and see if there are any invalid dates.

Search for more...