pop your windows account into the local administrators group on that server and then check the results

These products are primarily diagnostic products!

If you have SCOM installed I would use currently available or create your own managements packs and...

Lynn Pettis (4/29/2010)

---

Since you are not using a witness, if the mirror databaseis unavailable, the transactions will get committed on the principal database. This will start approximately 10 seconds...

Ratheesh.K.Nair (4/29/2010)

---

Hi Experts,

When i connected to a remote sql server ..the status icon(green for running & red for stopped) is showing blank its just white there for sql server and...

Hi

ok just thought i'd check. Incidentally, the best way there is to grant the distributed com users group remote access permissions and then add any users\groups ino this local group

TO user_or_role

😉

no going by the link, i always prefer a clean install and not an upgrade. Maintenance plans are stored in the msdb so wont be affected. Do you actually have...

personally i would uninstall ssis from node 1

ico-601891 (4/20/2010)

---

The DOMAIN\GROUP is DOMAIN admin group.

The DOMAIN\USER is DOMAIN\GROUP member, and for this DOMAIN\USER is a domain administrator.

At the same time i add both DOMAIN\GROUP and DOMAIN\USER as member...

you normally need to set DCOM permissions, have you done this yet

to give permissions to all tables and views use the roles

DB_Datareader

DB_Datawriter

or just create scripts to grant the permissions to the tables (remove un needed permissions as required)

GRANT SELECT, INSERT, DELETE,...

Truncate is generally more efiicient when clearing the whole table and unlike delete will reset any seed value as well!

Hey, no problem. Remember also, only use EXECUTE AS if you want to inherit permissions from another database user!

just use the following pattern

GRANT permissions list ON OBJECT::storedprocname to databaserole

valid SP permissions to grant are alter, control, execute, take ownership, view definition

according to the KB article, yes.