I selected select RPC:Completed, Statement:Completed and Batch:Completed in the trace. But I am cannot get the exact SQL Statements inside the following statements:

sp_execute 4

sp_unprepare 4

I can see some select statements...

The job is run successfully most of the times, but it fails some times. There is already log created for that package but it doesn't get created as the package...

Showing execution plan from general SQL Statement is easy. But how about getting execution plan for a SQL statement that is created from parameter inputs to the stored procedure as...

Can't I see the execution plan for the stored proc directly?

How to get the execution plan for this kind of stored procs with dynamic SQl in it?

If I want to get the exact execution plan from production environment, do I need...

Can "wrapper" proc be created in user database? or else this should be in master database?

Execute permissions should be granted in master database which is security concern in production environment.

We would like to avoid giving access to master database.

It is Transactional Replication. I am having doubt because it is going to drop and create Primary Key Indexes on subscriber database which might break replication.

Does agent fails while...

I know pull subscription can offload some work on publisher, but still I want to use distributor on the subscriber box, bcoz log reader agent will run on distributor.

we do...

For Example I replicated 33000 rows at 10:00PM, 42000 rows at 10:30PM and 25000rows at 11:15PM.

All are being shown in single session of log reader agent history.

How can I calculate...

Can anyone confirm that, Do I need to change both SQLCommand.CommandTimeout property  in C#.NET code and also Connection String in the Web.config file?

Slower server has the same value 600 secs as in the other server where the query is performing well.

I'll try the update stats and let you know.

Can you also let...

I can get the information about what locks are holding what objects from sp_lock, but I also need the waiting time of each lock for that resource?

One of the database is very huge and we want to archive some old data and shrink the database file. What sreps do we need to follow for this?

We have a monitoring tool that checks % Locks used and throws an alert if it has reached threshold that % Locks in use is 90%.

Most of the servers are...