check out sys.database_files.

Column cpu in sysprocesses show the cpu time taken for a particular process (spid). Its in milliseconds.

If you want to export data to a excel file you need to be looking at the bcp utility.

Steve Jones - Editor (3/12/2009)

---

If you want to run it in SSMS and get the answer, that's up to you. However that kind of defeats the purpose of the questions....

BULK INSERT checkcsv

FROM 'C:\foldername\IWSQLDBame.txt'

WITH

(FIELDTERMINATOR = ',', ROWTERMINATOR = '/n')

Specify the correct drive where i have put "C:\" and put the correct folderpath in "foldername" and try.

Hi... my rough and tough idea... sorry if it seems clumsy

Script out a certain number of procedures into SSMS and do a find and replace.

You need to put the file either on the db server or another server (UNC) which the db server can access.

In your case put it in the C drive of...

Why 4 points for this question? I mean u can run this thing in SSMS and get the answer.

Do you mean to say u put indexes on the columns and the query worked better?

manju_gallivant (3/10/2009)

---

Yes.. U can ..

It is correlated sub query ..

if the inner sub query returns u multiple rows.. the update query actually loops thru the resultset and updates...

Hi

Its difficult to tell without knowing exactly what you are trying to do. With the info given i think using of temp tables might be the best of the 3...

Can we write a update query like the way you have written

"UPDATE TIDLRREP t SET (t.translated_term_79, t.repository_status) =

(SELECT a.TRANSLATED_TRM_160,'40' FROM ..."

Are'nt you getting any errors?

Will work only of numeric/integer columns. If the data...

Hey buddy we are not here to waste time. Rather we are here to help each other. Since you got the solution you should post it here and close the...

Yes its only for the current session. DateFirst acutally depends on the language chosen. For english it 7 - Sunday.