I am executing under the sa login and this is the exact error I am receiving:

Server: Msg 4861, Level 16, State 1, Line 1

Could not bulk insert because file '\\server\fdata\sync.dat'...

Your new stored procedure should look like this:

CREATE PROCEDURE sp_get_total_qty_rate

@customerid char(15),

@datefrom datetime,

@dateto datetime

AS

DECLARE @dDateFrom datetime, @dDateTo datetime, @sCustomerid char(15), @fdnqty numeric, @nRate numeric

set nocount on

/* Create temporary table*/

CREATE...

Hello,

What you need to do is to "set nocount on" in your stored procedure, before the create table and then place a "set nocount off" after the insert statement. ...

Jeremy,

Using a corporate and application database structure, how did you manage the data integrity. Did you use triggers to manage the relationships of the application...

It looks as if creating a common database with like tables is the way to go, if I have a small group of concurrent users. These tables will be...

We still would use a database for each app but we would also have a database that would have data common to all applications. Most of the data would...