I have no other idea taht can help you. Maybe some of the gurus can find an answer to your problem.

RPC means remote procedure call. I don't know if it has anything to do with the RPC event in the profiler that is raised when you call a stored...

have you tried?

SET @strSQL = @strSQL + ' WHERE im_id LIKE ''%'+@inputSearchText+'%''

im_name LIKE ''%'+@inputSearchText+'%''

OR im_desc LIKE ''%'+@inputSearchText+'%'''

Hmmm I tried his code and it works for me... can't see the problem from here. The only thing I can think of is that you may have 2...

A similar suggestion had already come up but the prospect of a custom error message was appreciated. But your point still stands that updates are not denied with this...

You're trigger would look something like this if you do my final idea

CREATE TRIGGER [trTest_IO_Insert] ON [dbo].[Test]

INSTEAD OF INSERT

AS

SET NOCOUNT ON

--makes sure that the table is empty and that...

This could become an automated task... but the best option is to find out why you're stuck at 30 mb... I can't help you on that matter since I never...

I have never used a splitting software for automation tasks but I'm pretty sure winrar could do it. Here's a search from download.com that could get you started on...

I haven't read the whole thread but I'm just pitching in with my first idea. Since it seems that you can send up to 30 mbs, couldn't make small...

I guess it all depends on the documentation system in place... but a well placed "this table can only have 1 row at the time for x reason" can...

No just for any developper that tries to insert in that table... The end user doesn't need to hear about this.

Thanx Jeff for the input. It shows that there's always many different ways to achieve the same result with SQL server. But even with this new solution I'd...

First of all you need dynamic sql to do this.

Second, I see you are assuming that all nVarChar columns in your database are size 50. This tells me that...

I just made a little search on my previous question and here's the best link I found.

http://vyaskn.tripod.com/differences_between_set_and_select.htm

And I'm sorry to contradict you Aj but none of your 5 points were...

You could use a simple after insert trigger then.

Create trigger ....

FOR INSERT

AS

SET NOCOUNT ON

if select count(*) from MyTable = 1

begin

rollback tran

raiserror ('can''t have more than one row in this...