Forum Replies Created
Viewing 15 posts - 4,621 through 4,635 (of 6,105 total)
-
RE: ADO Parameters or Stored Procedure
Nit-picking a bit, but ad hoc queries can have cached execution plans that are re-used (see Chapter 15 of Inside SQL Server 2000). With that said, you eliminate a lot...
-
RE: sp_OACreate returns Access is Denied
This isn't related to cross-database ownership chaining. The system stored procedures are first looked for in master and executed there if found. Take for instance, sp_help. The stored procedure sp_help...
-
RE: SQL Server 2000 Security Tools
Hrm. SQLScan and SQLCheck seem to be two packages to do what eEye's SQL Retina Scanner does in one:
http://www.eeye.com/html/Research/Tools/SapphireSQL.html
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring...
-
RE: SQL Server Slammer Hotfix fails
In the first link you posted:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/MS02-061.asp
There's a section in the upper right portion of the bulletin text labeled "Get the Patch" with a drop down menu with "Choose a language"...
-
RE: SP3 on SQL Server 7.0
Typically, when a service pack is going to upgrade the MDAC, it's listed in the Readme.htm file Microsoft packages with the SP. SQL Server 2000 SP3 is like this: it...
-
RE: sqlmanager.exe error after installing SP3/sql2000
That sounds like something is crashing... but it should be reporting an error. Typically these kinds of quirks can get resolved by reapplying the service pack (I know, standard Microsoft...
-
RE: identifying connections
You can get the current SPID by query @@SPID and then you can find the application name by querying against sysprocesses in the master database. For instance:
-
RE: SQL Server Slammer Hotfix fails
That would do it. Just as a reminder to anyone who would be patching... SP2 is required to apply these hot fixes. We had to bring up servers that were...
-
RE: Service Pack and Security Patch Management
We've just gone ahead and purchased UpdateExpert from St. Bernard and I was able to push SP2 and MS02-061 to a couple of servers for this here worm issue. We...
-
RE: SQL Mail
SQL Mail runs on the server. Unless I'm mistaken, it needs the MAPI profile locally.
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: sqlmanager.exe error after installing SP3/sql2000
Now that sounds cool!
When it's up on the screen, I know it appears in Task Manager. When you mouseover it, does the process disappear from Task...
-
RE: SQL Worm - Are we lazy
A few things.
First, the vulnerability was published July 2002. Microsoft provided a patch at that time. The security bulletin in MS02-039. So it's been known about for a while. NGSSoftware's...
-
RE: Error and warning in Event log -- SuperSocket info
If you haven't registered it, it shouldn't be. The new error number has me intrigued, though.
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: Error and warning in Event log -- SuperSocket info
Are you trying to register the SQL Server with AD Services? Is the SQL Server registering successfully with AD?
As far as MSSQLServerADHelper, no, it shouldn't be started. SQL Server kicks...
-
RE: How to avoid precompile
Check out my article on Stored Procedures and Caching on this site. It covers some of the reasons for recompiles. I culled it from a variety of sources, so there's...
Viewing 15 posts - 4,621 through 4,635 (of 6,105 total)