Have to ask, why?

Ran sp_databases and sp_helpdb on one of our servers here, didn't get a discrepency after converting to the same unit of measure. I am at a loss for the...

Are you using native SQL Server backups or are you running a third party backup application (LiteSpeed, et. al.)?

steve-lauzon (9/22/2011)

---

Thanks guys

We have one server with 2 installations (instance). Both instance are on the same physical disk

8GB or memory with basic installation. We didn't change anything on...

Yes, Lowell is correct. The other part of the issue can be memory. I'm looking at this as if you have two instances of SQL Server installed on...

Are the databases for both instances on the same set of disks or are they on separate spindles? If the first, that could easily be part of the problem.

I wouldn't classify this as a problem, more like an issue between two different reporting processes. Without understanding how sp_database reports space/size, we just aren't in a position to...

You may want to search this site for other delimited split functions. In fact, you might find this article[/url] quite interesting. As you are looking at spliting an...

Also in Books Online read about Service Broker. This would eliminate the need the need for a scheduled job and still have the processing of emails completed asyncronously (sp...

The trigger could populate a queue table that is then processed by a scheduled job. This would eliminate the trigger from directly sending the emails and it eliminates writing...

I'd like to suggest some reading, Books online. Specifically read about Database Mail. You can setup a trigger that can send emails. This is where I would...

We are still shooting in the dark. Everything we are asking you to provide is really needed in order to help you. Please helps us help you.

We can't see what you see. Provide the info Gail asked for if you really want our help. Else wise all you are going to get are wild...

Ninja's_RGR'us (9/18/2011)

---

Lynn Pettis (9/18/2011)

---

bitbucket-25253 (9/17/2011)

---

Ninja's_RGR'us (9/17/2011)

---

Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.

Now all I know about Oracle is...

bitbucket-25253 (9/17/2011)

---

Ninja's_RGR'us (9/17/2011)

---

Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.

Now all I know about Oracle is how to speel...