SQL Server bulk upload error in Windows7

Question

I have an application that uses SQL Server Express 2005 SP3. This application is distributed to several hundred users, each of whom works with XP. However, our company will soon move to Windows7. My application uses bulk insert operation in SQL Server and works fine in XP. However, in Windows7, I need to open SQL Server Management Studio as an administrator and run the following command for the bulk insert to work correctly:

EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Users', @rolename = N'bulkadmin'

Obviously, it is impractical to do this manually on each user's PC. So, I am wondering how can I script this if the user arent running my application as administrator. Is this something that you can install in the SQL Server startup package during installation? What about existing installations?

Answer 1

Do you have several hundred installations of SQL Express? I assume that you are in a removable environment where they need their own database.

? , - , ( , ).

, , SQLCMD.

http://msdn.microsoft.com/en-us/library/ms162773.aspx

, SQL- .

, SQL Server ( ).

SQLCMD -S Station01 -Q "EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Users', @rolename = N'bulkadmin'"
SQLCMD -S Station02 -Q "EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Users', @rolename = N'bulkadmin'"
SQLCMD -S Station03 -Q "EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Users', @rolename = N'bulkadmin'"
SQLCMD -S Station04 -Q "EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Users', @rolename = N'bulkadmin'"
SQLCMD -S Station05 -Q "EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Users', @rolename = N'bulkadmin'"

, , BulkAdmins, ​​.