Hi hawg, subscribing to MS security alerts is a starting point I also use. Further I keep my eyes open while joining forums like this one. There are also mailinglist from websites like http://www.securityfocus.com or alike. This has proven to work fine, but I doubt you can write this down in some kind of company […]
2003-06-03
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-26
And the test shouldn't be changed to make the UDP more obvious. Good Security is never obvious or easy...it takes work and paying attention to detail, which is what I forgot to do. -SQLBill
2003-05-22
gts31 was not only upgrade MDAC, but also installed SQL Server 2000 client tools that is used by DTS in his machine too. Higher version of MDAC is supposed to be backward compatible to the low version but it is not true always. I have seen some old applications that use old MDAC do not […]
2003-05-20
quote: As client machine, you can have higher version of MDAC and be able to perform anything as before. Is the above really true? If so, it would seem that gts31 would have no problem. But since he observed a problem, it implies that this may not be entirely correct. Or maybe I'm misunderstanding the […]
2003-05-19
I think your unstanding about Implicit transactions is correct. From BOL. "Implicit transactions A new transaction is implicitly started when the prior transaction completes, but each transaction is explicitly completed with a COMMIT or ROLLBACK statement." You do nothing to delineate the start of a transaction, you only commit or roll back each transaction. Implicit […]
2003-05-16
1 reads
Reading through my old MS notes from SQL 6.5 days it appears that running UPDATE STATISTICS on a table will recreate all distribution statistics within an index. Moving forward to SQL7/2000 this will also update distribution statistics built using CREATE STATISTICS. Although there is a database option to auto update statistics (defaults to on) there […]
2003-05-16
Ok, one last question...how do I know which DTS designer I am using? I can find versions anywhere. What happened was I had installed the trial version of SQL Server 2000 and it must have replaced my tools with 2000 tools. I am running a SQL 7 only shop right now and need to get […]
2003-05-15
One thing you must also make sure of is that you clean up your recordset objects at the end of the page, ie "Set recordset = nothing"...
2003-05-13
when you installed SS2K was tcp/ip and named pipes enabled/selected?
2003-05-12
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers