I.T. minded
Sometimes you need to do maintenance on a database, and you don’t really want to use single user mode or disable accounts. In that situation you could kill all connections to a specific database.In order to achieve that, you can…
You can create a temporary lock in T-SQL for -for example- testing:
from : The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions.…
The following t-sql statement returns the server name, server instance, instance, edition & version of the running SQL-Server.
When tracing with SQL profiler, it returned a query using ‘sp_cursorprepexec’. When executing the same query within SSMS, it failed with: sp_cursorprepexec: The value of the parameter XX is invalid. I managed to solve this by adding ‘+ 0x1000’ to…