I was going to propose to simply add a final step to each job with sp_start_job "nextJob". But if you can't modify it then polling is the only thing I...

I am against using system tables for those purposes. Creating jobs dynamically and then firing them is not only expensive in resources but also a misuse IN MY OPINION of...

Have a look:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=9576

Title of the article is not appropriate. How does this fixes sysdepends again?

[Edit] : Oops I see Remi already mentioned

you can use sp_foreachView of this site and summit the sp_refreshview as the command. Then schedule it as a job.

Let me remind you that what you are doing is not a...

Yes! Take a look at

GROUPING ( column_name )

 in BOL.

Is exactly what you need to either Filter them out or simply change that Null for 'TOTAL' or ALL

Ok,

First I am hoping that whe you said that you had a row that is a date you actually meant a column

assuming that,...

Here you go! (Straight from the horse's mouth)

Not sure exactly how are you sending the feedback but if you are using connections accross the athlantic you are most definitely crossing Firewalls and port numbers also play a role. It...

after you modify a view you need to run sp_refreshview

Trace Flag T1118 Info 

Have a look at the Disadvantages to now why is not ON by Default

DECLARE @TableName  VarChar(50)

SET  @TableName   =  'OEOHdr'

CREATE Table #Columns

 (

   ColumnName  VarChar(50)

 , ActDataLength  Int

INSERT INTO #Columns (ColumnName)

 SELECT   a.Name  'ColumnName'

 FROM  INFORMATION_SCHEMA.COLUMNS Where TABLE NAME = @TableName

DECLARE @sqltext...

OK These are my assumptions

1. Updates are not affecting large amount of rows!

2. Xp can actually be an independent application ( or service )

On the trigger you build the...

You are mixing two join styles you need to stick to one!

not sure  exactly what are you trying to get but you can try:

select IU.IUraysAmount, AdminNetwork.IONetworkName as AdminNetwork,

YU.YUNetworkName as ClientNetwork,

ZX.ZXnameLast...

On the update trigger you are using IF UPDATE([Amount]):

But this statement

UPDATE TableName SET

          Dollars = 100

WHERE [ID] = 714199

Updates Dollar not Amount therefore nothing happens

On...