GilaMonster (11/9/2011)

---

Haven't you forgotten the old saying - 'Those...

Nothing else to say. There was a page split and the data moved while you were reading the data. That's a fatal error where you'd need to rerun...

Am I the only 1 who wants to answer... if you don't know that, then why are you teaching this stuff??

http://www.sqlservercentral.com/Forums/Topic1202806-150-1.aspx

GilaMonster (11/9/2011)

---

I'm resisting the urge to say something that would get me into trouble... 😀

It's not like being a super mvp and MCM...

Ya but what does he know???

He only coded the whole thing and been working for 20+ years in sql server. It's not like being a super mvp and MCM...

Maddy...! (11/9/2011)

---

I have tried resotring to the qa envirnment with qa file paths and in the error it is showing the location of the dv environment file paths....

and I...

Go to the folder and see if the files already exists. Try deleting the db (assuming you can), then manually check that nothing is left of it before trying...

http://stackoverflow.com/questions/972616/string-aggregation-in-ssrs-2005

mbender (11/9/2011)

---

I did the shrink and everything looks good. It was a runaway query that i'm hoping i learned my lesson. I appreciate all your help. Thank...

MyDoggieJessie (11/8/2011)

---

Understood Jeff, but if there will be queries like that running again (safe to say that it will happen again) then wouldn't it be considered a good practice to...

MasterDB (11/8/2011)

---

I dont know whether job is saved or not?

but in the Agent properties history has been set to 10000 rows and for each job 1000 rows.

this job runs more...

BOOya

Once the ram has been used by the server, it won't release it.

That's the way it's supposed to happen.

Please don't crosspost, it fragments replies and wastes everyone's time.

Forward discussion here please => http://www.sqlservercentral.com/Forums/Topic1202315-391-1.aspx#bm1202332

Just use the restore command and put that in a job. Nothing special here.