Change the Log File auto grow property thro' SQL Server Management Studio.

(Select Database -> Properties -> Files...)

change the logic while exporting data into excel.

use ">> C:\Save.txt" instead of "> C:\Save.txt"

can u explain your exact requirement. 😎

I think you may be expected like the following:

SELECT[Post_ID]

,[Post_Title]

,[Post_Reply_ID]

,[Reply_Title]

FROM[Cfamla].[dbo].[Post_Detail] pd

INNER JOIN [Cfamla].[dbo].[Post_Reply] pr ON (pd.[Post_ID] = pr.[Post_ID])

Did u check my post...

Actually change the .txt file path to C:\Save.txt.

Best information you can see SQL BOL. (http://msdn2.microsoft.com/en-us/library/ms130214.aspx)

Hi Anu,

change the output path to "C:\Save.txt" and try it.

FYI:

----

Create Trigger TestTrigger1

On dbo.tablefortrigger

For Insert

As

Begin

Set nocount on

Declare @msg nvarchar(255) /*Check sp_addmessage */

Declare @CmdString nvarchar (2000)

set @msg = 'Inserted \ tablefortrigger \'...

see the Setting Server Configuration section on SQL BOL or see the link: http://msdn2.microsoft.com/en-us/library/ms189631.aspx

or use Surface area configuration in SQL 2005

more information on Index, refer SQL BOL. (http://msdn2.microsoft.com/en-us/library/ms189051.aspx)

use Case Statement in View.

Try the following way:

DECLARE @sql VARCHAR(8000)

DECLARE @p_number NUMERIC

SET @p_number = 134070

SET @sql = 'SELECT * FROM M_Driemnd(' + CONVERT (varchar (10), @p_number) + ')'

PRINT @sql

🙂

you can find the SQL Server status using SQL-DMO object, refer to SQL BOL.

where & when you get error ?

provide code ?

If you have installed SQL Server 2005 completely (i.e. means includes samples), you can go to the samples folder and check the existing samples, so that you get some idea...

In SQL 2005 have no problem, but have problem in SQL 2000 and below versions. so better to move SQL Server 2005.

🙂