My db is running on SQL server 2008 I had a problem with the program that processes the data I decided to run a trace and it through out this message after the trace was run as a query: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSAC...

I m facing performance problem to execute a SP which is having number of sp's in it sequentially. can I use DBCC FREEPROCCACHE DBCC DROPCLEANBUFFERS command in between SP's to free some space and increase the performance.?...

How to do this below example case occurred. Ex: "c1,c2,c3,c4 ,c5 ,c6 "1 ,a ,10 ,india,f,""nan,10""" "2,b,11,ind,m,""gen,20""" "3,c,30,india,f,""gan,15""" output: c1,c2,c3,c4,c5,c6,c7 1,a,10,india,f,gan,10 2,b,11,ind,m,gan,20...

We can use "Select" as Select Top 100 * from temp; But why can't we use a variable instead of number, such as, Declare @n bigint; Set @n=100; Select top @n * from temp;...

Can anyone advise me what an appropriate BCP file format file would look like to sucessfully import data in the following format. "10000","0","Manufacturer unable to supply" "10001","5","" "10002","2","" "10003","5","Not Available" ...

Create Table MergingData ( Web_id Int, Serial_no int, Describe ntext ) Insert Into MergingData Values(101,1, 'Next in Error Configuration.') Insert Into MergingData Values(101,3, 'Unfortunately SSIS') Insert Into MergingData Values(101,5, 'Roger F...

hi im trying to create new drives. i use this path to make new drives my computer->manage->disk management but when i deleted the previous drive to create a new one i recieved this error ("RPC server is unavailable") ill really appreciate it if someon...

I need to develop a stored procedure that I think needs a cursor. I have no experience of cursors and was wanting some help. here is my problem. I have a data table which includes a product, supplier, price and a default flag. Sample Data: Pro...

DataTable datat = new DataTable(); datat.Columns.Add("ItemName"); datat.Rows.Add(new object[] { "Pen" }); datat.Rows.Add(new object[] { "Pencil" }); datat.Rows.Add(new obje...

Hi, i have my job running every 5 min. I want to view the history log. In job history it shows only few hundreds of records.. But i want to see from begining. Can anyone tell me, where to view whole log of job history?? Thanks in Advance....