RENAME is the oracle command to do what you are asking.

in sql server, a stopred procedure is used:

EXEC sp_rename 'admin','administration'

or

EXEC sp_rename 'dbo.admin','administration'

note the first parameter can accept just the tablename,...

well, your proc's constructions not going to work, but i realize that was a prototype.

you cannot have a GO command in the body of a procedure; to do what you...

one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not know of any way to script out the...

SQL Recon is a free utility that will help you find all installations on a network; other than that, it's reading the registry in multiple places on multiple machines, maybe...

can you add the # hours difference when calculating the server's getdate to the utc date?

for example, this returns 5 form my EST server...it might vary depending on daylight savings:

'

--'returns...

we'd be able to help better if you showed us the body of the stored proc; but in general, if you get an error that is level 16 or above,...

the client tools(SSMS) to query the database are really separate from the cluster itself; it's no different than having Winzip on one server and not the other; it's not...

definitely parameter sniffing first; it is very doubtful your network is bogging down just for one app, unless it is returning a MillionBillion rows. this is one of the first...

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