Viewing 15 posts - 2,371 through 2,385 (of 7,498 total)
don't do that with a CLR proc !!
Just schedule a sqlagent job that sends a sp_dbmail when it finds rows.
if exists (select * from yourdb.yourschema.yourtable)
begin
declare @subject varchar(1000)
set @subject = @@servername...
February 5, 2011 at 6:13 am
chris.s.powell (2/4/2011)
February 4, 2011 at 2:40 pm
Steve Jones - SSC Editor (2/3/2011)
Greg Edwards-268690 (2/3/2011)
U R RIT to DLT
Nooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
as shown ... threadzines are agile :w00t::hehe:
February 3, 2011 at 2:51 pm
Jeff Moden (2/3/2011)
GilaMonster (2/3/2011)
Tom Brown (2/3/2011)
February 3, 2011 at 10:49 am
did you try "grant view definition to ;" in the correct database ?
February 2, 2011 at 2:07 pm
Indeed, that's the way it should be.
There shouldn't be a need to alter a service account because of an application behaviour.
IMO that would mean their app needs sysadmin, which is...
February 2, 2011 at 1:57 pm
figuring out when the user was deleted will be a hard job.
Regarding when a user has been added to a database:
maybe this query can help out.
use yourdb
select *
from sysusers...
February 2, 2011 at 12:06 pm
Did they provide any reason for their modification of a service account ?
This is actually one of the ways many devs / app managers abuse their given authority and break...
February 2, 2011 at 12:02 pm
If this is a presentation issue, it should be taken care of by you presentation layer.
With regard to sqlserver, keep the original data type as long as possible.
As by your...
February 2, 2011 at 6:10 am
- Are you sure it is using the correct files for master db ?
It is very strange your tempdb drive has never been there for sqlserver.
How would it have used...
February 2, 2011 at 4:56 am
Steve Jones - SSC Editor (2/1/2011)
February 2, 2011 at 1:53 am
Gail has published a wonderful article at ssc concerning your Q.
February 1, 2011 at 3:25 pm
I still have the darn pegions 😀
The birds are getting old, way to old to make a good soup:hehe:
February 1, 2011 at 3:22 pm
sqlindia (1/31/2011)
Shall we replace rank() over function with T-SQL (or any other way)?
I mean this line select AgentID,DT,AgentStatus,TeamID
, rank()...
February 1, 2011 at 12:53 am
If you want more info about the failed login itself, you can implement an event notification for failed logins.
(see attachement)
That provides interesting information.
At instance level we have enabled "failed login...
February 1, 2011 at 12:05 am
Viewing 15 posts - 2,371 through 2,385 (of 7,498 total)