K. Brian Kelley

Forum Replies Created

Viewing 15 posts - 4,621 through 4,635 (of 6,104 total)

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...
K. Brian Kelley
@kbriankelley

January 31, 2003 at 8:49 am

#447709
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...
K. Brian Kelley
@kbriankelley

January 31, 2003 at 7:18 am

#447701
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"...
K. Brian Kelley
@kbriankelley

January 30, 2003 at 4:37 pm

#447673
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...
K. Brian Kelley
@kbriankelley

January 30, 2003 at 1:00 pm

#447647
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...
K. Brian Kelley
@kbriankelley

January 30, 2003 at 12:56 pm

#447646
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:
```
K. Brian Kelley
@kbriankelley
 
```
January 30, 2003 at 12:52 pm

#447645

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...

K. Brian Kelley
@kbriankelley

January 30, 2003 at 11:15 am

#447629

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...

K. Brian Kelley
@kbriankelley

January 30, 2003 at 11:11 am

#447626

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

K. Brian Kelley
@kbriankelley

January 30, 2003 at 11:07 am

#447624

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...

K. Brian Kelley
@kbriankelley

January 30, 2003 at 11:04 am

#447623

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...

K. Brian Kelley
@kbriankelley

January 30, 2003 at 11:00 am

#447622

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

K. Brian Kelley
@kbriankelley

January 29, 2003 at 12:31 pm

#447512

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...

K. Brian Kelley
@kbriankelley

January 29, 2003 at 11:53 am

#447509

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...

K. Brian Kelley
@kbriankelley

January 29, 2003 at 10:27 am

#447500

RE: SQL Worm - Are we lazy

I feel for you, KIK:

TruSecure pointed out the obvious vectors other than direct attached to the Internet:

Hibernated laptop

VPN

RAS

They provided easy access to the soft-underbelly of internal LANs that had solid...

K. Brian Kelley
@kbriankelley

January 29, 2003 at 10:24 am

#447498

Viewing 15 posts - 4,621 through 4,635 (of 6,104 total)