First create a temp table to receive the data from your DBCC command. I used #table_name below.

Then fire something similar to the following to populate it.

EXECUTE sp_msforeachdb N'USE ?;

INSERT...

chris.mcgowan (4/18/2013)

---

That will certainly impact recovery time, Below is a script that will create a script to update the initial log file size and the auto growth settings based on...

I think that's a good policy...don't ever publish real data. There are privacy, PII, HIPPA, etc. concerns that should never be overlooked unless you want a sudden change in...

For #1 and #3, try Jeff Moden's string splitter. http://www.sqlservercentral.com/articles/Tally+Table/72993/

For #2, Sean Lange posted this great approach earlier today for a similar request:

with EconSearch(SomeValue) as

(

select 'D.01.01.01' union all

select 'D.01.01.02'...

Thanks for the feedback. Glad it helped.

Here's an example of a couple columns in a GridView that include HTML. There's one with a

tag that links an <img> tag and a column with a...

Trying to put the presentation in the application instead of in SQL is the best approach. You're never going to get everything all nicely lined up in .NET GridView...

I agree with Grant - you should see the SELECT with the function take longer, since it has to run over all the rows. I wonder if ClientNr is...

That's quite a block of code. I thought of the database objects, but searching every column got my head spinning with how long it would take. I don't...

I think that the error 112 is when you run out of disk space. Are the databases that failed too large to fit on your K: drive? I...

I must admit that the largest file I've done is a 261 MB text file what was delimited AND fixed-width. Yes...delimited and fixed-width in the same file. :w00t:

The way...

Stuart is right. To an...

I'd like to echo Lowell's preference for NULLs in foreign keys instead of a zero. Of course, this means that you're going to have to outer join the tables...

Well done. When I receive data from external sources, I find it to be less than spectacular quality. Fields that are supposed to contain dates contain strings, numeric...

Have you tried importing into an "inbox" or "incoming data" table that the Import Wizard creates itself? I just did this recently to get data into a table and...