That's an interesting approach. I've devised a system where i have a table storing job and step id's, recipients, and on_success/on_fail fields and a trigger on sysjobstephistory. Though both ways are effective, your method seems easier to implement, and slightly less dependant on the system tables.
2005-03-01
While calling getdate in UDF i am getting error.. Here is My code ======================if @Enddate> getdate begin select @Enddate= getdate() endError Message ======================Server: Msg 207, Level 16, State 3, Procedure GetMissingPrepaycount, Line 17 Invalid column name 'getdate'. Server: Msg 207, Level 16, State 1, Procedure GetMissingPrepaycount, Line 20 Invalid column name 'getdate'.
2005-02-28
22 reads
The search results are presented in a grid. User can click on 'select all' or 'select none'. I am not sure there is another way of designing the UI. It is a search page and if the user does not enter any search criteria or enters something that eliminates only few users, I have to […]
2005-02-24
well if the procs work.. nothing. SysDepends is used when ou ask sql server to show the object dependencies (spa needs table1,view2 and vice-verca)... but this is not always accurate. So I guess the worst that could happen is that you delete a proc that is actually needed but that sql server "said" it wasn't.
2005-02-21
the following article could possibly help (it's about using AS and RS, look towards the end re: actions) but will depend a little on how dynamic you need to query. If it's only ever going to return customers etc, then this may work for you.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp steve.
2005-02-20
use this sp CREATE PROCEDURE usp_DropColumn @TableName Varchar(50), @ColumnName Varchar(50) AS /*==================================================================================================== NAME: usp_Dropcolumn TYPE: stored procedure (SQL 7) CREATION DATE: 08/01/01 USAGE: DECLARE @TableName Varchar(50) DECLARE @ColumnName Varchar(50) SET @TableName = 'MyTable' SET @ColumnName = 'MyColumn' Exec usp_DropColumn @TableName, @ColumnName PURPOSE : To Drop a Column from a Table irrespective of the constraints defined […]
2005-02-13
After some additional testing, it looks like query 1 is correct:select s.suiteid, s.buildingid, s.SuiteName, b.buildingnumber, g.suitename, g.buildingID from suites s inner join buildings b on s.buildingid=b.buildingid LEFT JOIN RealmStageSuites g on g.buildingid=b.buildingnumber AND g.suitename=s.suitename WHERE g.suitename IS NULL AND g.buildingID is NULLAnyone know what's wrong with Q2?
2005-02-04
I've been interested to read the musings, as I always wondered what it was about open source that got people so excited. Little of value is ever really given away, and it does seem to spawn a myriad of different flavours. At least in the closed source world we have a controlled number of jellies […]
2005-02-04
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/pressrelease/booksale.asp
2005-01-23
2 reads
Sorry, I gave it a try and it doesn't work the way a tought it would.I was able to modify the decimal and grouping symbol by specifying a different language in the report properties...Maybe this could work for you Eric
2005-01-20
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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