Viewing 15 posts - 2,371 through 2,385 (of 7,502 total)
I would suggest to use a condition like:
if exists (select D.name, B.type as BU_Type, B.backup_finish_date
from master.sys.databases D
left join ( select *
, rank() over ( partition by database_name, type order by...
February 5, 2011 at 7:09 am
another help can be found in your default trace files.
/*
* Import Default Trace
*/
/*
* read SQL default trace file name
*/
SET nocount ON
declare @wrkTraceFilename nvarchar(500)
-- read trace info
...
February 5, 2011 at 6:21 am
avoid using sp_start_job ....
have a look at:
http://www.sqlservercentral.com/scripts/Miscellaneous/31032/
February 5, 2011 at 6:15 am
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
Viewing 15 posts - 2,371 through 2,385 (of 7,502 total)