SqlACID questions

SqlACID answers

• I can't seem to change drive drive using attached piece of code
• Is there any way to expand the Processes pane in Sql Server 2008 Activity Monitor?
• deadlock on a single SQL Server table
• SQL Server 2005 stored procedure performance problem
• Interfacing with the end-user's scanner from a webapp (web/scanner integration)
• OpenRowSet command in TSQL is returning NULLS
• SSMS permits duplicate records in a table, but not subsequent updates
• SQL Server CONVERT(NUMERIC(18,0), '') fails but CONVERT(INT, '') succeeds?
• What's your favored method for debugging MS SQL stored procedures?
• Backup SQL Server database using WITH FORMAT