166 reputation
16
bio website stackoverflow.com
location Canada
age 24
visits member for 1 year, 6 months
seen yesterday

Aug
14
awarded  Popular Question
Aug
10
awarded  Popular Question
Aug
7
awarded  Popular Question
Jul
30
answered How can I restore ##MS_SSISServerCleanupJobLogin##?
Jul
30
asked How can I restore ##MS_SSISServerCleanupJobLogin##?
Jul
4
awarded  Popular Question
Jul
2
awarded  Curious
Jun
29
awarded  Popular Question
May
1
comment How can I change the data source of a linked report?
I've got it limited to a hidden parameter now which is working fine, except the user can change it when they subscribe. I'll have to see if that can be fixed...
Apr
30
comment How can I change the data source of a linked report?
The databases are on different instances, unfortunately. I'm trying to see if I can parameterize the connection somehow - I don't much like the idea of dynamic sql and a centralized database, although I'll resort to it if I have to. Thanks for your help!
Apr
29
asked How can I change the data source of a linked report?
Apr
16
accepted Why can't I access IIS Manager on my server with Reporting Services installed?
Apr
16
comment Why can't I access IIS Manager on my server with Reporting Services installed?
Good to know, thanks! Do you have an official source explaining this change by any chance?
Apr
16
asked Why can't I access IIS Manager on my server with Reporting Services installed?
Mar
31
accepted What could cause an auto increment primary key to skip numbers?
Mar
31
comment What could cause an auto increment primary key to skip numbers?
Like I said, I don't care about the gaps. I was just curious as to what might be causing them :)
Mar
31
comment What could cause an auto increment primary key to skip numbers?
Interesting, didn't know that. I can't think of too many situations wherein that would have happened here though; and definitely not in the order of a thousand times...
Mar
31
asked What could cause an auto increment primary key to skip numbers?
Mar
18
comment What SQL Server Edition to use
Is there any specific reason you have to use 2008? I'd use 2012 if you're starting from scratch.
Mar
13
comment How can I enable distributed transactions for a linked server?
What is the "right" service account? Should they be running under the same service account? There's also a sample query in my question.