Search results for query: *

can you help me write one. basically I need to know when job was last time was executed, with fail or susecc, and next run time.

I am trying to create a temp table. What am I doing wrong? insert into #job exec msdb..sp_help_job @job_name='.dba.archive.baks',@job_aspect ='steps'

can I select a spesific fields?

it is some how I can find out programatically job name,schedule time, sucess/fail?

I have the following where clause...Right now it is slow.It is anyway I can speed up by rewriting differently?? and ( b.ID1 = a.ID1 or b.ID2=a.ID2 or (Replicate ('0',11-len(b.ID3)) + b.ID3)=a.ID3) AND ( a.ID1 = @ID or (Replicate ('0',11-len(a.ID3)) + a.ID3)=@ID or a.ID2=@ID)

What is wrong with my query?It will not compile insert into table1 (GID, SID, DateEntered) values ( select GID,SID,getdate() from table2 where GID='1' and SID not in (select SID from table3 where GID='1') )

Does anyone know a good site with examples of bcp dts workflow and error handl?

I mean exec trigger when spesific column updated (for example colum 2). Thanks

Thans it helps. Can I run a triger when spesific column was updated?

I am trying to create a triger for insert. I would like to get id into log table id data was inserted.What am I doing incorrect: if exists (select * from dbo.sysobjects where id = object_id('dbo.mstr_update') and OBJECTPROPERTY(id, 'IsTrigger') = 1) drop trigger dbo.mstr_update GO CREATE...

Is it posible to create a file using a activex script as well as exec sp in activex and save the data into file created by activex? can some one show me the examples?

Here is my code for CDOMail. However when I try to send to attachemnt it will not work (working with one attachment only). Any idea why? CREATE PROCEDURE CDO_SendMail( @From varchar(255) = 'sql@msn.com', @To varchar(255), @Cc varchar(255) = '', @Bcc varchar(255) = '', @Subject...

I have a param @MessageBody varchar(8000). I am assigning some values to the select @MessageBody=select.... It working fine until I the results is only 1 row, however when it is more then one it is taking only top 1 row. What should I do in order to get all rows?

I have the following datetime. 2004-04-21 16:24:36.790 I would like to display as: 20040421162436 How do I do this?

The problem is user is removing the files and they don't exits in a directory I am trying to copy also the file name will be different everytime .

I am trying to copy an .xls file. However when I am using a fso.CopyFile FName, DstFName I need to know the file destination. But in my case I would like to copy a file from one place to other where desctination file is not exists. How do I do this?

I have 7 answers with possible combinations 'Yes' and 'No'. Maybe temp tamp will work? In a temp i will need to have the data store like this: Answer TranID Y Y Y .. 123 can you help me write this?

Not really. I need to display all Yes and No. Not just a sum

I have the following code where I have some subquery. However my subquery return more than 1 row. Is it some how I can put all subquery result in 1 row instead of couple? select Custom1=(select case Answer when 'Yes' then 'Y' else 'N' end + ' ' fromAnswers wa where wa.tranid=wt.TranID )...

Where should I check the permissions?