Hi,

Thanks for the information provided.

Is that possible from Management Studio ? The process you have pasted was that with MStudio ?

as we never used Reporting services. Am doing manually...

Dear Gail / All,

Please find the results found for the query ran : select * from ::fn_trace_getinfo(0)

traceid property value

112

12C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_91.trc

1320

14NULL

151

i couldn't undertand...

Dear All,

Thanks for your inputs..

Could you please let me know how can i protect every object in a database as SPs, Views etc..

Thanks,

CH&HU.

Dear Gail,

The result is as i have mentioned earlier. I agree with your ans that i couldn't trace the user...

Trying to make sure that this will not repeat in future.

Thanks...

Thanks much Saravanan,

Its working.. 🙂

But can i have query to drop a table when i would like to alter or drop, in some cases during deployement we will have to...

Thanks for the reply Gail,

I used :

'SELECT * FROM ::fn_trace_gettable ('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_90.trc', default)'. Result : StartTime of server : "2009-03-01 01:34:13.780" and the rest alla are Null values.

But...

I aplogize for improper information.

Users will be forcebly disconnected when the sec server is in restore mode.

Here CLIENT needs to implement Replication on the same dbs what i have explained...