Viewing 15 posts - 8,011 through 8,025 (of 9,244 total)
you normally need to set DCOM permissions, have you done this yet
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"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
Viewing 15 posts - 8,011 through 8,025 (of 9,244 total)