There should be little change in the script

DECLARE @databases as table (DbName nvarchar(100), DbSize bigint, Remarks nvarchar(100))

DECLARE @results as table (DbName nvarchar(100), DbSize bigint, ObjectCount bigint)

DECLARE @dbname as...

Hi

Faced some like situations before, but realized that the timeout occurs when select tsql doesn't have nay response from server for a long time.

Hi

Please try to minimise the running time of the Procedure. If it begin to takes very less minutes, then you should directly call from the .NET code. Still it takes...

Thanks for the hint "COVERING INDEX". This I tried, got improvements. I have added the some selected columns too in other tables also. Much faster now.

yes Right,

Bu I couldn't change it. Bcz its live and lot of developments done with this.

Thanks a lot.

Its helpfull

Declare @Weekdays Mytable(DAYSPECAILSKEY bigint)

Declare @dt int =datepart (dw,GETDATE())

insert into @Weekdays

Select DAYSPECAILSKEY from

DBO.DAYSPECIALS where ISACTIVE=1 and

(

ISAPPLIEDFORSPECIFICDAYS =1 AND (

(ISSUNDAY=@DT) OR

(ISMONDAY= @dt) OR

(ISTUESDAY= @dt) OR

(ISWEDNESDAY=...

Where is the start tag for DATA?

Use Triggers.

Did try like this?

SELECT SUM(wpl.bytesrecvd)as 'SENT'

,SUM(WPL.bytessent) as 'Received'

,U.FirstName,u.LastName,Un.UnitName

FROM

MainTable.dbo.Units UN

INNER JOIN MainTable.dbo.Users U ON UN.UnitID=u.UnitID

INNER JOIN WebProxyLog WPL ON U.ClientIP=WPL.ClientIP

WHERE

u.UnitID=@unitID AND u.ClientIP!=@ClientIP

AND logTime>= @FromDate and logTime<=...

I also using this methode, but littile different.

1) I have History Module(contains master table, child tables.. etc, it depends on my applications)

2) I have a trigers on the table that...

Please check whether the publication working properly without any error. I had same issue, but when checked the dates , the files are created at the error occurred dates, ...

Hello, its can do.

But what is your situation to do like this?

So we must have the details on the Periods.

Here i created one sample periods #period table. and come one more issue to find the available periods. So it puts...

Hello,

see the defference..

declare @tbl TABLE(create smalldatetime,view int,declare decimal(20,4))

--it will rise error

go

declare @tbl TABLE([create] smalldatetime,[view] int,[declare] decimal(20,4))

-- this wont