Viewing 15 posts - 4,576 through 4,590 (of 6,105 total)
When you view the services (Start | Run | Services.msc if you are local, alternately, Start | Run | CompMgmt.msc and expand until you get to services if you're checking...
February 10, 2003 at 8:04 am
SQL Server won't try and query on sysdatabases directly, but rather does so through a stored procedure. As a result, even if you DENY SELECT, SQL Server gets in this...
February 10, 2003 at 7:42 am
As Antares said, if you are going to use only one SQL Server (not multiple instances which are in effect separate installations of SQL Server on the same box), you...
February 10, 2003 at 7:29 am
This error will also show if you are using a user login from an untrusted domain. The Windows 2000 and 98 machines that are failing, are they on the same...
February 10, 2003 at 7:23 am
No, this typically isn't an issue. Check the SQL Server logs (in EM: Management, SQL Server Logs | Current).
You should see a line similar to: SQL Server is listening on...
February 10, 2003 at 7:18 am
Grouping a few of these together:
February 10, 2003 at 7:09 am
As for the blank SA password switch, if you don't want to fool with it, connect to the MSDE instance using Query Analyzer and use sp_password to set the SA...
February 10, 2003 at 7:02 am
Another option, especially for those having real difficulties with MSDE, is to download SQL Critical Update. It won't bring you up to SP 3, but what it will do is...
February 10, 2003 at 7:00 am
In the Server Network Utility, you have the option, when viewing TCP/IP properties, to click a checkbox to hide the server. What this means is that the server isn't supposed...
February 8, 2003 at 8:57 am
John, there is a way:
http://www.sqlservercentral.com/scripts/contributions/25.asp
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
February 7, 2003 at 2:03 pm
Right. Based on a particular system table. You specify the table with @TableName.
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
February 7, 2003 at 1:58 pm
And since we're on the topic... just take a gander at what the public role has access to. You'll be surprised. One of the things I've written recently to identify...
February 7, 2003 at 12:07 pm
Yup, views and functions use the same encryption method. However, it needs to be said that WITH ENCRYPTION will stop the merely curious.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to...
February 7, 2003 at 12:01 pm
Thre seems to be an issue if there are hidden servers on SP3 in the environment as well, though it hits intermittently. I think this is one of the bugs...
February 7, 2003 at 9:38 am
The script by shoeboy is limited to 4000 chars, by dOMNAR's program dSQLSRVD is not.
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
February 7, 2003 at 9:07 am
Viewing 15 posts - 4,576 through 4,590 (of 6,105 total)