Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Access Denied when using Unique Identifier as a Primary key (http://www.go4expert.com/forums/access-denied-using-unique-identifier-t2120/)

fazalimran 4Dec2006 14:00

Access Denied when using Unique Identifier as a Primary key
 
Hi, i have a problem with my SQL Database, Actually i used a Unique Identifier with Auto Generate key as my Primary key in my tables. Well at my local end its working fine and all the records are inserting very well, but when ever i used that same as my webserver (remote) an "Access Denied" error occurs, i donno but it happens. Plz help me coz i am very much stuck in this and cant get any place to solve... may its the matter of permission or some thing. plz help..

venkatesanj@hcl.in 12Mar2008 08:42

Re: Access Denied when using Unique Identifier as a Primary key
 
Sir,
Just make a try with identity column (seed value 0,1) - To check whether the problem is with auto generation.

Whether you are trying to insert the datas using NewID(). Please check my article for more reference.

http://venkattechnicalblog.blogspot....ql-server.html

Regards,
Venkatesan Prabu . J


All times are GMT +5.5. The time now is 00:20.