Yes write out all the steps befoe you start into a checklist. Review it with others who will be involved. Then establish rough times you expect to be at each...

I tried this previously with a 5,000,000 plus row table and saw no issue. I have since gotten rid of that DB so have no real details beyond before and...

You are aware you can restore the system databases from backup. The only thing is that you cannot restore a 7 system DB to 2000. Since you need to do...

Create a DTS package and use Active Scripting in the package to build the Excel file with the right name. Then using ADO populate it from the data source.

There was...

Transactional works just fine as long as the time before require resync is not met. I loose connections to or DR site occasionally for brief periods and replication will bark....

Check out all the KB articles here http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=&KeywordType=ALL&Titles=false&numDays=&maxResults=25&withinResults=&Queryl=Invalid+Descriptor+Index&Query=Invalid+Descriptor+Index&QuerySource=gsfxSearch_Query

Apply the latest SP. There is a note on a particular driver being the issue so if you know it will not adversly...

Public has to have rights to most of the information it hits for connections to work. If you are concerned with security check out the checklist at http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

I see you...

The best SQL security related site is http://www.sqlsecurity.com/ . They have lots of information, current articles, links to other sites, links to applications. Another good one is AppDetective which I...

quote:

---

So Antares686,

what does the /3GB do?

what switches do you suggest for 8GB RAM?

---

From BOL...

It can mean various things. I have a small DB here and can't really test based on transactions that well. However, if I stop the server the files modified dates...

Just out of curiosity since I do have a server I may be increasing the memory on soon. Do you have any supporting documentation or benchmarks to show this?

Thanks

SQL will be able to take up to 7GB of physical RAM, but if the OS deems an issue warrants taking memory away it always can. If you have SQL...

If the problem started with MDAC 2.7 you will need to reinstall OS to revision back to 2.5 sp1 then SQL and the databases. Have you test on another server...

I too prefer the clean install. The reason is when you do an upgrade there are files that just get left behind that have no use at all. Even just...

Ahh, I see my error. Try this instead.

select a.*

from loadinfo a

inner join

(SELECT agencycode from loadinfo

group by AgencyCode

having count(DISTINCT DestState) + count(DISTINCT DestCity) > 2) b

on a.AgencyCode = b.AgencyCode