I would add two more tasks to the checklist

1. Remove Built-in admiinstrators

2. Disable or at least rename the sa account (in 2005 or higher).

About hte loging of succesful logins I...

No, in your case if you want to restore everything until the last tlog backup (#28) you should start with the last full backup #25 and then add the remaing...

patrick.kmleung (11/26/2008)

---

Hi,

When I running an application, it lost the response. Then I restart the sql server 2000. I discovered 3 files :sqlserver.20081121163006.dmp, another 2 same format file in

C:\Program Files\Microsoft...

The dificult part is to find the information when a login was last used. Unless you have enabled login auditing for succesfuly logins that information is not automatically stored. You...

There are probably no permissions granted on table level. It's actually a well-known practice to do all select\insert\update \delete through stored procedures or views and not granting any direct permissions...

Instead of using the remove option select change. This will give you the option to remove RS. Of course you could also choose to simply disable the RS service.

Be careful with changing the index. Some applications need this option diabled. I remember with a SAP database that it contains a couple of tables where page locking must be...

Wilko (11/26/2008)

---

Hi there, thanks for your comment, I'm looking for a SQL 2005 book that looking into database migration ( upgrade & side by side upgrade from version 7 &...

The values in sysstat refer to what type of object it is. 3 means it's a user table. But I would advise against using this column in your scripts, because...

I assume you mean the client tools when you talk about admin tools. When you install a new instance it will detect that these are already installed and won't reinstall...

JWOL (11/26/2008)

---

When is the database setting "ANSI_PADDING" used? Books Online says that this is on by default but in a fresh install of SQL Server I find that this...

Authenticate is used for the Execute As clause. It basically gives you the right to act as another user.

See here for more details:

http://msdn.microsoft.com/en-us/library/ms188304(SQL.90).aspx

By gicing your user CONTROL...

The latest cummulative hotfix pack is build 2273. You can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=8316BC5E-8C2D-4710-8ACC-B815CCC81CD4&displaylang=en

By the way if you only want your user to d select and executes you should remove him from the datawriter role.