Viewing 15 posts - 1,921 through 1,935 (of 2,008 total)
using bcp_sendrow api
If bcp_sendrow api is only available option to you. I would suggest you to refer following:
bcp_sendrow
http://msdn.microsoft.com/en-us/library/ms131652.aspx
bcp_bind
October 13, 2011 at 4:49 am
shall u plz tell me how to do object level permission in sql server 2008
GRANT Object Permissions (Transact-SQL)
October 13, 2011 at 4:41 am
if i separate this into 2 schema means they cant understand this
Then you must take the pain (as a developer) and assign individual object level permissions to respective...
October 13, 2011 at 4:15 am
My focus here is on would to bypass the process meant to protect the database because you trust the sender ( I know he's a good guy)
Are you...
October 13, 2011 at 4:01 am
i dont want to put N as prefix at the time of insertion because my all SP are created already
And that is why it's recommended to prefix 'N'...
October 13, 2011 at 3:43 am
That's what I needed. Thanks 🙂
Happy to Help! 🙂
October 13, 2011 at 3:29 am
Create 2 schemas and place your tables accordingly. Then grant permissions to users for particular schema.
User-Schema Separation
October 13, 2011 at 3:23 am
if anyone will have same problem will get a solution
Nice Thought... and this is what I meant by FYI (For Your Information) post 😀
I do post here...
October 13, 2011 at 2:31 am
may I know reason?
I assume this is full backup and at the time of restore, it will try to make the database in the state it was at...
October 13, 2011 at 2:17 am
i need to synchronize thease two database as bidirectional.
Merge replication is typically used in server-to-client environments. Merge replication is appropriate in any of the following situations:
•Multiple Subscribers might update...
October 13, 2011 at 2:10 am
SQL Server uses a proportional fill strategy across all the files within each filegroup and writes an amount of data proportional to the free space in the file. This enables...
October 13, 2011 at 1:44 am
Few Facts:
1) The amount of memory acquired by the Database Engine is entirely dependent on the workload placed on the instance. A SQL Server instance that is not processing many...
October 13, 2011 at 1:37 am
As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...
I am sorry but I didn't get you. You are facing...
October 13, 2011 at 1:13 am
A simple DOS batch job can create a backup of your database and copy your backups to other server locations. But I am not sure whether you can call it...
October 12, 2011 at 8:17 am
In the case of SQL Server 2008 R2 Standard, SQL Server 2008 R2 Workgroup, and SQL Server 2008 R2 Web, if you license all of the physical processors you may...
October 12, 2011 at 8:02 am
Viewing 15 posts - 1,921 through 1,935 (of 2,008 total)