Something like this? : ''token, contacts''

Well, this values are being passed as varchar(200) which is one of the parameter in the stored procedure.

If I do 'value1', 'value2', then it gives me too many parameters error...

How do I check the settings that you stated above??

Well, I added the user with which I am trying to log on to the sql server to the user list of my local SQL instance and then I...

Ok. Actually I have not used the local admin even once in this box. I have always been using active directory user. And even now when I say Local, i...

When I went to services-- SQL server service. It says log on as "Network service". There is not user specified. instead of a user it says Network services. I am...

Actually this is a complex problem. Actually we are using Dot Net Nuke framework here and the DNN( dotnet Nuke) actually comes with its own set of database tables. Now,...

I am sorry cold coffee actually I used your code. i jumbled with the names. I thought it was Garadin who posted the previous post. I am really really sorry...

I am sorry for the late reply guys. thank you very much Ashish ans garadin. That method worked. :).

Hmmmmmm. can I write a script a script to remove Pk constraint from all th etables in a single database, if the PK column is the same all throuugh the...

Hi,

Thank you very much for your reply. I do not have access to SSMS right now but I will surely check that tomorrow morning. But...

Ok guys. I have installed SP1 on my system and now it does not give me the old error bu tnow it came up with some another error which says...

I have 32 bit system.

2008 and I have not yet installed SP1 for that. Let me actually check whether installing SP1 will make any difference or not.

Maddox, I think that was the...