I'm wondering why you would want to create multiple users with the same login what keeps popping up in my mind is that you're trying to reduce the work required...

I normally use SQL Profiler when I want to find out what is running.

Having multiple datafiles where the files are of different physical disks can improve the speed of data reads and writes since the data can be read from the different drives...

It's normal for an active SQL server to grab as much memory as you allow it to grab, especially if there are no other applications asking for memory on that...

DMC,

If you using a "good" SAN then some form of SAN mirroring should be possible, but may not be possible when SQL Server is active. You're likely to run...

Charles, I just had a sort of funny thought. If you go ahead with was said in here, or use tempdb, you might want to recommend to the...

Charles, one thing to watch out for. The new table you're talking about adding to the Model database would not only be added to tempdb on reboot, but it...

Don't feel bad David. You're not alone in this boat.

hmmmm ...... is it your turn to row?

K. Brian Kelley (8/1/2008)

---

Alvin Ramard (8/1/2008)

---

One thing to think about ....

If you have separate tables for each product, what happens if they add a product? Someone needs to add...

One thing to think about ....

If you have separate tables for each product, what happens if they add a product? Someone needs to add at least one a new...

I can't help but wonder if the view definition looks something like:

create view vwProviderDirectoryReportWithAllServiceLocations

as

Select *

From

ProviderDirectoryReportWithAllServiceLocations

end

I would use a "For Loop Container" with a Script Task as the first step in that container. On the first pass, the script task would retrieve the list...

I'm sorry abinder but I think you're not considering a very important point.

It would not be appropriate for SQL to change the data type of the answer unless it was...

The correct answer was returned with the error message but exceeded the maximum value allowed for that data type. That is why the result had to be an error.

I prefer the (Where LEN(isnull(Message, '')) > 0) method.