I have a Visual Basic (VB) application that connects to a SQL Server 2000 database. How can I verify that the client machine has a TCP/IP sockets Net-Library connection to the database...
I have a problem with developers cluttering my production server with Data Transformation Services (DTS) packages. The developers need permissions on the server, but I don't want them creating packages on it. How do I prevent certain users from...
I'm trying to make my SQL Server installation as secure as possible. Some of my users need access to Enterprise Manager, but I don't want them to view Data Transformation Services (DTS) packages on the server. Enterprise Manager lets me restrict...
I regularly get an annoying error message from Enterprise Manager when I try to view database information through the Task Pad view. Figure 1 shows the dialog box that displays the error message. When I click Yes or No, Enterprise Manager...