Viewing 15 posts - 8,956 through 8,970 (of 9,244 total)
Fishbarnriots (8/26/2008)
The file looks like a complete dogs dinner
my my, as tasty as that 😀 :Whistling:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:15 am
rdavid (8/26/2008)
If I define the input parameter to the stored procedure as nvarchar (which is what I would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:13 am
Lynn Pettis (8/25/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:10 am
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
Viewing 15 posts - 8,956 through 8,970 (of 9,244 total)