Do you have quotes arround the 'Y' in the default, or two single ticks?

When I copied the text out to a query window, it came across as quotes...it really should...

The more I think about it, the more I was coming to that conclusion also. I'm just not sure what to do about it, or is it just a...

Interesting. That's a new one on me.

I've upgraded about half a dozen or so to SP2, and I don't recall changing the authentication mode even being an option in...

You mean the SQL server changed from SQL-ONLY Authentication to mixed authentication (or vice-versa)?

Never heard of that if that is the case. But it shouldn't be a big deal...

I agree. What's the point of partitioning into multiple drives? It won't buy you any performance or data recovery advantages...may even give you a performance hit.

If there are...

Can't you just set it up so the user it uses to connect to the production server only has read access? 

Thanks for the tips.

In looking at all sorts of resources, I get conflicting information all over the place (even within Microsoft).  One of the big things I see is different...

I sucessfully renamed all of mine by doing the dropserver / addserver.  I only did it yesterday, but they are high-use servers so I assume I would know by now...

The Report database is really what we need...but at this point not feesable in the near future (long story).

I've figured out how to pass a list of sources into the...

I'm probably going to have to do a lot of manual work, no matter what modeling application I use. 

I'm not sure why the decision was made to not use...

OK.  Got that working.  Apparently OPENDATASOURCE doesn't like UNC.  So I just added a section to my script that copies the file to the db server, and the OPENDATSOURCE works.

The...

Is the SQLJobLogs a share that the SQL Server Agent user has access to?  Have you tried \\myserver\d$\SQLJobLogs\mytext.txt ?

I think it could also be argued that the correct answer is A.  Developers shouldn't be making schema changes on a production database server.

That error message suggests that it's not an issue with any users being set for read-only permissions, but that the database itself is in read-only mode.  Did you check that?

(From...

I've done several .adp applications pointing at SQL2005.  The only problems I have hit is when trying to create/drop/modify objects.  If you are just doing selects/inserts/updates to data in existing...