Viewing 15 posts - 8,956 through 8,970 (of 9,241 total)
Brad (8/25/2008)
HI Perry,Thanks a lot. WHere do I find these roles?
Regards,
Brad
the roles are in the MSDB for that instance. Edit a sql users mapping and under MSDB you'll see the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:07 am
are you sure you want to drop all indexes?
you have the scripts to re create them?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:02 am
Lynn Pettis (8/25/2008)
why the joins, group bys, and having count(*) >
the group by would be required for the count function i think
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 2:11 pm
marius.draganescu (8/25/2008)
It looks like this is it!! It is working...
can you recommend a book/ website/ anything else I could use to learn the more complex TSQL from? I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 2:04 pm
whether you step through each index or grab the database name and rebuild all its indexes it'll take the same amount of time. I would use a cursor to grab...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 1:59 pm
how many nodes\sql instances are in the cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 1:54 pm
ensure users are mapped to one of the MSDB standard DTS roles
db_dtsadmin, db_dtsltduser, and db_dtsoperator
or create and assign a custom role. Users need to have correct permissions to execute...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 9:39 am
marius.draganescu (8/23/2008)
I will try this out Monday and I will let you know how it works. Many thanks!!!
no problem, table aliasing also helps to compact\tidy your code a little (dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 4:35 am
you could use IPSec to secure communication between the 2 machines
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 3:56 am
are these packages stored in the MSDB database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 3:54 am
sql 2005 enterprise can only be installed to appropriate server operating system. For Vista\XP you will need developer or express edition
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2008 at 3:53 am
marius.draganescu (8/22/2008)
Duck ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2008 at 6:08 am
hengert (8/20/2008)
I used "1/1/1900", maybe it only accepts single quotes then. I'll give it a try. Thanks.
yes you need to use single quotes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2008 at 9:52 am
unikhath (8/22/2008)
Yes, I'm installing Developer edition on my machine for development and using Enterprise edition on the clients site during production.Thanks for the help.
should be just fine
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2008 at 9:50 am
probably need to clarify a little further what you are intending to do
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2008 at 9:49 am
Viewing 15 posts - 8,956 through 8,970 (of 9,241 total)