Viewing 15 posts - 7,426 through 7,440 (of 9,241 total)
Public is already an inherited role for all users. Try the following
exec sp_msforeachdb 'use [?];
create user [domain\user];
exec sp_addrolemember ''db_backupoperator'', ''domain\user'';
exec sp_addrolemember ''db_denydatareader'', ''domain\user'';'
Ignore output messages indicating the database user...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 10:16 am
yes!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 9:43 am
smitty-1088185 (11/3/2010)
How do you automatically give the Database level permissions to any new databases created by another team?
add them to the model database on that instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 9:32 am
HoustonFirefox (11/1/2010)
I admire and learn a great deal from my collegues here and respect everyones point of view.
Ha ha, pull your tongue out of his backside will you :Whistling:
Making...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 9:18 am
WayneS (11/2/2010)
We're having an outage this weekend when we're upgrading to SQL 2008... I plan on using this time to do this.
Good luck with the upgrade Wayne, be interesting to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 9:08 am
From BOL
To enable log shipping
➡ Initialize the secondary database by restoring a full backup of the primary database on the secondary server.
➡ On the primary server, execute sp_add_log_shipping_primary_database to add...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 9:04 am
chris.s.powell (11/2/2010)
As for the rebuild index, it will be recorded in the log file, with a proper backup plan in place, that space will be freed after it is completed.
I'm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 8:35 am
chris.s.powell (11/2/2010)
please make sure you rebuild your indexes and statistics when this is completed!!!!
Problem is, this just causes the database to grow again!! All that I\O to shrink is now...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 8:11 am
Kimberley Tripp
Wait for an inactive time of day (ideally, it would be best to put the database into single user mode first)
It's important to note that Kimberley merely advises that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 8:03 am
sais
please post the results of the following query executed against your database
select[FileSizeMB] = convert(numeric(10,2)
, round(a.size/128.,2))
, [UsedSpaceMB] = convert(numeric(10,2)
, round(fileproperty( a.name,'SpaceUsed')/128.,2))
, [UnusedSpaceMB] = convert(numeric(10,2)
, round((a.size-fileproperty( a.name,'SpaceUsed'))/128.,2))
, [DBFileName] = a.name
from sysfiles a
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 7:56 am
danfugett (11/1/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 7:38 am
does the report use an embedded data source or separate SSRS stored data source? How is this data source configured?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 5:54 am
SqlN00bie (11/1/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 5:48 am
Parthi
see the attachment below for my instructions on how to configure an SSRS 2008 instance
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2010 at 3:14 pm
have you checked the local administrators group on the server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2010 at 10:50 am
Viewing 15 posts - 7,426 through 7,440 (of 9,241 total)