Keith,

Sorry about that. I got us all confused. I am working with the table tmp_TrackRows_ana_ledger_all. When I try to select something from it, I get the error above indicating the...

You are both right. I need to make a habit of putting the owner in the query. So I did, and I still have the same issue. When I select...

Keith,

First, thanks for pointing me to the other scripts. I will definitely start using them instead.

As to your query, it shows that the table exists. However, when I do this:

select...

My apologies for not mentioning that this is an SQL authentication account, not a Windows account.

I have all of the server roles unchecked. All tables have public checked and it won't let me uncheck them. I can't seem to find a property that is enabled...

Thanks, everyone. I appreciate your input. Looks like Lucida Sans is the winner for me!

I agree with you. The code they use in most cases is definitely like using a sledge hammer to insert a thumb tack.

Sean, I like your suggestion for my situation. I like the other one, but the original AuditTable is part of a proprietary ERP system, and if I try to make...

Jason,

Thank you very much! It worked perfectly! I will keep this handy for future reference.

Steve

Sure. Sorry, I should have already posted this.

CREATE TABLE FragList

(

ObjectName NVARCHAR (255),

ObjectId INT,

IndexName NVARCHAR (255),

IndexId INT,

Lvl INT,

CountPages INT,

CountRows INT,

MinRecSize INT,

MaxRecSize INT,

AvgRecSize INT,

ForRecCount INT,

Extents INT,

ExtentSwitches INT,

AvgFreeBytes INT,

AvgPageDensity INT,

ScanDensity DECIMAL,

BestCount INT,

ActualCount INT,

LogicalFrag...

Sorry, I don't do much database design. How would I add a constraint such as the one you are talking about?

Sorry, I didn't get back to you sooner.

Thanks for the help. I have figured out to use this code to insert the data into a table:

INSERT INTO FragList EXEC...

Thank you very much. 🙂

Ahh. I forgot all about that. Thank you very much.

Thank you all for your help. I was able to get what I needed from your answers.

Steve