shot in the dark since the thread is a couple years old, could you post the link to the connect ticket so that we may vote on it?

Also an updated...

I like the comment idea. I personnally put those in prints so that I can follow along as the script executes. Also you have more logged info when...

You'll get the same error if the server is restarted or if someone killed your SPID.

I've never hit a bug with this, but I'd certainly check the KB posted earlier.

Are...

I don't understand what you are doing.

In all the erps I've ever worked with balance is never saved. It's always recalculated on the fly.

If you want to keep it...

Gordon Pollokoff (5/3/2011)

---

1. To clarify some points, the restore is from the local server drive. The drive is SAN storage connected via a 2GB fiber optic connection.

2. ...

2 GB connection... ya but what I've seen was the windows "network" connection to the san had dropped from 1Gb to 100 or 10 MB and the information just couldn't...

The real answer is simple : does it work? That implies you must have requirements and tested that you can restore the files (which I do on all my...

Ah, another reason to NOT post 1-2 mb bmp attachements... Gail would have spotted those if she had opened the files!

Either your disks are getting trashed doing something else or maybe the network is down to 100 mbps rather than 1gbps for some weird reason (assuming you restore from network...

I'm all in :hehe:.

sachnam (5/2/2011)

---

boris.kovalcik (5/2/2011)

---

Hi all,

I have problem with database size. I have one database about 330GB(4 datafiles + 2 logfiles). I archived a lot of old records to archive database and...

Pls post the actual query so we can help. This is clearly not what you are running.

30 people watching this thread and no answer... not normal.

can you post the exact expected answer from your sample data?

Also how much data to do you have in that table...

Well maybe I'm missing something but what's the point of returning 12M + rows to anything?

I'd understand the left join if you wanted to find unactive users. But with...

You need to readup on the subject.

Read up on grant and deny in books online. Everything you need is there.