Is there a system table or view that relates the ObjectType ID from the defualt trace to meaningful names?

We only get out numbers from this field. How are we supposed...

I am going to guess by the lack of any response that no one knows if there is a system table that contains this information.

Surprising. 🙁

Ah very smart! I didn't think of joining the table to itself!

Works a treat. Thank you very much!

No one? Anyone know if there is a system table or view that contains that information? Surley somone must have an idea!

I think what he is refering to is using a substring command to only return the 1st 30 characters of vwImportAllNewClientIDs.Client...

--

INSERT INTO dbo.tblClients

(Client_Short_Name,

Client_Long_Name,

CountryCode,

ClientID)

SELECT substring(dbo.vwImportAllNewClientIDs.Client,1,30),dbo.vwImportAllNewClientIDs.Client, dbo.vwImportAllNewClientIDs.CountryCode, dbo.vwImportAllNewClientIDs.ClientID

FROM dbo.vwImportAllNewClientIDs

--

I had a question about right-ragged file formats in a previous post.

I ended up having to use a script because of the llimitations of the conditional split.

(see post

Really? How do you alter them? I always thought that you cannot alter or modify system schemas?

Get the error:

Cannot alter the Schema 'DBO'

I recall reading from MSDN that sys, dbo and information_Schema cannot be altered.

any other suggestions?!!

Ok, I thought since no one seems to know about what to do with these file imports I thought I should post my findings.

There were a couple of options that...

Well thanks a lot for all your responses!

I thought that this would have been quite straight forward.. (and it is, as you can see)

The way to do this is:

DATALENGTH

Thanks, I dont know if you actually read the contecnts of that post you pointed to. or just the title, but it dosnt actually tell me whether its possible to export...