Adding a blogsite for each member would be really great. As most companies have blogged the blogsites internally.

If the user is dbo in the database then he can change the compatability level for the database. He need not have sysadmin permissions to do that.

I hope those problem with MDAC are sorted out with SP1.

Do you mean to say that the TLOG backup jobs are failing from maintenance plan. can yo post us the error from the plan that you get.

Yes you have followed th right section in that link that how you need to rebuild the clustered instances. If you are not opting for any major changes then you...

@@rowcount will always correspond to the status of the last executed query. You will need to handle this using dynamic sql's no way than that comes across my mind.

While importing data from excel map only the columns for which data needs to come from excel omit the identity column so that it gets populated for every riow in...

Vivien,

This link given below will be the best use for you.

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

I don't think so he is doing a point in restoration. But still this would help if he does.

the last restoration with the recover clause should have the STOP AT...

Yes grant execute any to username will grant execute permission on all SPs to that user this is a new feature in SQL 2005.

you can search up in microsoft. There are n number of KB articles available for sql 2005 and they keep updating to reflect status till date.

If you are sure the default values of those are less than the sql defaults then you canchange that to reflect it with sql and have that advantage.

Learned one more info about the collation and its effects in sql server today. thanks guys.

There is a option to re-initialize subscriptions with replication you can read more about replication and its options in BOL.

You can use the below links for your reference.

http://msdn2.microsoft.com/en-us/library/ms143269.aspx

msdn2.microsoft.com/en-us/library/ms190190.aspx

geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx