I liked the article on MS getting slapped too. Just goes to show no matter what there will be those openings for attack. The only thing thou is not keeping...

I will say thou, from the C++ standpoint that no matter how much you think you have things covered there is generally a bug somewhere you missed. Unfortunately large scale...

Yes, sorry I didn't see enough detail myself either to offer good offhand improvements either. And I agree with Scorpion in that even thou the tools do a great job...

It expands in temp then moves file to destination.

Instead of this

select @RegNumber = RegistrationKey

from dbo.zMaster

with (HOLDLOCK)

update dbo.zMaster

set RegistrationKey = @RegNumber + 1

do

update dbo.zMaster

set @RegNumber = RegistrationKey, RegistrationKey = RegistrationKey + 1

which you are allowed to do. What this...

Sounds like the application suffered a break during the upgrade. Might try reinstall of the SP to see if corrects.

Have you ran DBCC CHECKDB to check the databasde integrity?

My first comment is yes. My second is that many companies have large scale roll outs or production systems without a good recovery structure. What tends to happen is they...

Are we talking a batch file here or something else?

Please do not cross post. This was my answer in your other post.

Have you tried using NT Auth instead? Also, make sure all external connections are gone. Best way is...

Please do not cross post. See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=9563&FORUM_ID=48&CAT_ID=1&Topic_Title=Installing+Win2K+SP3&Forum_Title=Service+Packs for posted responses.

Edited by - antares686 on 01/27/2003 3:33:49 PM

1) Each connection can create it's own copy of a temp table that is referenced with #tblname. Those with ##tblname will be available to all connections until the last one...

Here are the details

http://support.microsoft.com/default.aspx?scid=kb;en-us;281574

But even then you are talking a dictionary or brute force crack. The values are encrypted against reading so at this point no one has found the exact decypting algorithum.

...

You might also try using the current SQL standard format. That is the old way and not sure how they behave differently exactly yet.

SELECT * FROM Table1 INNER JOIN Table2...