I'm not sure. I know SQL Server 2008 is definitely affected. I have asked on one of the patch management mailing lists. I'll post what I hear back.

In SSMS. Right-click on the database and choose Reports. Choose Standard Reports | Schema Changes History.

That will give you time/date and who did it, provided the info is still in...

The...

ouqiwu (8/10/2009)

---

I used named instance, name EOS50, for SQL server 2008 instance. But this solution requests to add EOS50/ to all database connection string in the application code. So we...

Katmai - Custom components and upgrade

The Key SQL Server 2008 BI Migration: DTS to SSIS 2008, Part 2 of 2[/url]

Trash Destination Adapter

There can only be one default instance on a system. Therefore, if you want a SQL Server 2008 default instance, you will need to uninstall the SQL Server 2000 default...

As indicated, it's really no different than multiple instances of the same version of SQL Server on a cluster. You still have to make the appropriate plans for resources. Where...

To ensure database access is clear:

If a login has CONTROL SERVER rights that login has access to every database. Likewise, if a login is a member of the sysadmin fixed...

Jack Corbett (8/7/2009)

---

Brian probably has the best idea. Didn't even think about the brute force attack, although I did almost mention reading the SQL Server Error Log via a...

My recommendation to you is to take a slightly different approach. It would be better if you run a job or process periodically (say every 15 minutes) that checks for...

You should look at removing BUILTIN\Administrators. That's a given, because it means administrators have to jump through the other hoops to get access. You should not, however, look at removing...

Lee,

in short, you can't stop the system administrators. If I have admin rights to your server, I will get in to your SQL Server. So you've got to...

I think the Novell volumes are only visible through the Novell client. I believe that client only works for a logged on user (not for a service like SQL Server)....

If you bring up the SSAS properties for that server (right-click on the server and choose properties) and then click on the Security page, do you see who is listed...

Free (7/15/2009)

---

Hi there,

I have 2 groups of developers

Dev1Team

Dev2Team

How would i set it up so each group will there their own schema, and they can create / change / objects in...