May be a check on the row count of the last table being updated by process 1. Since truncation will return a count = 0 and after that count will...

Brian Fischer (1/5/2010)

---

Just does to show that you can use Crystal's database expert to browse and join files and expect it to work well. Always do the work on the...

You can create index on UserID column for all child tables. Just make sure that the child tables do not contain very few data. In such a case the index...

good answer.

Indexes are created for performance improvement. You can create an index before or after...

brainy (12/29/2009)

---

Sorry.. I am not importing data from a flat file.. I am just importing from other table. So I am just using insert into .. select * from .....

I...

check this out for tally table uses.

http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/

Also check why the data is getting truncated. Are you using any string functions while importing data.

any updates ?

Please give more details.

Try and use the BULK INSERT Statements for inserts.

Execute AS "User1" impersonates the permissions of the user specified , in this case User1 and not the created user.

citrix might be a exception. I was only making a general statement.

My thoughts...

There is a difference in working for a firm doing only software development/services and working in a IT department of firm whose core business is not IT. I...

You need to know how and when you are going to have your celebration. During recessionary times when your pay is affected its difficult to celebrate and can also give...