...www.mssqltips.com/tip.asp?tip=1203 -- Ekrem Önsoy "Gunawan" <jgun98.milis@gmail.com> wrote in message news:u9H6X51oIHA.... sp that we wrote, shouldn't we? TIA., Gunawan "Ekrem Önsoy" <ekrem@compecta.com> wrote in message ... EXECUTE ON [dbo].[sp_xxx] TO [some_user] -- Ekrem Önsoy "Gunawan" <jgun98.milis@gmail.com> wrote in message news...

I have not give that right. If we use this script, we should run this script to every sp that we wrote, shouldn't we? TIA., Gunawan "Ekrem

Did you give your user the right "Execute" on that SP? GRANT EXECUTE ON [dbo].[sp_xxx] TO [some_user] -- Ekrem Önsoy "Gunawan" <jgun98.milis@gmail.com> wrote in message news:uHy8IRSoIHA.4912@TK2MSFTNGP03.phx.gbl... Hi There, What is the minimal right so user can execute stored procedure. db_write, db_read can't make user execute stored procedure TIA, Gun

http://databases.aspfaq.com/general/why-do-some-sql-strings-have-an-n-prefix.html "Gunawan" <jgun98.milis@gmail.com> wrote in message news:eWNnIjKlIHA.464@TK2MSFTNGP02.phx.gbl... Hi, This is a newbie question EXEC [dbo].[lhCustDC] @CustomerName = N'PT%%' What does N mean onN'PT%%' Regards, Gun

...True. You better validate your strings in your web\windows application before commiting sql statement. Alternatively, you can add a constraint to your tables to block empty strings. -- Ekrem Önsoy "Gunawan" <jgun98.milis@gmail.com> wrote in message news:ORnd3qahIHA.3940@TK2MSFTNGP05.phx.gbl... Hi There, I have a little problem. I would like field CustomerName not null...