June 5, 2008 at 6:01 am
is there any way to find out the user name who dropped the particular table in data base ?
June 5, 2008 at 6:35 am
Assuming the system hasn't been rebooted, yes. Right click the database and you can run a report called "Schema Changes History." It'll tell you everything done to the database in terms of DDL since the last time SQL Server was started.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 5, 2008 at 8:17 am
There are also trace files you can read with SQL Profiler in your LOG directory that traces DDL changes. So if the table was dropped (as in deleted), you can probably the answer by reading through those traces.
K. Brian Kelley
@kbriankelley
June 5, 2008 at 8:46 am
That's actually what the report is doing. I watched it through Profiler.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 5, 2008 at 9:12 am
can you tell me how to create rdl file ?
June 5, 2008 at 9:25 am
That's a report definition file, a part of Reporting Services used by the Management Studio to show the data. It shouldn't be something you have to create.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 6, 2008 at 8:43 am
how to create the customize report ?
June 6, 2008 at 9:05 am
Enormous topic. I'm just getting going with Reporting Services myself. Short answer, SQL Server Business Intelligence Development Studio. Long answer... This is the book I'm starting to read.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 7, 2008 at 8:12 pm
sudhakara (6/5/2008)
is there any way to find out the user name who dropped the particular table in data base ?
heh.
Select victim as [Culprit] From [Witch].[Hunt]
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply