SQL Bulk Insert

SQL for bulk insert into a table: BEGIN       declare @s varchar(400)      set @s = ‘BULK Insert my_temp_table FROM ”’                           + @file_name  + ”’ WITH (                                                                                         FIELDTERMINATOR = ”,”,                                                                                         ROWTERMINATOR = ”\n”,                                                                                         FIRSTROW = 1                                                                                       )’      print @s      exec(@s)  END

Deleted database log(.ldf) file of SQL Server? Need to Restore database?

Let’s say…one of your DB log file got too large and u need to make some space in your hard disk very quickly. So, u like to delete a .ldf file/log file of a database of MS SQL server. First, you need to close any SQL server client tool that is running (i.e. SQL Server Management Studio), … More Deleted database log(.ldf) file of SQL Server? Need to Restore database?