IPSec policy as well. You can set a policy on the SQL Server to specifically block that IP. Defense in depth. That way if a configuration change happens on the firewall and suddenly allows connections inbound, you've still got the IP blocked at the server.
2004-08-04
try to install SP3a on serverand install MDAC 2.7 SP1 on both clients and server machines .. and this may solve most of your problems
2004-07-11
If you could add an identity column, this query would be simple. select * from table as t1 join table as t2 on t1.id = t2.id + 1dw
2004-06-29
I have a need to use the system tables to create a sql script for the indexes defined for a table. I cannot figure out how to tell whether the index id defined as unique or not from the system tables.TIA for any help here.
2004-06-28
71 reads
2004-06-27
I'm trying to run a sequence of stored procs using DMO from a VB program, and I want to log the output of all PRINT statements in the stored procs as well as any SQL error messages they might generate, a la Query Analyzer. The ExecuteWithResultsAndMessages method of the SQL DMO server object returns errors […]
2004-06-24
6 reads
Not sure what exactly you are looking for. Are you looking for who or what caused the updates? If so, I don't believe the tools mentioned above will tell you who/what made the changes.If your just looking for when the changes were made then maybe you could restore the database somewhere else and then the […]
2004-02-18
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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