1) You won't. Microsoft has chosen not to document all of the extended stored procedures in the environment. Researchers like Alex Chigrik have written some articles covering undocumented extended stored...

My personal preference is to break all of his fingers, but I know that probably won't be considered acceptable.

There's an FAQ with some more details if...

When he logs in to Citrix, he is effectively running a program on that system. Whatever account (including domain) he's using to log on to the Citrix server is the...

This is beacause it's undergoing a conversion. The default style is:

hh:mm:ss (AM|PM)

You can look under CAST AND CONVERT in Books Online for more information about the conversion.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start...

Short answer, yes.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Hrm. Okay, PHP is like ASP or JSP. It's a scripting language designed to present web pages. It's not an actual database. With that said, it wouldn't surprise me if...

Yes, always secure the sa account with a strong password. Now, let's start with roles.

The sa account is built into SQL Server. If you specify for SQL Server to run...

See if any of the following apply:

http://support.microsoft.com/default.aspx?scid=kb;en-us;819264

http://support.microsoft.com/default.aspx?scid=kb;EN-US;316541

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Extended Stored Procedures are only found in the master database. If you revoke access to an extended stored proc, only a role that can bypass security would have the ability...

BTW, here are the OpenHack 4 write-ups:

http://www.eweek.com/category2/1,3960,600431,00.asp

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

OpenHack 4 was a competition sponsored by eWeek. They invited Microsoft and Oracle to lock down an application (Microsoft had to re-write it since it was in JSP, so they...

Try the system stored procedure sp_helptext. For instance:

EXEC sp_helptext MyView

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

I completed it again. I liked the SQL Server hat and my son won't give it up. Now, what will probably happen is my 4 year-old will see it and...

What Microsoft did for OpenHack 4 is basically drop all the permissions the public role had. They left two, but I can't remember them off the top of my head....

Send them to a web page that takes their username and password into SQL Server, as well as what they want the new password to be (do the confirm password...