Viewing 15 posts - 871 through 885 (of 6,105 total)
No. And keep in mind that this logon trigger is only going to fire when they first connect. Once they are in SQL Server, you can't prevent them from changing...
October 19, 2008 at 10:27 pm
Parthipan (10/19/2008)
Is there anyway to store DHCP log file in SQL server database and the procedure for automating it?
Yes, but you're going to have to parse it using a script...
October 19, 2008 at 10:23 pm
You need to track down what's trying to connect with that account. You could run a Profiler or server side trace with auditing login failures. Make sure you've got the...
October 18, 2008 at 11:00 pm
If you mean logging on to the SQL Server, you'll want to turn Audit Failures on. Whenever there is a login failure, it'll get written to both the SQL Server...
October 18, 2008 at 10:58 pm
On SQL Server 2005/2008 you can query sys.database_permissions to see who has the WITH GRANT option. The state field is what you're looking to filter on. If the value is...
October 18, 2008 at 10:56 pm
My organization has been through hard financial times before in the 80s when farms were going under like crazy. Those almost led to the end of the other regional lending...
October 18, 2008 at 2:29 pm
You're talking about being near enough to attend home games for the Broncos. Hmmm, I grew up loving the Broncos (though I have no connection to Denver). 🙂
October 16, 2008 at 1:27 am
Jerry Hung (10/9/2008)
I liked the product too, well enough to do a survey with Clair and David
The price tag did surprise me a...
October 9, 2008 at 10:48 am
Windows authentication requires both the SQL Server and the connecting client to be either in the same domain or in trusted domains. If you're getting "Login failed for user (null)"...
October 5, 2008 at 6:24 am
Do you have any applications installed that would try to talk to SQL Server? Especially any apps running as Network Service? A typical culprit is a web application, like SQL...
October 5, 2008 at 6:18 am
If you're speaking of what's considered an operational DBA, there are a few basics:
Backup / Restore:
- Understand the backup / restore options SQL Server provides for you.
- Implement those on...
October 4, 2008 at 7:40 pm
When a cluster failover happens, what the cluster does is the following:
- Stops all services dependent on SQL Server
- Stops SQL Server
- Stops the IP and Network name resources
- Stops...
September 11, 2008 at 12:27 pm
knash (9/11/2008)
September 11, 2008 at 12:22 pm
Well, that rules out a network or SQL Server issue. That would point to the application... not sure where you go from here if Symantec support is stuck.
August 18, 2008 at 1:58 pm
Whole disk encryption for workstations... Vista has BitLocker. 3rd party leaders include PointSec & Safeboot. There are a few others in that space, but it's been a while since I've...
August 18, 2008 at 1:56 pm
Viewing 15 posts - 871 through 885 (of 6,105 total)