Ray K (12/29/2009)

---

Just for your future reference -- if you post/present your data like this, you'll probably get faster responses! 🙂 (Basically, help us help you -- the less...

in TSQL, you could search for where any string begins by using the CHARINDEX function; it is the equivilent of vb INSTR function, or .NET's string.IndexOf("StringToFind")

if it is greater than...

i just googled "free system monitoring software" and found lots of stuff;

you want to watch for more than just the SQL server service being up or down; you've also got...

QML you did not answer any of the questions asking for clarification.

please, please read the comments a bit slower, and try to reply back to us to determine what you...

everything is working as expected; the user cannot directly insert/update/delete from the tables.

the assumption is that if you grant EXECUTE to a stored procedure, then the procedure can do whatever...

mahesh when i read BOL, it has this statement:

http://msdn.microsoft.com/en-us/library/ms188354.aspx

what user are you logged in as before you try to execute as 'dom'? are you in as sa or a sysadmin...

the error message is the clue: you can't select the row_id_no, because it is not part of the subquery in parenthesis.

remember what i said about aliases and parenthesis? that goes...

a subselect in parenthesis must have an alias;

formatting helps identiy the problem, too:

SELECT

max(DWT40034_BZL_VAT_TAX.ROW_ID_NO)

from

(

select

DWT40034_BZL_VAT_TAX.INTGRT_CNTRY_CD,

DWT40034_BZL_VAT_TAX.ORD,

...

manojkanoi (12/27/2009)

---

Thanks for the quick reply. I am using like statements because they are not equal but similar. Will a modified version of your statement with like instead of equal...

ahh, SQL and oracle TIMESTAMPS are not the same thing.

in Oracle, the TIMESTAMP data type is a very granular datetime field.

SQL> SELECT CAST(date1 AS TIMESTAMP) "Date" FROM t;

Date

-----------------------------------------------------

20-JUN-03 04.55.14.000000 PM

26-JUN-03...

stating the obvious, do a backup, test this on a development server, ask questions, confirm it is close to what you are after.

--update the whole table

UPDATE transactions

SET matchingid =...

mano you are not taking advantage of the power of SQL's set based operations;

you could do your update, to all millions of records, in a single statement....even better, it would...

as long as you know how the data will be ordered, row_number() function is probably the best solution:

SELECT * FROM

(

SELECT row_number() over (ORDER BY YourColumn) As RW,

* from YourTable

)...

here you go Roger; a project like this has to use the metadata to determine which columns to query, so using a cursor in this case is fine;

the logic is...

could it be you do not have a regular backup schedule in place in that location, and that is causing your unnecessary growth?

the ldf is the log file. if your...