That's the scenario still communicated by MS as their preferred practice. However, with the ability to nest groups more than 2 levels in AD, etc., with the # of servers...

I prefer global but I've seen it both ways. My preference for global is two fold:

1) As a DBA, if I have to restore the database to a different server,...

For those interested in finding the contents of system stored procedures in SQL Server 2005, I've posted to a threat Yelena started:

Getting text of system stored procedures in 2005

After doing some checking, it is possible. However, not so with sp_helptext as in SQL Server 2000. Now you must use object_definition().

SELECT OBJECT_DEFINITION(<object ID>)

As an example:

SELECT OBJECT_DEFINITION(OBJECT_ID('sys.sp_help'))

This is correct. Microsoft is working hard on this version to protect the schema more. Therefore there are a lot of things they're putting in, like system views, to try...

Try adding fitfd10\aspnet (notice the difference in the slash).

If your SQL Server is on a different server, you're left with a few options. The two most common choices:

1) Change SQL Server to allow mixed mode and go back...

If you need specific references more than a message board post:

- SQL Server 2005 Books Online (preliminary documentation since it is still in beta)

- My security column in the January...

Is the SQL Server set to only accept Windows authentication? You can check this through Enterprise Manager.

- right-click on the server name

- choose Properties

- click on the Security tab

- look...

No, there is no setting in SQL Server 2000. Hence the adoption of whatever the settings are for the OS in SQL Server 2005. The only option is you can...

We use a three physical node cluster for a two virtual node exchange cluster. Minimum for Exchange is N+1. SQL Server, however, has no such limitation. We have 1 active/passive...

Fonts are very much a personal preference. For instance, I know a DBA who immediately switched to Comic Sans, another DBA that doesn't do anything unless it's System (no joke),...

Good point. Shameless plug for the magazine... SQL Server Standard's July 2004 issue had an article on how to do this:

http://www.sqlserverstandard.com/issue/200407.aspx

Transactional replication doesn't require a SQL Server Enterprise license (nor the equivalent on the OS side). Also, the "backup database" can be used live, but this can cause issues if...

An option, if you have the capacity, is to setup a named instance and split the data sources back out in your development environment. It does mean the management of...