Is the folder for the backup a Mount Point? If so, you will only get the space available for the mount point, not the C: drive. I think Disk Manager...

Have you looked at the System and Application Event logs for any further error messsages?

I was a developer (and de-facto DBA) for many years before becoming a full-time DBA. I still work...

We should all quit complaining about this one, and chalk it up to a learning experience (read the question and check it out if it looks too obvious, like this...

Another point - the question specifies TINYINT, none of the queries return TINYINT. (1) is INT, (2) is DECIMAL, (3) is INT. Not only are the queries inaccurate, but none...

We get Blackberries for on call personnel. As the Team Lead, its indispensible for keeping track of whats going on, and it sits on my night stand at night. If...

Most of us missed an important clue - todays editorial is "Stupid Interviewer Tricks" ... :w00t:

But a good learning experience anyway.

I came up with a similar solution. Except I have a proc that creates Linked Servers using a single name (LS_Q), before executing the queries, this makes the subsequent coding...

I used the MS study guide (ISBN 0-7356-2271-X), it was easy to read and covered pretty much everything. The book includes a self-test for the exam, a 120-day trial copy...

Final update for this thread - I called in a ticket to MS, who provided some assistance until the tech noticed we are still on SP3 (there could be a...

Todd and I both have full rights on the site - Browser, Content Manager, My Reports, Publisher, Report Builder; am I missing something here?

Patrick,

(I'm the DBA working with Todd - I suggested he sign up and pose the question on here). There is no "Site Settings" visible anywhere on our SSRS pages. My...

Well, there's 5 minutes of my life I'll never get back! This question has nothing to do with how much you know about T-SQL, just do you pay attention when...

Good information, thanks.

I agree with Ken, when interviewing candidates, its important to gauge their level of knowledge of the product and you can't do that without asking in-depth questions.

Just a quick update ... the Failover / Reboot / Failover didnt reolve anything, but did add more information.

I can connect to the instance with Windows Auth when its on...