161 reputation
10
bio website stackoverflow.com
location Canada
age 24
visits member for 1 year, 2 months
seen Apr 16 at 15:04

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.
Mar
13
revised How can I enable distributed transactions for a linked server?
added 371 characters in body
Mar
13
revised How can I enable distributed transactions for a linked server?
added 936 characters in body
Mar
13
asked How can I enable distributed transactions for a linked server?
Mar
1
awarded  Benefactor
Mar
1
accepted Tempdb data file disappearing
Feb
26
comment Tempdb data file disappearing
Thanks for posting! I'll reboot the server this weekend, and if everything continues to be fine I'll mark as answer/award the bounty.
Feb
25
comment Tempdb data file disappearing
@JonSeigel Okay, that seems to have worked. I guess I'll have to reboot the server to really see if things stick, but those orphaned files are gone now at least.
Feb
25
comment Tempdb data file disappearing
@JonSeigel It didn't have any of that (I added it). Assuming that works (the tempdb data file hasn't disappeared yet); how do I go about cleaning up those orphaned file records?
Feb
24
comment Tempdb data file disappearing
@JonSeigel I've reproduced this behaviour: Creating a new database does not give the service accounts any permission on the MDF/LDF files. Not sure if this is expected behaviour, or problematic?
Feb
24
comment Tempdb data file disappearing
@JonSeigel While I was working on this, I had an idea - I looked at the permissions on the tempdb .ndf file that it seemed not to know about, and sure enough the managed service account had no permissions to it. I added the permissions manually and sp_helpfile shows that file now (but I haven't been able to restart the server). Does this help?
Feb
24
comment Tempdb data file disappearing
@JonSeigel This is a production server, so it's going to be difficult to duplicate the "restart the server" part. I've tried creating a new database and detaching/attaching, but it seems to be working fine.