The engine is basically the same, so yes, you should. Although that doesn't have an effect on authentication or the SQL Server service starting. Is that the service you're having...

The engine is basically the same, so yes, you should. Although that doesn't have an effect on authentication or the SQL Server service starting. Is that the service you're having...

Is the IISAdmin service disabled on this server?

Typically, the BUILTIN\Administrators group has sysadmin rights unless the DBA has intentionally removed its rights. That corresponds to the local Administrators group for the Windows server. Have you tried logging...

You can make the change and it will require your sqlserveragent service to be restarted, because you'll have to restart the mssqlserver service in order for the change to take...

Take a look at:

How To Retrieve Values in SQL Server Stored Procedures with ADO

ALTER DATABASE <Database Name>

SET RESTRICTED_USER

This will set the database such that only sysadmins, db_owners, and dbcreators can access the database. To revert it back:

ALTER DATABASE <Database Name>

SET MULTI_USER

Do you have a way of restricting what IPs can connect? Usually this is with a firewall or router? In other words, are legitimate connections coming from a known IP...

Is this server on the Internet?

Keep in mind, though, that in writing articles, you focus on the technology that the article is primarily about. While I agree with you about securing the connection string, the...

As used in answer A, yes, it effectively filters out any cases where you have an employee but no orders. I don't know what I was thinking when I wrote...

Without the GROUP BY, the LEFT [OUTER] JOIN will return all rows of the left table, even if there isn't a match on the right table. This can be useful,...

Answer A, the GROUP BY will filter out any employees who do not have sales. And while JLSSCH makes a good point that you can get rid of the subquery,...

With respect to scripting languages on the Windows platform, Perl gives a person more options than VBScript and JScript (even with WScript). For administrators and DBAs, there's a lot of...

Keep in mind that saving rack space is only one reason to go VM. There are others:

- Hardware layer abstraction (can be key for DR plans)

- Maximize use of hardware...