2016-10-20
1,123 reads
2016-10-20
1,123 reads
SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.
2013-11-08 (first published: 2009-03-09)
35,905 reads
One of the things you need to aware of is that if you create a logon trigger and there is some bad code you are going to prevent everyone from logging into your SQL Server, even if you try as "sa" or a member of the sysadmin fixed server role. How do I log on to my SQL Server to fix this trigger?
2008-12-02
3,887 reads
Our ERP accept only sql statments for reporting.(I can write select ... but I can not Write Exec Store_Procedure) .I Want to execute a Store Procedure in a select statment.
2004-11-22
2003-06-11
1 reads
DBCC INPUTBUFFER(spid) This only gets the first 255 characters of the command. SP3 introduced the fn_get_sql function (see the updated SP3 BOL for details), which returns the information in a text column.
2003-06-05
2 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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