I see that it does not give the name of the file. I found a great resource which satisfies your requirement:

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

vyas got an awesome stored procedure created, just execute it...

execute:

SELECT * FROM fn_trace_getinfo(0);

the argument '0' will return information about all active traces.

property column value '2' gives the logical file name. From the result you can determine the traceID of...

haah!.....cos your above T-SQL code not create a primary key.

the PRIMARY in the above code creates table on the primary filegroup.

If you want to create a primary key:

SET ANSI_NULLS...

As I read in this forum, if we do not set max memory we will get many issues.What are the metrics I need to consider to set min and max...

For sensitive data like that I would encrypt the data even if i trust...

Its our pleasure, please do post if you are in trouble anytime.

You should Restore your database with COPY ONLY option. When this used it is independent of your regular backups and does not disturb your differential backup sets according to your...

Change the Authentication type to Mixed Mode it should work.

As Jack said you can query sys_dm_exec_query_stats which will give you last execution time.

If would like to get the SQL text run and the table used use the dmv...

First you should investigate why your DB is in Full Recovery mode? Is it according to your business?

There are many advantages for DB to be in Full Recovery model....

Why dont you run Profiler against the troubled server?

Check the events:

TextData

ApplicationName

HostName

LoginName

EndTime

SPID

CPU

Duration

Reads

Writes

Your Child table should be referenced by Primary-Foriegn key relationship.

If you are using CASCADE DELETE/UPDATE the consecutive members in the child table will get be updated/deleted according to the...

That's an easy one point 😀

You would have to look at your business requirements and then determine how much data loss is acceptable? In those lines you need to design your Backup strategy, but more...

Or in T-SQL:

USE 'Database-name'

GO

SELECT * FROM 'your-table-name'