You can also use Lumigent Log explorer,SQL Log Rescue avialable in the market to explore the transaction logs.I have written an article regarding teh usage of this software.It can be...

I am facing the same problem.I need to load the data from a xml source.My xml is as follows:-

<?xml version="1.0"?>

<Products>

<Product id="1">

<ProductName>Pr1</ProductName>

<Quantity>5</Quantity>

<ProductType typeid="1">Household</ProductType>

<Price currency="Rupees">15.00</Price>

</Product>

<Product id="2">

<ProductName>Pr2</ProductName>

<Quantity>10</Quantity>

<ProductType typeid="2">Disinfectants</ProductType>

<Price currency="Yen">25.00</Price>

</Product>

<Product id="3">

<ProductName>Pr3</ProductName>

<Quantity>15</Quantity>

<ProductType typeid="3">Wood</ProductType>

<Price currency="Rupees">56.00</Price>

</Product>

<Product id="4">

<ProductName>Pr4</ProductName>

<Quantity>52</Quantity>

<ProductType...

Hi,

I want to uninstall the sql server 2005 and sql server 2008 compontents from the node which was acting as a node in a cluster.We are not sure if the...

Hi,

The backup compression is a great feature in SQL Server 2008.But since the backup of the database is in compressed state,it takes a longer time for the database to come...

Are you running any sql jobs in the morning because of which the the query performance is slow?Compare teh execution plans of the queries by running in evening and morning.You...

You can also use sql profiler to find out which sp in your application is taking a lot of time.You can fine tine the performance of that Sp by fine...

In the scenario,which you have mentioned that the application crashes in the middle of the transaction.500 records are inserted and it is in th non committal state.The transaction log will...

Hi Ludovic,

Are you sure that it does not support SQL Server 2005?Yesterday my article on ApexSQL Log 2005 was published.I had mentioned in that article that its the only tool...

Hi Ameena,

Lumigent Log explorer is also similar to the functionality of ApexSQL Log.There are some differences in the features.ApexSQL Log has additional features.I am yet to check on Log explorer's...

Hi check out this post.This explains why DBCC shrinkfile fails and what do you need to do for it

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=933488&SiteID=17

Hi naseer,

I am not able to download the file.It says u have reached the maximum limit for free users.Can u plz help me?

Regards,

Sri

Hey Senthil,

I am not able to download the file.Please help me.It says you have reached teh limit of teh free users.Can you share the file with me?

Regards,

S.Srivathsani

Hi Naseer,

I am not able to download the file.Is it possible for you to put it in some other location or send it by mail?My mail id is

Hi,

I have done the MCDBA certification I want to upgrade it to MCITP with teh upgrade exam(70-447).I want to know the books which i should refer for this?Please help.

Regards,

S.Srivathsani

Hello Sanjeev,

You can refer to this KB article http://support.microsoft.com/kb/833710.What is the Service pack of the SQL Server you are using?If it is not the latets one,Upgrade it to the...