Viewing 15 posts - 8,011 through 8,025 (of 9,241 total)
Hey, no problem. Remember also, only use EXECUTE AS if you want to inherit permissions from another database user!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 5:51 am
as the link details the workaround is to un install the mismatched features
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2010 at 3:26 pm
i too, use the RSS tool. Easiest way to migrate
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2010 at 3:15 pm
has this server been renamed at some point?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2010 at 2:33 pm
download and read the whitepaper
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2010 at 3:17 am
yes, it is.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 4:46 pm
sqlguy-549681 (4/24/2010)
you mean i will re-write 500 DTS again !!!!!!!!!!!!!!!!!!!!!!!!!!!!
if they wont convert then yes!! Look at this way, your job should be safe for sometime 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 3:58 pm
Guys, you get the message 'Current SKU is invalid' because of the licence key.
When you get to the part of node 2 install where you see the licence key, delete...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 3:51 pm
Table\index partitioning is exactly what it says. Within this there are 2 methods of partitioning
Horizontal partitioning - rows are separated into partitions
Vertical partitioning - columns are separated out into partitions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 3:48 pm
if the database is in Simple recovery the log will truncate on checkpoint, also the alter index is minimally logged so this should not need log file modifications
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 1:02 pm
Bhuvnesh (4/24/2010)
ORShrink the transaction log file
to effectively shrink the log file you will need to back it up first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 10:55 am
halifaxdal (4/23/2010)
It seems the bracket is causing the problem, I took away the [], now this issue went away.Thanks for replying.
then the error wasnt network related or instance specific was...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 9:46 am
varshachyk (4/24/2010)
on one of our server Re-build index job is failing with the below error. Please suggest.
Failed: (-1073548784) Executing the query "ALTER INDEX [PPS_USER_SESSION_COOKIE] ON [dbo].[abc] REBUILD WITH (...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 9:29 am
Viewing 15 posts - 8,011 through 8,025 (of 9,241 total)