Have you benchmarked to prove that there is really a 30-40% hit for going case insensitive?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Almost. From BOL:

Permissions

CREATE TABLE permission defaults to the members of the db_owner and db_ddladmin fixed database roles. Members of the db_owner fixed database role and members of the sysadmin fixed...

DMO has every option you'll need to script stuff out. I've got a couple articles posted that explore different bits of it.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Try adding 'set nocount on' as the first line of the proc.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Lot of ground to cover there. First, roles are the preferred method of assigning permissions. Create the role, assign permissions, then add users to the roles. Same way you manage...

Please do read about RebuildM before using it!

Andy

http://www.sqlservercentral.com/columnists/awarren/

If you're creating them inside a proc they get dropped when the proc exits - see BOL for more info on the life time of #temp objects.

Mahesh, could you post...

That will work as long as you put the data files in the same physical location, not always possible..say if server A has the data on E and server B...

How about setting up a couple copies of Personal Edition, setting up a linked server to the mdb's from there, create views to it, then link to those from the...

I think you have to really look at the applications you're using before you decide on RAID 10. Im currently use RAID5 and having no issues. I agree about the...

If you're just setting up the role, why would you need to revoke, there wouldnt be anything assigned to it anyway. If it already exists, it might be faster/easier to...

Interesting. Your two mdb's use separate workgroup files?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Only problem I see with that is you have to keep track of which changes got propagated and which didnt. Think replication would really be that bad? You're limited in...

Double check disk permissions also.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Havent really looked at one. We cooked up one for ourselves leveraging the SQL agent functionality. In terms of scheduling flexibility it's hard to beat and its a nice open...