Browse by Tags

All Tags » SSMS (RSS)

SQL 2008 standard edition maintenance plans and compression comment..

A minor niggle with SQL standard edition and SSMS :- I don't use SQL standard edition very often.. So this surprised me on SQL 2008 service pack 1 - When creating a backup maintenance task, SSMS gives you the following options :- See that you are...
Posted by steveh99999 | 1 comment(s)
Filed under:

Interesting SSMS issue with waittype of PREEMPTIVE_OS_LOOKUPACCOUNTSID

Saw a recent issue with SQL2008 sp 1 where SQL Server Management Studio (SSMS) appeared to hang when a DBA expanded the database users tab of a database‚Ķ ie like this :-   When we looked at the waittype of the SSMS session - via sys.dm_os_waiting_tasks...
Posted by steveh99999 | 1 comment(s)
Filed under: ,