You can do that by joining the same table twice using ur primary key ( sequence number )

Select current.*,next_seq.*

From tableA current, tableA next_seq

where current.sol_sub_cat_Id+1 = next_seq.sol_sub_cat_Id

This can help

http://www.sqlservercentral.com/Forums/Topic531822-360-1.aspx"> http://www.sqlservercentral.com/Forums/Topic531822-360-1.aspx

There is some other transaction which is holding locks on the object your query wants.

Look into sp_lock and find whether any other transaction accessing the same table and holds...

Right click on the database in SSMS , tasks->export/import wizard->export to excel.

Glad it worked..Welcome..our pleasure 🙂

Ninja,

I have also used sp_start_job many times but not with linked servers.

So only didnt confirm it.;-)

OSQL is depreciated and will be removed in future versions.

XP_cmdshell is always a security concern.

Both of these shd be used as last options.

If you have a pressing need to use...

On server A on on success you can start other server job using

'sp_start_job'.

Create a linked server from Server A to Server B.

Map your agent accounts.

If ur linked server name...

xparmanand,

Perhaps this one can be a useful read

http://strictlysql.blogspot.com/2009/07/impact-of-indexes-on-locking.html

Forgive me if you are already aware of it.

You can also refer to the link below for identifying page splits

http://strictlysql.blogspot.com/2009/10/identifying-page-splits.html"> http://strictlysql.blogspot.com/2009/10/identifying-page-splits.html

Just forgot to add if its less than 95% then yes its a memory crunch for sure. Ideal value is 99%

probably you are facing a memory crunch. Can you check the following?

under performance monitor(perfmon ) check the counter 'SQL Server Buffer: Buffer Cache Hit Ratio' for half an hour and...

On your problem, the issue looks awefully to close to the scenario I explained. Anyways will think of other possiblities as well.

Just to set things straight, MSSQL doesnt create unique temp table names WITHIN the SAME CONNECTION automatically.

This piece of code is for your ref

Create proc inner_sp

as

create table #tbl(col1 int )

Insert...

* On the same connection do u have any other temporary table with

the name #tbl.

A likely scenario can be this:

Your stored...