harry.chandra (9/24/2010)

---

Thanks Lowell,

Would this script actually execute the Stored Procedures? Since its a test system with active users, I want to make sure that the SQL wont execute all of...

thre is not an In-Your-Face status like Oracle and other languages have; all you can do is test all the objects and save the results in a table for the...

it exists, but the syntax is a little different:

SELECT *

INTO NEWTABLENAME --creates this table based on the select query

FROM SOMETABLE

i see the proc proc_AutoGEAcctMon

get created, but never called; down towards the end you call a procedure with Execute dbo.proc_cleanNames, but not proc_AutoGEAcctMon

; could that be the issue? forgetting...

does your lookup table have anything to help identify changed rows, like a UpdatedDate or RowVersion or anything ? any chance you could use replication instead?

i think it's just syntax: the query in the parenthesis needs an alias, and you select from THAT:

select month(dateadd(s,creationDate/1000,'1970-01-01')) as mnth, year(dateadd(s,creationdate/1000,'1970-01-01')) as yr

FROM

(

...

well you need TextData and DatabaseID so you Know what command was...

i think that without a TRY CATCH, the moment an error is encountered, processing stops, and it never gets to the error handling code;

i've got this example saved in my...

i think the events SQL:BatchCompleted , which catch ad hoc queries, and RPC:Completed, which catches code executes in a procedure or function(is that right) are what i typically use;

I think...

another issue to consider;

avoid updating a static table based on a rollup of other information; use a view instead;

the tables could be out of sync if the process is not...

your issue is you need to update FROM another table...not a real table, but a summary of data in another table;

you didn't provide any details as far as the schema...

no, the TEXT datatype is in the process of being deprecated in favor of the...

pankaj.kuchaliya (9/22/2010)

---

I have one confusion that is "trigger is executed when i insert in " ETL_Update" table . only one row can be inserted in this table at a single...

glad you are getting a handle on it; kudos for posting what you are trying so you can get the proepr kind of help; too often we see folks just...

yep the errors telling you the issue, and it was kind of what i expected.

this value exists in that column:

'Assistant Manager Officials & Managers'

it should be obvious that...