...

...

...

CREATE FUNCTION [dbo].[fSplit] ( @List VARCHAR(6000), @SplitOn VARCHAR(5) ) RETURNS @RtnValue TABLE ( ID INT identity(1,1), Value VARCHAR(100) ) AS BEGIN WHILE (Charindex(@SplitOn,@List)>0) BEGIN INSERT INTO @RtnValue (...

...

Steps to create the first basic SSIS Package using BIDS which moves data from Flat File source to SQL Server 2008 Table...

can we schedule transaction log file( .ldf)automatically add when primary log file size full ?...

Thanks a lot Jacob for giving your important time to me....

Thanks for your important suggestions, But i would like to know, In how much time duration this table will be release without killing process manually?...

Thank you very much Jacob, I know all these thing except schedule automated add TRN log file. but i just want to confirm these things. one of our production server i have seen that client has been added one TRN log file (size 10 GB) and PRIMARY lo...