Viewing 15 posts - 781 through 795 (of 859 total)
I think you are on the right track. get your update query written with the join then as you suggested update X number of records at a time till...
March 26, 2012 at 1:33 pm
he might need both depending on what he is trying to accomplish. if he is using xp_commandshell to interact with the OS then he will most likely also need...
March 26, 2012 at 11:33 am
patrickmcginnis59 (3/26/2012)
Abdul Walele (3/26/2012)
permission should be granted to users on the server level so that they can have the ability to create sql jobs and schedule them?
http://msdn.microsoft.com/en-us/library/ms187901.aspx looks to be...
March 26, 2012 at 10:55 am
Brandie Tarvin (3/23/2012)
Sounds to me like the OP decided it was a PEBKAC error.
sure it was a PEBKAC error? i have found those are a little less common than...
March 23, 2012 at 3:32 pm
eforta.it (3/22/2012)
Me again 🙂I don't think you can buy 2012 licence and run 2008 R2 instead...
i would agree. if you buy 2012 but do not install make sure...
March 22, 2012 at 8:20 pm
hbtkp (3/22/2012)
i got the solution
you have some curious helpers. what was dont to fix the issue??
March 22, 2012 at 7:00 pm
you need to head to the other thread since its an exact copy of this post. posting again will only tick people off and cause them to not help....
March 22, 2012 at 6:57 pm
Sean Lange (3/22/2012)
capn.hector (3/22/2012)
Sean Lange (3/22/2012)
Even better, don't use loops. :hehe:i was waiting for that one. :w00t:
Somebody had to say it...and I was kind of surprised that neither Eugene...
March 22, 2012 at 3:01 pm
Sean Lange (3/22/2012)
Even better, don't use loops. :hehe:
i was waiting for that one. :w00t:
March 22, 2012 at 2:23 pm
the only 2 ways i know of to reclame space is shrink the database and shrink the file. both of which fragment the indexes. if you rebuild the...
March 22, 2012 at 2:16 pm
ames.f (3/22/2012)
for the Scheduled jobs, it is a single job with Dynamic SQL for each database or do you have seperate Stored procedures for each production database?
we use a separate...
March 22, 2012 at 1:46 pm
is this for homework or an interview? kinda sounds more like homework
can you post the table DDL for the tables you are trying to match up? Please see...
March 22, 2012 at 1:39 pm
Lowell (3/22/2012)
cross-database data migration does not belong in a trigger.
an outside process could error out, but the...
March 22, 2012 at 1:26 pm
as long as you continue to license the 2008 r2 you continue to use until you upgrade i don't see a problem. also check if there is a time...
March 22, 2012 at 9:10 am
GSquared (3/21/2012)
Any particular reason this has to be done via stored procedures? SSIS would be easier.
id agree that ssis would be easier. as far as Book3 giving you...
March 21, 2012 at 12:49 pm
Viewing 15 posts - 781 through 795 (of 859 total)