The best way of doing this is to take the bkp of log file and shrink the existing one.

-Satya

All i can say that it is sudden changes came. one day before all working fine.

Basically its a xml job and run lots of SPs in behind. when i...

you can use job maintance plan for the same.

For Small query as u written in your exapmple, it wont hamper as much but in large query yes. because number of transaction are increesing.

you can check it by showing...

You can do this from the following query:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\testing.xls',

'SELECT emp_cd, emp_name FROM [Sheet1$]')

SELECT emp_cd, emp_name FROM emplopyee

GO

Note: make sure that excel fiile is created and should...

You can do this from the follwoing way

SELECT table_name1.column_name2 ,(select sum(table_name2.column_name2) from table_name2 where table_name2.coulmn_name1 <= table_name1.column_name1 ) as new_column from table_name1

Whereas:

1.table_name1 and table_name2 are the same table name....

You can do this from the follwoing way

SELECT

Whereas:

1.table_name1 and table_name2 are the same table name. Use the alias

2.column_name1 is the datetime coulmn

-Satya

Check whether your SQL Server Agent is running or not.

You can do this by:

Start->Programs->Service Manager, select Sql server agent from services dropdown and press Start button.

-Regards

Satya N Tailor