The only issue with the latter (3rd party tools) is that the transaction log has to remain instact to see this. You could use syscolumns and other systables to copy...

Overall Andy's is the easiest and does exactly what you are stating. Date values are implicit within SQL anyway as long as the format is right, you do not have...

Not sure of anything specific to do that in general but for your case you can do

SELECT * FROM tblX WHERE COLEMAIL LIKE '%@%@%'

Just be aware it may take a...

Could be however I don't believe so as it should have looked for MSDE only and I am pretty sure no MSDE updates are included in the Office SP as...

I will test and see what I get here.

Unfortunately mromm is right. I went thru this for quite a while with our Oracle servers. Better indexing on there side and writting cleaner code on our side solved this...

Is it a unique constraint or is it a primary key also. If the later check out this from BOL

quote:

---

UNIQUE constraints can...

Let us know if you get more space and things do not change. I have a 52GB drive array and the problems started for me under when I got under...

They sound like the internal processes. Are the spids below 10. If so I ran into a similar issue recently where the drive space was been filled and then I...

I concurr with Scorpion. The problem with sysindexes and the data there is it is updated via sp_updatestats or by having Auto Update Statistics turned on for the DB. The...

Faster processors do not always mean faster performance. The first bottleneck is from the Hard Drive to the CPU across the motherboard so make sure the motherboard itself has large...

I have had no issues. You obviously are missing something somewhere. However, I would suggest if you use any version of Oracle later than 7 do not use the MS...

There is a file that is stored with the Excel spreadsheet that retains that data you can edit in notepad. Sorry I forget the name but it is referenced somewhere....

That is a great article but keep in mind there are all kinds of data in the actual storage, especially when involving varchars that help the server find the start...

Unfortunately I have been stuck in the C++ world for the last year and never got to use anything in that realm so I cannot answer.