This Scripts will check for public access to extended Stored procedures in sql server 2000 and 2005.
Select sysobj.name, user_name(sysperm.grantee) as [Granted to] from master.dbo.sysobjects sysobj join master.dbo.syspermissions sysperm on sysobj.id = sysperm.id where sysobj.type = 'X' order by name
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
2017-12-22 (first published: 2010-05-18)
8,252 reads
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
2009-10-30 (first published: 2008-08-05)
32,555 reads
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
22,745 reads
You have all read about why object qualification is important. You also must have heard of why stored Proc should not have sp_ as prefix to the name. Now let us proove if this is all true.
2008-03-10
9,560 reads
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,810 reads
