Viewing 15 posts - 2,296 through 2,310 (of 2,647 total)
Sheila.Roscoe (10/26/2011)
just fyi...this is a virtual server. We have another virtual server, same version of SQL, and the jobs have been running fine since creation of the jobs.
Have you...
October 26, 2011 at 9:42 am
Steve Jones - SSC Editor (10/26/2011)
The problem is that you cannot do the division in the same way as...
October 26, 2011 at 9:30 am
Kenneth Fisher-475792 (10/26/2011)
October 26, 2011 at 9:23 am
o you have a fixed number of channels? I don't see a channelId or something to identify which channel is feeding the data. If it is fixed, you can...
October 26, 2011 at 9:13 am
So, you have something similar to a running total. Anyone thinking pseudo-cursor and quirky update?
Jared
October 26, 2011 at 9:09 am
rodmeans (10/26/2011)
The column in the non cluster index is a varchar(255) and new rows are getting inserted roughly ever couple of minutes.
Do you know offhand what the typical actual length...
October 26, 2011 at 9:07 am
Also, if you are just backing up dbs and tlogs, I find a stored proc or script within a job is much easier to maintain versus a package created by...
October 26, 2011 at 9:06 am
If all else fails... Recreate the maintenance plan, delete the old one, and reschedule. Sometimes SQL can be quirky 🙂
Jared
October 26, 2011 at 9:04 am
So... Once the job is open, you are clicking on schedules, highlighting the schedule, then clicking edit. Schedule type is "recurring" and the enabled box is checked? Then... Occurs Daily...
October 26, 2011 at 8:57 am
Sheila.Roscoe (10/26/2011)
yes, I did use the wizard to create the plans.
Are you changing the run times through the maintenance plan or directly through the job? I am asking so I...
October 26, 2011 at 8:49 am
Whoa... Can you give me some context or business rules? I don't quite understand what is being multiplied and divided...
Thanks,
Jared
October 26, 2011 at 8:48 am
When you say that you set up maintenance plans, I assume you are referring to the wizard?
Jared
October 26, 2011 at 8:34 am
I have a stored procedure that moves all of the data from the application tables into a data warehouse table. This is a nightly job, but you can set it...
October 26, 2011 at 8:32 am
When SQL Server performs a backup, or any 3rd party does, it does specific things to SQL Server and the mdf file (also the log file). Thinks like checkpoints,...
October 25, 2011 at 7:46 pm
Trey Staker (10/25/2011)
That worked Thanks!The weird thing is that via an ADO connection in crystal it works without granting view definition, That part still confuses me.
I just took a...
October 25, 2011 at 3:34 pm
Viewing 15 posts - 2,296 through 2,310 (of 2,647 total)