Have you logged on as Freddag after adding him to the AD group? His token won't include that he is a member of that group until it is regenerated,...

You need a semicolon or "go" statement between the different lines.

If some sort of statement delimiter is not between the statements SQL Server tries to resolve it as a single...

This is a generic catch-all error. In 99+% of cases it's because the client cannot resolve the name/address of the SQL Server instance: you will nearly always get "logon...

What is the total size of the primary key you're trying to create?

If the index you're trying to create would have entries that are longer than 900 bytes then it...

There are lots of best practice papers scattered around the 'net that advocate RAID1 or RAID10 for log files.

One of my favourites is this top 10 storage practices:

You will see...

I haven't got an SQL2k machine I can test this on, so this is off the top of my head.

The only thing I can think of is to do an...

It's really hard to tell what caused tempdb growth retrospectively: you really need to be checking while it's growing (of course, the question is then how do you predict that).

If...

The way to fix an unmapped SQL Server login is to execute the command:

This updates the SID of the user in the database to match the SID...

Yes, you should add the update statistics job.

When you rebuild the indices the statistics on those indices will be updated, but not on the non-indexed fields. The statistics are...

You can't restrict the rights of a member of the sysadmin role: membership of that role results in a login bypassing virtually all security checks. If the login isn't...

The ASCII code for the dollar sign is decimal 36. I've got no idea whether that same code is used for the other currency symbols when the connection is...

The error that you're getting through the GUI is "Path not found". When you try to restore through the GUI it assumes the database is being restored to the...

The best way to do this is to use the DENY statement. Refer to Books Online.

Deny takes precedence over Grant, so even if your users have been granted write...

By default SQL Server picks this up from Windows from the server's language/locale settings.

The setting within SQL Server can be changed to something different at the SQL Server level by...

The change in the state of the database doesn't occur until there are no locks of any type in the database. You need to include the "WITH ROLLBACK IMMEDIATE"...