Hi,

Thanks for the reply. DTS is actually what forced me to try BCP. The DTS job was taking over 11 hours to complete. That's unacceptable for me....

When possible, avoid querying systables.  The structure isn't guaranteed to stay the same in the future versions of SQL Server.

Utilize INFORMATION_SCHEMA views when possible.  It doesn't always give you as...

Hi Rudy,

In most cases, I would be happy to hear that.  Exisiting documentation in-house is the best.  However, I am a contractor who is subcontracted to a contractor who was...

Thanks, everyone.  I appreciate the advice. 

-Chris

It's available now.   It wasn't this morning.

I'm still open to other suggestions, however.  No book is the perfect book, but I'd still like...

Awesome.  There are apparently a lot of people who have had similar problems.  However, I've rarely seen two people with the same problem. 

-Chris

For me, this was actually the resolution.  It's been pretty amazing.  I have no clue how the problem came to be, but this seemed to solve it entirely.

Look at the...

Hi Yelena,

I removed dbo immediately.  It's a dev box, so it's not crucial, but I'm with you on the guest access to master.

Now, here's the kicker.  I think I fixed the...

Interesting twist here...if I hit refresh and wait for like 2-3 minutes, the databases list out fine.

Still not ideal, but better.  Any ideas?

-Chris

Okay,I have done a couple of things to see if they would help in accordance with the suggestions here.  First, I made the guest account dbo in the master.  Just...

Wow, lots of great ideas.  I'm just now getting a chance to work on these today, but I did dig up a few interesting tidbits just now.

As is usually the case,...

Hi Yelena,

Please don't get me wrong.  I think you are dead-on 100% right.  I tried all of your suggestions.  I just haven't found the solution yet.  It's got to be...

Hi Yelena,

I think I need to look in a different direction.  I checked the error log, and I have tons of Error 17052 / SQLDumpExceptionHandler: Process generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. ...

Hi Yelena,

Thanks for the reply.  Unfortunately, no dice.  I have a production server that is behaving well.  I compared the permissions given to Guest on both, and they're identical.

Additionally, I was...

Hi Yelena,

I should probably qualify that I am a SQL Server DBA.  Not that it makes a difference.  The questions are quite fair.  I am positive, though, that I am...