Bulk insert from File SQL Server

For CSVs bulk insert ycsoftware.dbo.ycsoftware from ‘\\192.168.1.1\c$\ycsoftware\files\data.txt’ WITH ( FIRSTROW = 2, FIELDTERMINATOR = ‘\t’, ROWTERMINATOR = ‘\n’, TABLOCK ) For TSVs bulk insert ycsoftware.dbo.ycsoftware from ‘\\192.168.1.1\c$\ycsoftware\files\data.txt’ WITH ( FIRSTROW = 2, FIELDTERMINATOR = ‘,’, … Read more

Microsoft Sql Server 2005 setup error

There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. Adding the group: SQLServer2005SQLBrowserUser$SERVERNAME  happens to fix the issue http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/5f2abaeb-3d28-492c-bfbe-5b53f23c7963