try to ping the remote machine and check the response time. if response time is more consult Network for latency in the network.

Regards

Ramu

there is icon on standard tool bar look like a grap where u can find the activity monitor just click activty monitor will open.

Regards

Ramu

where remote query is running the spid of remote server can come to by sp written by microsoft called sp_blocker90 something like that.

query sp_who2 or sysprocess or dbcc input buffer...

Actually i have dataware house table in we have transaction table and history table, after a regular interval we compare transaction table and history table for any update insert and...

initially plan was that only but when i scripted the user in SSMS . It didnt script the Database roles i was i fix. What i tried i have copied...

actually i wanted to asked that. iam downgrading the current SQL Server 2005 from Enterprise edition to Devloper edition with all existing users on new installed SQL Server 2005.

So if...

hi all,

can do this way to restore all setting which were present in the server.

1) restore master and msdb database to new installed server

2) Before uninstalling i will copy all...

thanks

suppose i have db name test and there no objects in this db now whenever user of this database will create a object that should in either of these schemas...

ya i have did that. but its strange that i cant see the comments as wanted earlier.

if use 2005 SSMS to modify the sp i cant the comments. where as...

thanks for reply

i have used alternative for it by recursive function CTE i have got the result

actually i have a tree store in table as below

PARENT_ALKYCHILD_ALKY

1000070 ...

hi Jack,

the url is very informative and to the point thanks for sharing.

Regards

ramu

ya you are right, if there leading and trailing spaces it would more efficient and overhead of trim function usage is not required

from this i came to conclusion that if i have more than 1 million record and use first query it will cost more compared to second one 🙂

thanks for the...

please find the attached