Please post in the appropriate forum

Hi

Just a guess...

Maybe sql is running out of memory or the cpu is being heavily used by the BCP statement.

Hi

U can also use sp_who to check whether any users are connected to a database. But i think running profiler for some amount of time is the better option.

Hi

Returning 20 rows 20 times is better than returning 700,000 rows at one go most of the time and i think that shud be your approach to this.

But do...

Hi

Your proc is all wrong. Its not the way to go about it.

If you want me to write the proc send me the table definitions and some sample data....

Hi

User can also view the pages 15,36,45 rt?.

If you are displaying only limited and fixed number of records then putting the paging logic in the db is correct.

But if...

Hi K

I suggest you undertake some training on basics of SQL . Traning could be done within the organization you work in ... somebody senior could be your mentor or...

DONT DO THIS....

Hi

Better not to exec a proc inside a trigger particularly if the proc is again inserting into the table.

kokwei_w (10/19/2007)

---

dear chirag,

thank u sir.. this works fine now.. minor alterations here and there got this script working

i have modified n reused the codes to group the concatenation as such

DECLARE...

hi

do yuo have any jobs or any other background process thats accessing master db.

kokwei_w (10/17/2007)

---

the error message after executing query below is .. This designer does not graphically support the DECLARE CURSOR SQL construct. Is it becoz i m using sql2000?

DECLARE @empskill2...

kokwei_w (10/17/2007)

---

hey Craig,

thanks for the reply to my query..

i guess it is working..

this is the code i m looking at rite now..

DECLARE @empskill2 VARCHAR(100)

SET ...

Hi

you can set a backup location in the maint.plans.

Which service pack are you running on. There were some problems with maint.plans which have been sorted out in service packs....

Hi

Andras is right here.

I think the best long term option would be to take log backups.