Dear sir, I need to import data from text file to my database. so I am trying to use bcp command , Is their any way to execute stored procedures like bcp DBedurec.dbo.srd in E:\web\edurecn1\rania.txt -n -Sabuomarpc\sqlexpress -UDBedurec_user –P**** ' it returns The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'. Thanks
Have you tried using the database publishing wizard. You can set up the database publishing wizard to publish a specific object or table and the data within it. Try looking at this kb article. http://support.Winhost.com/KB/a694/publishing-your-sql-2008-database-to-Winhost-sql-2008-server.aspx