Mark,

Thanks for the tip. I usually use a vbscript with the filesystem object to handle these types of tasks. I never knew of the ForFiles command-line utility. ...

I upgraded four clustered server instances and found it fairly straight forward, but that's just my experience. I'd be interested in hearing about your Gotchas. Everyone has different...

First of all Serena's question was how to do it, not why. All answers making a judgment on why and suggesting something else are irrelevant. That being said...

BIDS is VS2008. CRM & MOSS2007 have the updated .NET framework.

I found the answer. It is so simple. Nothing special to do, just tell SQL to produce the schema for us. Here’s the code and results:

Brandon Forest...

RBarry,

I'm sorry that I didn't communicate my thoughts effectively. I'm transporting data across domain boundries with Service Broker, which uses XML messages (2GB max) as it's payload. I...

Steve,

Can you post a good procedure for slipstreaming SQL 2008 SP1?

Thanks!

Brandon_Forest@sbcglobal.net

Steve,

I am constantly asked to service SQL Servers that others have built. I built the following stored procedure bases on your articles on build versions that I use...

The subscriber was throwing an error because it was trying to synchronize with the publisher, but couldn't find the next replicationID. Another developer on our team came up with...

That depends on how you have it set up. I once had a single table that was over 100GB in size. It was split up in multiple file...

Yes Steve, Life is not fair when it comes to data farming. I do try to limit my data shadow, but I prefer to use the term data wake...

We can all jump through flaming hoops to accomplish our ETL. However, there are limits on what we can or should accept as input. If the data format can't...

There are times when it is necessary to use xp_cmdshell, but this isn't one of them. As stated in a post above the real issue is securing credentials in...

Sorry Steve, but when some people have hundreds of SQL 2000 DTS packages, I see SSIS as a driving need to upgrade. I did.

You can run legacy...

I agree that this is not a ragged file problem, but an exercise in stripping the first and last rows. A conditional split would be the approach I would...