SQL 2008 Packages wont work on SQL 2016. You may need to redevelop project on SQL 2016 Visual studio.

You need to remove mirroring first.

You can store the trace into a table and then execute the query to get specific data from one user only...

Thanks

In your query if you write like "prod.dbo.tablename" then SQL server take it like prod as ur datbase name,dbo as schema and tablename as table name you are trying to...

You Can use this Extended stored procedure for that....master.dbo.xp_delete_file

Goto Management Studio, Management folder....New Maintenance Plan...Give name as "Cleanup Backup" Choose "Maintenance Cleanup Task" and configure that task by providing "backup folder path" and "file extension"..

That will do it.

Thanks folks..Will let you know the result...I Appreciate

You can see date created for objects from object explorer in sql server 2005. For that Just choose "Details" option from object explorer

I got the answer from this same forum....here is the method to find out port number of sql server 2005

Sql Server Configuration Manager >

Sql Native Client Configuration >...

What about SQL server 2005? How to get port number of sql server 2005 instance?