Eric, that's exactly right. It's one of the different skills...And actually it's made up of a lot of 'sub-skills' as well, like empathy, understanding, mediation, etc. (at least in a good...

I've had good experiences with clustering as well. My earlier post detailed some of the possible prolems. I managed several clusters directly (and I was an escalation point for many more...

By the way, Remi, I'm always impressed with the t-sql you (and several other people like Frank Kelis) crank out around here. That's the area I am trying to improve...

I'm never one to turn down a book, but the DTS books I've read haven't been that great. I learned more through trial and error and sites like this one and...

In my past experience, a lot of the difference has been that management got 'at risk' pay (bonuses, incentives based on performance, etc.). I mean things like explicit ammounts of...

You can also go into Current Activity (under Management) in Enterprise Manager and find the connection(s) that say something like DTS Designer in the Application column. If you double click...

You can also turn on package logging - it will give you a much better idea of what is failing and why. To do so, Open your DTS Package, go...

It sounds like Data Transformation Services would be a far greater solution than BCP for you. Check DTS out in BOL.

There is a trace flag listed in the first linked article that you have to enable before a network drive/share will show up in the GUI when you go to...

I just passed 70-229, and it is the same way (but probably not as bad). There are a lot of questions with Exhibits. I only read two of them, and...

Sorry, i can't direct you to an article, but I can give you a quick overview.

     SQL Server Clustering (and MSCS in general) can be very complicated and you...

One side note. What i described above is for SQL Server 2000. From what I understand, you cannot accomplish this in SQL Server 7. From another forum (I googled it):

"    ...

I think you can accomplish this through the ALTER DATABASE MODIFY FILE command. I DEFINITELY would not modify the system tables to accomplish this. From Books Online (under Alter Database):

MODIFY...

Please talk to your network administration people before creating a domain! Are you absolutely sure you don't already have a windows domain? When you log on to the network, You...

Can you avoid the OPENQUERY and just do four part naming (servername.databasename.databaseowner.tablename) ? I know it isn't as good performance wise, but if you can get to the data that...