Can I resolve it without changing the sql server account settings or any other tool to be used for that purpose ???

Thanks for repling 🙂

I used SQL Backup Pro 7 on My Pc to Backup my local sql database (i.e. localserver) to both the desired servers (eg. server1 and server2) which is a...

Ok..Can I use SQL Backup Pro 7 to backup schedule ?

Ok n thanks for the help

Thanks for sharing the URL ,as ,I clear my questions regarding OPENML and in my senario I preferred to use OPENXML instead of node().

Some url suggested to use :

EXEC sp_xml_removedocument...

I used this url for insertion using XML:

msdn help for OPENXML (Transact-SQL)

Complete Stored procedure code :

ALTER PROCEDURE [dbo].[USP_Insert_UserSurveyUsingXML]

--@XmlHandle int,

@Xmlvalue as xml

AS

DECLARE

@XmlHandle int;

SET @XmlHandle =1;

--<Survey>

--<SResult SectionId="1" SectionName="Ownership" QuestionId="9" UserID="2" Answer="1" Status="checked" sDateTime="1/31/2013 10:16:53 AM" />

--<SResult SectionId="1" SectionName="Ownership"...

I did't show any error while executing it as an query but when i create it as a stored procedure than it gives error, which is resolve by initializing it...

I tryed TRUNCATE on table but still the same error of PK violation during import/Export.

What does AuTHORIZATION do ?If I assigned to sa ?

Pk_violation when i tried to import data from current updated source database to destination database.

How can I resolve orphan login as ,already assiged a login password to that user ????

yes,through backup file

I am using sql server authentication and user i assigned permission also have login id and pass,I googled the term "orphan login and got this :

what do i need to...

I will try your code and did this,which resolve my problem and SP is working fine :

ALTER PROCEDURE [dbo].[USP_Insert_UserSurveyUsingXML]

-- Add the parameters for the stored procedure here

--@XmlHandle int,

...

User can only perform select query on a view of a specified database and he is not allow to access any other stuff i.e. tables,databases,views and stored procedures

Ok.I tried :

Use dummydb

Deny INSERT,SELECT,UPDATE,DELETE ON OBJECT::userTb to nvp

GO

and work f9 and have another issue,How can i restrict user who login through windows authentication ?

and run this query :

SELECT *...