I think the most part of the decline is due simply to the effects of the Tech Bust.  We all know there were tons of people in IT that shouldn't have been...

Female sterotyping?  I don't know.

I am the only woman in a 4 person DBA team here at my workplace.  The development team consists of an additional 7 men.  And yet,...

Stephanie,

No kidding!  I had a 6 week contract once for a company who only had developers on staff.  And my very first job was creating translog backups.  They had started...

The only time I usually shrink a database is when I've backed up a Prod DB (set to FULL recovery) and restored it down to a Dev box.  I shrink...

Steve,

Believe it or not, having IT experience period will do much to help you out.  My major problem was not having any professional (read "paid with appropriate job title") IT...

Did you follow the instructions in the Microsoft KB Article? 

If so, are you saying they are still having problems?  What sort of errors are they getting?

This article should help you out.  There are additional permissions on the Server OS that you have to grant in order for non-sysadmin users to launch SSIS.

 http://msdn2.microsoft.com/en-us/library/aa337083.aspx

For the most current stuff you need to bag the job, you should look carefully at the job description.  Depending on the company, DBA duties can be partitioned out (Production/Maintenance...

It might be a domain replication issue.

If the domain controller that is handling the account with the just-changed password hasn't replicated the password change to the domain controller that is...

NP.  Let us know if you need any more help.

Well said!  And thank you for the perspective.  I know I'm not going to get everything I want, but at least I can warn them.  Then, if they don't listen...

I think Microsoft stuck the XML stuff in SQL 2k5 because so many people were using it, not because they wanted to.  Yes, there's a lot of nifty stuff, but...

I almost forgot...

You should be able to use a Script task in an SSIS package to move the XML file over to your server from the website.

Am I reading your code right?  You actually had to join the document to itself to get it in SQL Server properly?

Steve,

You da Bomb! @=)

Darren, do a PatIndex search on the char(13) that Steve recommends and that will get you started.  I recommending creating your multiple columns in a Temp table...