Updated grid.

Hi Gail,

I have a created a test user in the db_datareader role. The user does not have explicit access to the view I've created (select top 2 * from table1)...

Thanks Gail,

That exactly the type of feedback I was looking for. I need to rephrase that section in that they may be able to run the views (with some exceptions)...

Oops ,

Thanks for that. I'll remove the offending line. Is their anything that you would add in or remove from that list. It's to give to developers to explain their...

Hi Gail,

Great article in the last newsletter.

My formatting may not be the best but X means that they have this ability.

More of an X marks the spot rather that an...

Thanks for your reply kenneth,

You do make sense. I've now hard coded 50 characters into the substring and I'm getting better results (It still seems to truncate the name after...

Hey,

I think that the 2Gig figure is the max amount of RAM that is useable for the standard version. If you want to use >2Gig  of ram, you then move to...

Once you've confirmed he doesn't own any more objects, you can delete him from the sysusers table on the relevant database

NB. You must allow ad hoc modifications to the...

YOu can shrink the log as much as you want, however keep it in reasonable proportion to the Data file 

WUMS is our testdb name. My bad.

Hi Carol,

This isn't my script - I got it on this site. But it works for the optimization side.

EXEC sp_MSforeachtable @command1="DBCC DBREINDEX ('[yourdb].?') WITH NO_INFOMSGS CHECKPOINT"

BACKUP LOG WUMS WITH...

Hi,

If you select the device and proceed as if you were doing a full restore (Don't actually restore) you will see a 'view contents' button. Click on this and check...

Had the same problem with a remote server, sp_who2 works.

You may also find this useful.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246133&ID=KB;EN-US;Q246133&#4

Space is often an issue if there is a optimization task running prior to the backup - This creates a large transaction log.

Also do these backups fail when you recreate the...

Hi Mike

SQL 6.5 Has two licencing modes - Per Seat and Per server.

You should be able to find which one it is via the contol panel, Licencing manager I think?...