what does this return?

SELECT

schema_name(6) As schemaName,

object_name(519060985) As Objectname,

'EXEC sp_changeobjectowner '''

+ QUOTENAME(schema_name(6))

+ '.'

+ QUOTENAME(object_name(519060985)) + ''''

AS PotentialCommand

is your code a stored procedure which runs quickly when static values are tested in SSMS, but slow when it is called with parameters from the application?

That's a sign of...

to get fixed length, you'll need to convert to CHAR datatypes, so they are padded with spaces.

something like this maybe?:

INSERT INTO Tran_file (id,RAW_data)

SELECT 2 as id,

'US1'+

CONVERT(CHAR(8), GETDATE(), 1)+

'1001'+

'1'+

'000'+

CAST(ORDACR# AS CHAR...

extended properties are stored in a database; so to make any sense i guess you'd store instance information in master, right? that's where i'd add them;

this worked on my master...

harsha.bhagat1 (3/1/2011)

---

Thank you for the reply,

But I think I am not being able to make clear what I actually want.

In simple terms I want to document the database into word...

yes, i understood that...

what i was telling you is compared to what i would call a "normal" process, you are doing it backwards...you put the data in the database, and...

In addition to what others have said...

db_owner is a role, so you could have lots of users as members of that role...and as previously stated, they can do anything to...

additionally, both Enterprise Manager and SSMS GUIS's have the built in ability to add an extended property for ease of use: just go to teh table and select "Design",...

actually, what a lot of people do is to put the data in the database itself by using extended properties...(sys.sp_addextendedproperty / fn_listextendedproperty)

you can put descriptions up to 255 chars in...

there was a recent thread on teh same subject:

http://www.sqlservercentral.com/Forums/Topic1056364-324-1.aspx

a lot of people reported they lean towards a "don't ask don't tell" policy, so if they don't ask for your expertise...

nope...something is specifically occurring...there's got to be something that is issuing the commands...

i made a simple csv with a bunch of the possible dateformats.

it looks like using convert with format 109 or 126 is probably best...it leaves the date and time alone...

i'm not sure what you mean by parent object...a trigger, for example, would have the parent_object_id in sys.objects, but i don't think a specific command would have any references to...

here's a quick example of a bunch of the formats available. sometimes you need to combine some of them togetehr to get exactly what you are after:

FormattedDate ...

ok i saw this image on derp.membase and had to switch avatars today. not my dog, but what a pic.