Try creating Indexes with timestamp in the Index name so that whenever a new Index is created the name will be unique for the Index.This way I think you can...

I think both adding the constraint and the update does the same.What I suggest is do the updates in chuncks i.e. say 1000 - 5000 at one go and a...

I am not sure if it require a reboot to SQL Server 7.0 But SQL Server 2000 it is not required to reboot.

I think if you do print screen and paste it into MS word or Excel etc. you manager can view it.

Are you trying to execute the nested stored procedures.I am having an inclination that it is because of nested procedures, though not sure.

Are you trying to execute the nested stored procedures.I am having an inclination that it is because of nested procedures.

yes we have sp2 installed

I am talking about the performance monitor not profiler.I am running on SQL 2000.Could you please tell me how.

Thanks in advance.

Thanks guys.I jst disabled the TCP/IP from sever Network utility and then enabled.

It's working for me now.

Thanks,

MK

Thanks for the response.In my error log i could see the following messages.

SuperSocket Info: Bind failed on TCP port 1433.

Ic ould ping this server from the client...

Wondering if you delte the Rows from a table which has image data type,does it frees the space occupied by the image too.As per my understanding table holds a pinter...

There two queries one using while function and the other without,both these queries donot use a cursor.

--Option1

CREATE PROC Update_Posting (@batchId varchar(50))

AS

WHILE EXISTS(SELECT CaseNumber, ReceiptAmount FROM currentpostings

WHERE batchId = @batchId)

BEGIN

UPDATE CaseData...

I have seen this problem,i have installed SP2 after which i did not come across this problem.

sa is the owner of all the objects.But when the user say amit, if he creates the tables you can see him under the owner column in the EM.So, instead...

If you are trying to apply the Service Pack on the NT Machine,try logging in as the local admin for that machine and try.We had the same kind of problem...