IN IIS there is two virtual directory placed

1.Reportserver

2.reports

set the logging permission for these two.

may your work done

DECLARE @Columns VARCHAR(2000),@SQLString NVARCHAR(500)

DECLARE @NoofDays INT,@I INT

SET @NoofDays=30

SET @Columns=''

SET @I=1

WHILE @I<=@NoofDays

BEGIN

SET @Columns=@Columns+'['+CONVERT(VARCHAR,@I)+']'+' '+'INT'+','

SET @I=@I+1

END

SET @Columns=LEFT(@Columns,LEN(@Columns)-1)

SET @SQLString ='CREATE TABLE TEMP ('+ @Columns+')'

Select @SQLString

exec sp_executesql @SQLString

--insert into #TEMP(..............) VALUES(.................)

SELECT...

THIS FUNCTION MAY BE HELP YOU

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:VBPROGRAMMER1986@GMAIL.COM

-- Description:THIS FUNCTION IS IMPLEMENTAION OF ORACLES'S INITCAP FUNCTION

-- =============================================

CREATE FUNCTION [dbo].[INITCAP] (@sInitCaps varchar(2000)) RETURNS varchar(2000) AS

BEGIN

DECLARE @nNumSpaces...

try this

select * from information_schema.CHECK_CONSTRAINTS

you can view all constraint in this database

or may be you not refresh your database.

try this

declare @outvar nvarchar(100)

set @outvar=''

SELECT @outvar=@outvar + ', ' + deptid FROM tableA

select @outvar

thanks............

but a record is divide in several rows and may be create problem in select statement.

also we have a condition on language id.

any suggestion

For Example My Product Table Structure As Following

Product

-------------------

ID Int

Name nvarchar(500

Description nvarchar(100)

Now We have Two Field in product table which must be translate in two language.

Now...

Thank

This can help me

Thank for reply

According your view the master table structure and record as follows

Master Id Table Id Language Id Translated Text

101 ...

Thanks For Reply

Your Solution is right. but according performance issue it is not good.

if we use 4 - 5 table in join and select a range from 2000...