Internal error: The operation terminated unsuccessfully.

OLE DB error: OLE DB or ODBC error: Snapshot isolation transaction failed in database 'Tfs_Warehouse' because the object accessed by the statement has been modified...

Pls explain your query?

Thanks for your prompt reply.

I know its better atleast But i want if it solved through Query.

Great:

Thanks

After a little ammendment this look like:<Working fine with me>

SELECT

schema_name(schema_id) As SchemaName,

name as ObjectName,

...

Can you put a Date check on this?

SELECT

schema_name(schema_id) As SchemaName,

name as ObjectName,

create_date

FROM sys.objects

WHERE type_desc IN(

'AGGREGATE_FUNCTION',

'SQL_SCALAR_FUNCTION',

'SQL_INLINE_TABLE_VALUED_FUNCTION',

'SQL_TABLE_VALUED_FUNCTION',

'SQL_STORED_PROCEDURE','VIEW')

ORDER BY create_date DESC

Thanks for your Acknowlegement.

Whats Final <Script>

Thanks Boy:)

I have tested this and found this area un-useful for me.Because i need only Machine Name as per my goal.

create trigger backup_objects

on database

for create_procedure, alter_procedure, drop_procedure,

create_table, alter_table, drop_table,

create_function, alter_function,...

Is it possible that DB Prompts me when the new SP executed successfully and Its timestamp get changed.

The most likely reason for Multi-Script to skip a server is because it can't connect to that server

not server... A DB on Same server.

MultiScript Version is 1.1.0.34

I have integrated SQL 2008 at BE.

Means>> When i Copy Paste text from My SP file to MScript of RG , It through error when executing.

Moreover ,...

Any Guide for this?

Does anyone can do through Scripts? any sample script or idea about?

SQL Compare taken too much memory while running.

I have complete 'Red Gate' Package.

Thanks for the wonderful answer.

kindly explain this.

but not deployed on your particular instance. So if you have InstanceA and another developer has InstanceB, and both are linked to the SalesDB...

Sorry , it was posted twice:(

Solution Pls?