Awesome!! thanks for your replies 🙂 now it's more clear for me and now I understand why. thanks guys!

http://msdn.microsoft.com/en-us/library/ms187762.aspx

Check in the remarks, the second paragraph, yo will see this: "To drop clean buffers from the buffer pool, first use CHECKPOINT to produce a cold buffer cache."

Maybe...

I hope your apps have the server name in the connection string... 🙂 rather than the IP Address

Once everything is ready, you should turn off the old server, then rename...

When you run an alter database, it needs to apply an exclusive schema lock for that table, that causes selects in other SPIDs to wait until the transaction commits, if...

When we have upgraded the servers here that's the way we do it, but if you use replication you can set up the new server as a subscriber of it...

I am not 100% sure if I understood completely what you need, but maybe this link could be usefull.

http://www.codeproject.com/KB/dotnet/evtvwr.aspx

Thank You very much Dan!

Good question, but the answer is for SQL Server 2008, not 2005.

Also, the link that is offered as the documentation doesn't says the maximum number of indexes allowed, just redirects...

Maybe this will be useful for you to fix the issue:

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.oledbprovidersettings.disallowadhocaccess.aspx

http://bytes.com/topic/sql-server/answers/142321-solution-ad-hoc-access-ole-db-provider-has-been-denied-you-must-access-provider-through-linked-server

I Hope this helps.

Regards,

Frank

You can also use the sp_helprotect stored proc to get the information about the objects you have granted or denied access to.

sp_helprotect

Something that I usually do is to put that...