Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 6,105 total)

  • RE: Cluster Failover HELP

    Probably not the cause, but one of those "Get the question out of the way" types of things. Did a password change occur recently and if so, how was the...

  • RE: EM -- keeping prying eyes out

    You can't without locking down sysdatabases. However, if you lock down sysdatabases you can break ODBC, Access, and anything else that issues a query against sysdatabases (more than you might...

  • RE: Paper Book listing built-in sp's

    Perhaps no one has proposed that idea to O'Reilly, who publishes the Nutshell series. They have the SQL in a Nutshell book, but they don't have another database related Nutshell...

  • RE: Calling an External Program from a SP

    This is typically done using a mechanism such as xp_cmdshell. The stored procedure will wait until xp_cmdshell completes, because xp_cmdshell does return back a return set.

    However, using techniques like xp_cmdshell...

  • RE: master db

    This is something that happens generally to most any application. In the late 80's and early 90's, "pirates" armed with a hex editor were breaking copy protection on commercial programs...

  • RE: locking

    I wouldn't know of any system functions that would require an application role, so it doesn't make sense a lock is occuring on the stored procedure for that. I would...

  • RE: master db

    If you're concerned about users other than the SQL Server sevice account seeing the database files, you have a solution under Windows 2000:

    (1) Log on to the server as the...

  • RE: Paper Book listing built-in sp's

    I haven't previewed Randy Dyess' e-book, Transact SQL Language Reference Guide, but I believe that was one of his goals... to compile all the disparate information into one place. You...

  • RE: locking

    The stored procedure sp_setapprole is definitely not unusual at all. If you have an application role setup on a database, sp_setapprole is what is used to activate it.

    The following stored...

  • RE: "sp_" prefix

    Yes. If you are creating stored procedures in user databases, avoid sp_ because it will cause a performance hit. It has to do with how SQL Server looks for the...

  • RE: How to script all my stored procedures ENCRYPTED

    Just a heads up on the script in the repository. The script on the site uses the mechanism proposed by shoeboy. It gets around the need to know certain information...

  • RE: How to script all my stored procedures ENCRYPTED

    dOMNAR's SQL Server SysComments Decryptor:

    http://www.geocities.com/d0mn4r/dSQLSRVD.html

    Requires you to have sysadmin rights on a SQL Server 2000 installation.

    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

  • RE: Number of Deadlocks/sec

    Number of Lock Requests per second that resulted in a deadlock. It should be zero. If it's not, then deadlocks are occuring.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL...

  • RE: What is the search order for Procedures prefixed sp_?

    It does not apply to sp without the underscore. For instance, spTestMe would be fine. sp_TestMe causes the Cache Miss, etc.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server...

  • RE: Documentation - separate table, Extended property?

    If you are going with external tools, the separate tables make sense. You could actually carry this through for all your metadata.

    For instance, one of the things we deal...

Viewing 15 posts - 4,861 through 4,875 (of 6,105 total)