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...

Steve,

I appreciate the reply.  My main problem in checking load is that I don't currently have a DW side to check the load against.  I will, however, check the load against...

There is a TON of data in Books Online about XML under the heading "XML".  The very first thing I thought of when I saw your post was mapping the...

Absolutely.  The key is knowing what the carriage return character looks like (which I, unfortunately, don't).

You can do this one of two ways.  1) Use an SSIS package to pull the...

I think you should test this.  Create a job that does a few daily backups via the traditional SQL Server method, but backs up to the SAN drive.  Tack on...

YOu'd have to talk to the hardware guys to verify everything, but you absolutely CAN take one server and hook it up to a SAN after another server crashes.  The...

SQLBill?  Tek-Tips SQLBill?  If so, this is Catadmin.  Hi!  @=)

NB, SQLBill is correct.  You cannot backup SQL Server on a network share.  It has to be backed up to a...

We've never had any problems with doing traditional SQL backups on our SANs.  We just set our maintenance plans to delete backups after X number of days and Transaction logs...

Are you trying to enter your server name as opposed to creating a Mail connection object?  Or are you just needing the server name as the "FROM" part?

If the later,...