Viewing 15 posts - 4,276 through 4,290 (of 6,104 total)
What service pack is your SQL Server on (not the OS, but the SQL Server itself) and what service pack is applied to your client?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 2:09 pm
You're welcome. It's one of those little known gotchas with debugging.
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
May 30, 2003 at 1:23 pm
quote:
3.) How do I find the version of netlib?
Easiest way is to execute SELECT *...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 1:22 pm
See the CREATE TRIGGER topic in Books Online or look at the articles on triggers on this site.
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
May 30, 2003 at 12:09 pm
MDF is the default extension for a SQL Server database file, much like .doc is for Word and .xls is for Excel.
Typical file extension standard:
.mdf - First data file
.ndf -...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 12:08 pm
Sure...
Stored procedure where the root path is kept in a string inside the stored procedure. Parameters are passed to flesh out the full T-SQL to execute. Since you're probably executing...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 12:04 pm
If the SQL Server service is running under the LocalSystem account, no debugging. It's typically the cause when people can't debug.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 12:02 pm
I'll start with a couple of simple questions just to define the environment:
(1) Is the Access database and SQL Server on the same system?
(2) Are you accessing them in the...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 11:10 am
Okay, first I'll tell you how to do it, but then I'll also ask the why.
In order to allow ad hoc updates, you'll have to issue an sp_configure command...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 11:06 am
Is your SQL Server set up to run under the Local System account or as a specific user (either Computer\User or Domain\User)?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL...
K. Brian Kelley
@kbriankelley
May 30, 2003 at 10:21 am
I believe the Trusted Computer System Evaluation Criteria (US specific) is being replaced by the Common Criteria (a joint effort between the US, Canada, and several European countries designed to...
K. Brian Kelley
@kbriankelley
May 29, 2003 at 7:54 am
quote:
If you're talking about ASP ISP one really huge security hole is the provider himself and his knowledge about the Windows OS...
K. Brian Kelley
@kbriankelley
May 29, 2003 at 7:42 am
quote:
all database access should be done with command objects and stored procedures, and not dynamic SQL
K. Brian Kelley
@kbriankelley
May 29, 2003 at 7:40 am
Use OPENQUERY. I don't believe the MyODBC driver exposes the proper interfaces for a 4-part naming convention. As an example:
SELECT *
FROM OPENQUERY(portal, 'SELECT * FROM nuke_users')
K....
K. Brian Kelley
@kbriankelley
May 29, 2003 at 7:36 am
quote:
Has anyone ever been injected?
While I haven't, I have done security consulting after the fact....
K. Brian Kelley
@kbriankelley
May 27, 2003 at 8:21 am
Viewing 15 posts - 4,276 through 4,290 (of 6,104 total)