Viewing 15 posts - 8,011 through 8,025 (of 9,253 total)
pop your windows account into the local administrators group on that server and then check the results
April 30, 2010 at 4:06 am
Apurva (4/29/2010)
Quest Spotlight or Idera diagnostic manager
These products are primarily diagnostic products!
If you have SCOM installed I would use currently available or create your own managements packs and...
April 29, 2010 at 8:30 am
Lynn Pettis (4/29/2010)
April 29, 2010 at 8:26 am
Ratheesh.K.Nair (4/29/2010)
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...
April 29, 2010 at 8:21 am
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
April 29, 2010 at 8:14 am
CirquedeSQLeil (4/28/2010)
The best way is to grant the permissions to a user role. Add the user or group to that role.
TO user_or_role
😉
April 29, 2010 at 12:25 am
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...
April 28, 2010 at 10:54 am
personally i would uninstall ssis from node 1
April 28, 2010 at 10:30 am
ico-601891 (4/20/2010)
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...
April 28, 2010 at 10:22 am
you normally need to set DCOM permissions, have you done this yet
April 28, 2010 at 10:02 am
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,...
April 28, 2010 at 9:44 am
Truncate is generally more efiicient when clearing the whole table and unlike delete will reset any seed value as well!
April 28, 2010 at 9:40 am
Hey, no problem. Remember also, only use EXECUTE AS if you want to inherit permissions from another database user!
April 28, 2010 at 8:21 am
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
April 28, 2010 at 6:02 am
gmamata7 (4/27/2010)
Is this applicable to our case (having SSIS in Active node and NOT on Passive node)?please advice??
according to the KB article, yes.
April 28, 2010 at 5:51 am
Viewing 15 posts - 8,011 through 8,025 (of 9,253 total)