65,222 reputation
987169
bio website sqlsentry.com
location Rhode Island
age 40
visits member for 3 years, 7 months
seen 24 mins ago

Senior Consultant at SQL Sentry, SQL Server MVP, @AaronBertrand on twitter, blogger at sqlperformance.com, blogs.sqlsentry.com, and sqlblog.com, Mac user, volleyball player, curler, hockey/football/tennis fan, big-time loser at fantasy football, proud father of two beautiful girls, and a Canadian, eh?


1h
awarded  sql-server-2008-r2
8h
comment SQL Server decryption authentication not working with concatenation
Are you sure all the data types match? This is often because the column is NVARCHAR but you've used VARCHAR explicitly (or implicitly by leaving off the N'prefix'.
9h
comment SQL Server log for revoke statements
SQL Server does not track this activity by default. You want to consider SQL Server Audit (depending on edition) or trace/extended events.
9h
revised sp_testlinkedserver output verbose
added 204 characters in body
9h
comment sp_testlinkedserver output verbose
I was able to capture a connection timeout no problem.
9h
revised sp_testlinkedserver output verbose
added 204 characters in body
9h
revised sp_testlinkedserver output verbose
added 44 characters in body
9h
revised sp_testlinkedserver output verbose
added 44 characters in body
9h
revised Linked server error not caught by TRY-CATCH
added 283 characters in body
9h
answered sp_testlinkedserver output verbose
9h
revised How to use variables with RESTORE FILELISTONLY
added 234 characters in body
10h
revised How to use variables with RESTORE FILELISTONLY
added 312 characters in body
10h
answered How to use variables with RESTORE FILELISTONLY
10h
comment How to use variables with RESTORE FILELISTONLY
No, dynamic SQL is not necessary, and this still doesn't work (that variable is not in scope inside the procedure, and not just because of the go).
11h
comment Can I turn auto-shrink off while on production server with people connected?
I don't think I would wait. Even if turning this off causes some kind of disruption (which others have confirmed does not happen), wouldn't it be worse to have 10 auto-shrink operations somehow triggered between now and the end of the day?
13h
revised Moving SQL Server default instance's folders to another path on the same server
added 368 characters in body
13h
comment Moving SQL Server default instance's folders to another path on the same server
@Armstrong63 probably cleaner to reinstall - I don't know that there is any supported process for every single folder under the Program Files tree.
13h
answered Moving SQL Server default instance's folders to another path on the same server
13h
answered xp_logevent Invalid Parameter Type
14h
comment How Do I Use PowerShell to Get a SQL Server Backup Status?
Wow, you've hard-coded your table to be over 5,000px wide. How many monitors does that span?