There was no way out to get the benefit of using "copyOnly" without having this feature.... in earlier versions...

check with "restore labelonly" to verify whether the backup is taken up on disk or tape.

Use this one... I think u were missing conditions in between...

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[DateReport]

@DateStart nvarchar(50),

@EndDate nvarchar(50),

@CompName nvarchar(50)

AS

BEGIN

declare @Query nvarchar(4000)

set @Query ='Select [year].[month],

[year].[year],

[year].[money],

Tvarizi.[money] AS TVM,

Tvarizi.BillNum AS TVB,

Tvarizi.DateOfPayBill...

It directly impacts the size of log file. For longer time the counters data is collected, interval should be more. No impact on analyzing the counters.

U could write a proc instead of writing function with the same code.... call the proc 1st.. this proc should store the output in temp table.. then create a function...

...else it could be running under compressed folder....

Alternatively, u can write proc rather than function or include string initialization in proc and call the proc from inside sql function.... dont know whether it will work for u...

Try to rebuild one/all indexes on the table and check.... it should come... By the way, Why indexes are required if there are only 6 rows in the table....

Drop the index which was created on the column being dropped/modified.

Also check, may be index was created on coposite key, if its there... drop the index then change the datatype...

U can use case... inside function....

This could be useful too.... Tried to do in a small code....

--Table creation and records insertion...........

--create table aaa (name varchar(200))

--insert into aaa values ('abcdefghijklmnop')

--insert into aaa values ('bcdefghijklmnop')

--insert into aaa...

pls. go through BOL or get a good book on SQL Server... as u r doing update..... and ur requirement is to get the records....

Create 1 table that will contain 1 row for each table in the database and a datetime column that will be having last_modified_date. This table then will be updated by...

U can use Binary collation.... SQL_Latin1_General_Cp850_BIN

If u want ur Application to be redirected automatically onto the Failover Database, Google it... There r some pseudo codes available... it works like.. it checks the connectivity of the...