Thanks Gail, Awesome as always.

I have a small Confusion. Lets assume I have a table "Emp_details" with 4 columns-Emp_ID(primary key which creates clustered index by default), Name, Designation and Location...

Thanks John, but no such files. 🙂

Thanks

Sanjay

Hey Thom, Sorry that's what i meant, free up the space.

Hey John,

As i told you it's only Data files log files are on a different drive.

Can you please explain,what do you mean by unneeded files?

Thanks

Sanjay

Yes Gail, It is showing 10MB but the growth is limited to some thousands of MB which was set at the time of DB creation(From a different person).

But, It's so...

Pls find the screenshot here - https://drive.google.com/file/d/0BwQesWwtB8meUDdLS2pIMW8tQkE/view?usp=sharing

It's the screenshot after the update

Sorry, How do i attach screenshot.

Tried Using both SSMS - DB_Name-Properties-Files-Log file then changing Filegrowth .

Tsql

ALTER DATABASE <Name>

MODIFY FILE

(NAME=MyDB_Log,FILEGROWTH=10MB);

Here is the function...

ALTER FUNCTION [dbo].[ufn_GetHcmDesignFields]

(

@ModuleId bigint, -- HCM_DESIGN_FIELDS moduleid with IsExtendable status 1

@RID bigInt -- table rid

)

RETURNS nvarchar(max)

AS

BEGIN

DECLARE @Return as...

I modified the query to

Declare @query nvarchar(max)

set @query = dbo.ufn_GetHcmDesignFields(3, 31418)

Declare @query2 nvarchar(max)

EXEC sp_executesql N'@query','@query2 nvarchar(max) output',@query2 output

select @query2 as Test

I get the same error

Thanks Gail, Iam trying the following query and i get the error mentioned below.

Declare @query nvarchar(max)

set @query = dbo.ufn_GetHcmDesignFields(3, 31418)

Declare @query1 nvarchar(max)...

Thanks, for the support Steve. I will work on it

Sorry, It's SQL server 2005 standard edition.

Hey John,

It's a old DB which was not in use. I don't have any backups.

Thanks, for the support prettsons