there must be a setting somewhere for the difference between the time saved and the "real" local time.

SELECT DATEADD(hh, -2, GETDATE())

golden-1131024 (5/5/2011)

---

yes, i have deleted the job..

after that i did create new maintenance plan for DB full backup and log backup,the two new jobs (generated from MP) are working fine...

I've never seem this particular behavior.

I've seen groupinigs work slightly differently so yes this is definitely possible.

Can you post a screenshot of the 2 action setups you have for the...

Please do not cross-post. we monitor all forums equally.

Continue the discussion here :

http://www.sqlservercentral.com/Forums/Topic1103856-1633-1.aspx

2pm est? Are you sur it's not 4 pm est?

Something like that :

SELECT CONVERT(VARCHAR(25), CAST('2011-05-05 16:00:00' AS DATETIME), 109)

Jeff Moden (5/5/2011)

---

I don't know much about how you pass things (ie: variables, etc) to reports in SSRS but it seems to me that you'd only need to include a...

Any open tran on those tables that are not getting commited. God knows I locked myself out so many times I can't count that high.

Brandie Tarvin (5/5/2011)

---

Most people I meet assume DBA means "Doing Business As" and invariably ask "Doing business as what?"

I'm going to start responding with "A janitor for programmers."

Honestly, with...

sqlnaive (5/5/2011)

---

Definitely not and i'm having problems. Scratched my head a lotz. There I can see index seek in the execution plan. Still its slow. What can be the possibilities...

sqlnaive (5/5/2011)

---

Is around 50 seconds good time to insert around 2500000 records to a physical table A from another table B with 8000000 records ? There are just 8 columns...

pramod_yg (5/5/2011)

---

That means that a code that worked well in 2000 can go haywire in 2008. What makes it happen so?? is it the engine? so, it is not some...

kaps.manshani (5/4/2011)

---

Ninja's_RGR'us (5/4/2011)

---

Expect to be minimal.

Install a trial version and test the migration process. Unless you are using depreciated function you should be fine.

That's where upgrade advisor...

Well there's your answer...

do you have the option to export and send via e-mail? With a little work you'd just have to export the file and change the html...

Same thing here. AFAIK there's little to no events in the code of SSRS. Assuming they don't exists you're stuck going to asp.net to do a hover class....

You can't event do select into #tmp?