Hi All,
Is there any way where I can block dynamic SQL query or on the go user written SQL query in SQL Server.
Is there any way, please provide me the solution.
Hi All,
Is there any way where I can block dynamic SQL query or on the go user written SQL query in SQL Server.
Is there any way, please provide me the solution.
Block SQL query? Cancel the query execution? Kill the SQL query? What did you real mean? Could you describe your requirement more clearly to make us better understand.
Prevent dynamic and ad-hoc queries from users by not giving them permissions in the first place.
If that is your sole concern, just revoke their access to the database. Or the entire server.
I guess there something more to it, but rather than trying to read your mind, I think it is better that you gives us more details.
13 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index