Viewing 15 posts - 4,546 through 4,560 (of 6,105 total)
Hi Betsy,
Sync'ing time is pretty easy to accomplish whether you have NT 4.0 or Windows 2000 in your environment. Take a look at the net time command. Here are some...
February 12, 2003 at 9:03 pm
Andy Warren has an article on the site on why not to use the public role:
http://www.sqlservercentral.com/columnists/awarren/sqlpermissionspublicrole.asp
Best practice when you can do it:
- Assign Windows users to Windows groups.
- Grant groups...
February 12, 2003 at 8:51 pm
Not that I am aware of. I believe Windows 2000 stays at MDAC 2.5. And in any case, SQL Server 2000 SP 3 uses MDAC 2.7 SP1 which may need...
February 12, 2003 at 2:25 pm
Yes. It can be installed separately or as part of another installation. Thankfully, it and the rest of the SQL Server 7 versions aren't vulnerable to SQL Slammer.
K. Brian Kelley
http://www.truthsolutions.com/
Author:...
February 12, 2003 at 1:05 pm
There are a few issues:
1) Some applications (Microsoft Access and ODBC Data Source Administrator come immediately to mind) query against the system tables. Sysdatabases and syscharsets come immediately to mind...
February 12, 2003 at 12:47 am
I've been doing administration for a long time as well. I've worn a system administrator hat, a DBA hat, a developer hat, and hats where my roles were combined. Division...
February 12, 2003 at 12:37 am
Have you taken a look at this KB article?
http://support.microsoft.com/default.aspx?scid=kb;en-us;239894
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 11, 2003 at 2:27 pm
Tim, I'm surprised your domain admins allow you to do this. This is definitely not a good security practice. Here's why:
When you remove Domain Admins and then define who you...
February 11, 2003 at 2:19 pm
How it got there... not for the squeamish or weak of heart:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=10&tabid=13
It's the list thus far.
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 11, 2003 at 1:56 pm
The SQL Retina Scanner is actually significantly faster, since it's multi-threaded. Also, it's GUI based.
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
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
February 11, 2003 at 1:19 pm
quote:
I typically remove the Domain Admins global group from the local Administratorsgroup when on a SQL Server
February 11, 2003 at 12:34 pm
Have you tried posting in the microsoft.private newsgroups (you should have received the location either at the download location or the email from Microsoft)? To be honest, I've only seen...
February 11, 2003 at 12:31 pm
Multiprotocol supports encryption and can use TCP/IP, but I'm not sure how feasible it is across the Internet. It's available in SQL Server 7.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide...
February 11, 2003 at 12:05 pm
Is the total length of a row in the text file > 255 characters? If so, you may want to contact Microsoft's PSS. I believe there is a fix available...
February 11, 2003 at 12:02 pm
Because you can put multiple Global Groups into a Local Group. This means that you only have to add the Local Group to SQL Server as a login, instead of...
February 11, 2003 at 12:00 pm
Viewing 15 posts - 4,546 through 4,560 (of 6,105 total)