Viewing 15 posts - 7,996 through 8,010 (of 9,244 total)
if you're referring to SQL server resources then no, set up should do all that for you?
May 1, 2010 at 5:00 am
check the event logs and post back the error message produced when trying to start the service. Most likely the log is corrupt so will need restoring or resetting!
May 1, 2010 at 4:58 am
Maninder S. (4/30/2010)
you can even do something like this:SELECT 'GRANT SELECT ON '+quotename(table_name)+' to '+'Maninder' FROM Information_Schema.Tables
WHERE Table_Type='BASE TABLE'
don't forget to include the schema and use
SELECT'GRANT SELECT ON [' +...
April 30, 2010 at 1:45 pm
Ratheesh.K.Nair (4/30/2010)
no use perry ..its still the same.
sorry, yes on the 2008 sql instance builtin admins group is no longer provisioned into sql server, but on the sql 2005 instance...
April 30, 2010 at 1:36 pm
Brandie Tarvin (4/30/2010)
manoj2001 (7/9/2009)
enterprise manager and create and register new instance by giving name...
April 30, 2010 at 1:32 pm
AppemanKotze (4/30/2010)
I have a different problem. When i run the installer again i never get an option for creating a new instance. (i'm installing entaprise edition)
what do you see when...
April 30, 2010 at 4:08 am
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
Viewing 15 posts - 7,996 through 8,010 (of 9,244 total)