Lynn Pettis (4/18/2013)

---

mike.hamilton721 (4/18/2013)

---

Tried one more thing.. Not sure if I'm closer or farther away:

insert into #DBID (LogicalName,BindingID)

EXEC ('DBCC fileheader('+@dbid+')')

But that gives me "column name or number of supplied values...

Tried one more thing.. Not sure if I'm closer or farther away:

insert into #DBID (LogicalName,BindingID)

EXEC ('DBCC fileheader('+@dbid+')')

But that gives me "column name or number of supplied values does not match...

Ed Wagner (4/18/2013)

---

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

EXEC ('DBCC fileheader(' +...

Lynn Pettis (4/17/2013)

---

mike.hamilton721 (4/17/2013)

---

Thank you Lynn. I tried that new EXEC you listed (missing a ' ?), and I thought I added it in the right spot. But...

Thank you Lynn. I tried that new EXEC you listed (missing a ' ?), and I thought I added it in the right spot. But I'm not sure...

Alright. Played around (and Googled), and came up with this:

DBCC traceon (3604);

drop table #DBID

Create table #DBID (

Name nvarCHAR(256)NULL,

LogicalName nvarCHAR(256)NULL,

BindingID nvarCHAR(256)NULL)

declare @db varchar(256),

@dbid int,

@hidb int

select @hidb = MAX(dbid),

@dbid = 5

from...

Hmm, does that work with sp_msforeachdb? It's not liking what I'm putting in... Thank you for all the help!!!

Thanks! Is there a way to compile all of the msforeachdb dbCC fileheader results into 1 page with just those 2 columns (I can't figure out how to do...

I need to pull the logicalname and bindingid fields from fieldheader on multiple DBs, and place them in a text file. It looks like Windows Powershell might be able...

Thanks! Well I'm trying to combine all of my results from a exec sp_msforeachdb 'dbcc fileheader(?)' into 1 table so I can just select 2 of the columns instead...