Viewing 15 posts - 4,276 through 4,290 (of 6,105 total)
Try applying the SQL Server 2000 SP 3 on your client computer. This will update your client tools to SP3 if they aren't already. There was a change in SP3...
May 30, 2003 at 2:26 pm
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...
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
May 30, 2003 at 1:23 pm
quote:
3.) How do I find the version of netlib?
Easiest way is to execute SELECT *...
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
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 -...
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...
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...
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...
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...
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...
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...
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...
May 29, 2003 at 7:42 am
quote:
all database access should be done with command objects and stored procedures, and not dynamic SQL
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....
May 29, 2003 at 7:36 am
Viewing 15 posts - 4,276 through 4,290 (of 6,105 total)