BULK INSERT Help needed bad!

Morning all,

The following cmd says it executed but no rows appear in DB table.
I am running this cmd in QA on the server. The data file is on the server too.

BULK INSERT dbo.TBL_Master_DoNotCallList_Loader
FROM 'E:\SqlServerBackups\National Do Not Call List\VT_31_8_2006.txt'
WITH (FIELDTERMINATOR = '~')

Data looks like this:
8022028492~8022171040~8022172021~8022211006~802221 1017~8 ect

This is what QA comes back with: The command(s) completed successfully.

What am I missing here ?
Thanks
DeasunNever mind.
Found out our test server has problems.
Production server ran cmd no problem.|||

Quote:

Originally Posted by tirnaog

Never mind.
Found out our test server has problems.
Production server ran cmd no problem.

Hi,

I just got the same problem on my test server which used to work just fine.
Just wonder whether you did discover the root cause of the issue and how to fix it?
I re-patch the SQL instance with SQL service pack 4 but did not help...

Thanks,
John

BuiltinAdministrator's not SysAdmin yet appear to have DBO on all

Hi All,
I have revoked the BUILTIN\Administrators group membership in the SysAdmin
group of a SQL 2000 server and instead granted the group Process
Admoinistrators and Disk Administrators permissions. When I browse
permissions for the BUILTIN\Administrators group in EM, I see the proper
Server Roles are defined as noted above, however this group appears to have
DBO permissions to all databases on the server, even though those databases
were created by SA. In checking several of my SQL servers I am also seeing
the same thing on each server. Have people seen this before? This would
imply that the Local Admins to the box stil have dbo to all of the databases
,
but they were never granted this permission. Is this just in incorrect
representation within EM?
Thanks,
DaveNo...that's not what would typically happen if you remove
the Builtin\administrators group.
I'm guessing that you mean that the local admins appear to
have db_owner role permissions DBO and db_owner are
different things. DBO is a user and db_owner is a database
role. Users can be members of db_owner fixed database role
which gives them all permissions in the database.
I'm not sure why you think the local admins on the server
have db_owner permissions but one thing to keep in mind is
that permissions are cumulative based upon the users
explicit permissions as well as those inherited from group
membership (Windows groups as well as the server and
database groups).
-Sue
On Sun, 23 Jan 2005 06:33:03 -0800, "DBADave"
<DBADave@.discussions.microsoft.com> wrote:

>Hi All,
>I have revoked the BUILTIN\Administrators group membership in the SysAdmin
>group of a SQL 2000 server and instead granted the group Process
>Admoinistrators and Disk Administrators permissions. When I browse
>permissions for the BUILTIN\Administrators group in EM, I see the proper
>Server Roles are defined as noted above, however this group appears to have
>DBO permissions to all databases on the server, even though those databases
>were created by SA. In checking several of my SQL servers I am also seein
g
>the same thing on each server. Have people seen this before? This would
>imply that the Local Admins to the box stil have dbo to all of the database
s,
>but they were never granted this permission. Is this just in incorrect
>representation within EM?
>Thanks,
>Dave