That's Enterprise Manager... look for ISQLW.EXE in the MSSQLServer directory.

Just pass it to a variable/parameter in the proc as you would any other string...

I agree... working for a jerk full time is a full time PITA.  Start looking for something better.

If I may make a suggestion and I'm not trying to be a...

Copy... paste... don't post a bazillion lines.

Heh... and people ask me why I use IDENTITY columns...

FP, think outside the box a bit... all the solutions that use an IDENTITY...

Curious... if you like the way it's done in .Net or C#, why didn't you do it that way?

Sam... I know little about MS Access... but couldn't you take one of the solutions Peter pointed and do a little conversion yourself?

This should do it...

 SELECT TableID   = sot.ID,
        TableName = sot.Name,
        IndexName = soi.Name,
        Type      = soi.XType --PK or F
   FROM dbo.SysObjects sot --Table Info
   LEFT OUTER JOIN
        dbo.SysObjects soi --Index...

Good to see you read the post the Tara wrote on the "other" forum, but she's not entirely correct.  [ > ] will erase a file if it exists and...

Since this is an SQL Server forum, what does it matter if it will work on any other RDBMS?  You believe in the myth of portable code?

I'm right with you on that one... the interview process should definitely be a two way street.   And, you did it very professionally,...

Heh... you spam a forum, insult one of it's members, and try to couch your bad form in some ill conceived rhetoric about free speech?  Truly, you are a professional...

Go Remi, GO!

You know me... can't resist a good test   I'm a bit surprised at the apparent slothfulness of the Replace method compared to the...

Heh... could save all of it if they were to format it in the GUI where it belongs

Wonder which would actually be faster? ...