Security is fairly granular in SQL Server 2005. You can not grant rights or deny rights for many operations.

If you are more specific in your questions, we can help. There...

There's no way for us to list everything to keep in mind. Read the "What's New" in BOL for 2005 and look for keyword changes.

Create a procedure to mark the licenses as available and then mark it as a "startup procedure" as Gail suggested.

I haven't seen one. There are quite a few SQL Server XML functions and you might be able to read through the tables (sys.tables, etc.) and return data in XML.

No, SQL Server isn't really built to write it's data to the file system. It writes it out to a client that can be used to build a file, display...

These are IIS errors, not SQL Server. And I'm not sure why these would cause the connection to SQL Server to drop.

Can you perhaps explain what is wrong rather than...

I tend to agree with what Kenneth suggested. Keep it simple.

While that does make some sense and might get people to use the Resource Governer, I'm not sure I like that since this is an Enterprise Only feature.

Hopefully it...

This is a hierarchy and you'd need some recursion to get everything. Or a loop.

Check this out: http://www.sqlservercentral.com/Forums/Topic437859-338-1.aspx

If you use VMs, why use instances?

VMs can work for SQL Server, remember that you take a hit in performance in a VM v the same sizes physical machine. IO...

Is the column defined as 100? I'm slightly worried about corruption here. Or has the table definition changed?

I'm not sure what you mean when you ran it against Excel. Is...

I agree with Andrew that this doesn't make sense. Can you better explain, or give an example of what you mean? Maybe show a few tables.

Also, are you sure you...

I'm not exactly sure what the limitations are. We publish as HTML, so you have to be aware of that. We can take code in the question, use the code...

Hah! The UK is running a bit behind because of the shadow from the US! 😉

Thanks for the note and I'll keep writing if you keep answering.

No apologies needed, though they are appreciated. I know most of you just want things to be better. The...