And what about USER's mapping ?

How would you do that ?

And also try that whether SQL logins are working well(with transferred encrypted passwords ) ?

You can do the insertion in batches like 10000 rows in every insert/execution

1. once the session is rolled back compeltely does the log released by itself or do i have to truncate it or how does check poiint work to clear the...

@srikanth-2

Which method did you use for it ?

can you post the query/script you are using to insert data ?

you can try below link but i am not quite sure that it can give you required help

http://blogs.solidq.com/EN/rdyess/Lists/Posts/Post.aspx?ID=16

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e5c0af6e-763e-460b-818b-0e9df6572f12

i guess you can use database mirroring to accomplish this...

Clients interaction 🙂 ?

i think NY has many places whose names are taken from cities of INDIA like Chandni chawk

Kingston Dhasian (3/22/2010)

---

WHEREDAY( DATEADD( DAY, 1, dt ) ) != 1 i am agree with dhasian but if we talk about heavy/large table definitely above code would kill seek operation.By...

Hey I am from Delhi ( India); Southern part of ASIA.Delhi is the place where COMMON WEALTH GAMES 2010 will be heldin October 2010.

Very happening city.

First of all read this post http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx

Additionally read the execution plan, what are the hot spot areas. you can post exec plan along with table and index defintion here ,...

Try this but before that test it somewhere, its working on my side./**************************************Script to generate all the Jobs...

Written by Paul White NZ for not dropping indexes

As far as the wider point is concerned, don't be too keen to drop apparently under-used indexes. Be absolutely sure you know...

How did you resolve it ? Did you drop indexes ? i dont think you did that