Yes education in this case is best policy. As a policy we will educate to use wrapper SP for shrink. It will help to avoid worry about looking list of...

DBCC shrink command will be executed as dynamic SQL statement in the wrapper SP. So if given file is restricted then dynamic SQL of shrink will not be executed in...

Purpose of wrapper SP is to first check if given file is restricted for shrink operations. If file is restricted then DBCC command will not be executed but a message...

Yes you are right, shrink is not triggerable. Permissions for DBA group are full and cannot be reduced for this purpose only.

We will be looking to write and use a...

Issue is solved. CDC was enabled on newly restored database and it was preventing the replication wizard to pick the tables for display. Publication wizard excludes the tables if CDC...

Thanks for advice. I will be analyzing these options.

I have created a new login with public server role. Just added it SQLAgentReaderRole in msdb. Again i am able to start/stop the agent with this login. So could any...

If you can ping the server from your machine then probably it will not be a firewall issue. Also try to access through IP and make sure that server is...

Thanks a lot for providing further options.

Thanks a lot. It worked great.

Yes you are right. I have made the script for tables with clustered index. So for that reason i have also mentioned it through following sentence

One final note before we...

• This reply was modified 5 years, 8 months ago by  Atif.
• This reply was modified 4 years, 4 months ago by  Dave Convery.

Also check my article on same topic.

Thanks

If graphical tools can be used then process explorer, task manager may serve your purpose.

Thanks

How do you open the table, i mean selecting whole table or limited rows? What is number of rows, number of columns and indexes on that specific table? Please also...

Pinal has mentioned same error in his blog post. Please take a look at actual post at his blog. http://blog.sqlauthority.com/2008/01/30/sql-server-fix-error-the-query-processor-could-not-start-the-necessary-thread-resources-for-parallel-query-execution/