Viewing 15 posts - 4,861 through 4,875 (of 6,105 total)
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...
November 18, 2002 at 12:37 pm
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...
November 18, 2002 at 12:29 pm
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...
November 18, 2002 at 6:38 am
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...
November 16, 2002 at 5:23 pm
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...
November 16, 2002 at 5:16 pm
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...
November 16, 2002 at 2:27 pm
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...
November 16, 2002 at 2:23 pm
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...
November 16, 2002 at 8:32 am
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...
November 16, 2002 at 8:29 am
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...
November 15, 2002 at 11:31 pm
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...
November 15, 2002 at 1:34 pm
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
November 15, 2002 at 11:15 am
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...
November 15, 2002 at 11:09 am
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...
November 15, 2002 at 11:03 am
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...
November 15, 2002 at 7:49 am
Viewing 15 posts - 4,861 through 4,875 (of 6,105 total)