Hi

Thanks for your replay,If some one create the Table with the name i specified to my table in this sp ,then it is problem when i...

Is this you are trying.

DECLARE @TABLE TABLE(I INT )

INSERT INTO @TABLE SELECT 3

INSERT INTO @TABLE SELECT 3

INSERT INTO @TABLE SELECT 3

INSERT INTO @TABLE ...

It will be in Restoring state only unless and until you bring them into Online

since you are using for Logg shipping it will be in Restore state only.

Once any...

"More the Wait Better the you got" i got better answer so no problem

Hi lutz

This is what exactly i need thanks for your help,it saved my lot of my time.

Thanks

Parthi

Hi

I have attached the screen shot my Requ.

Thanks

Parthi

Hi Lutz

Thanks for your replay actually it is done by below

DECLARE @collection VARCHAR(8000)

select @collection=coalesce(@Collection+',','')+Value from @Temp

select @collection (No column name)

but i dont...

It means that you have not backup your database before configuring into log shipping u have to take the Backup of Py server backup and restore in your sec server...

You can just run this to see what has happened to your backup

SELECT

ld.line1 AS [Line1],

ld.line2 AS [Line2],

ld.line3 AS [Line3],

ld.line4 AS [Line4],

ld.line5 AS [Line5],

ld.server_name AS [ServerName],

ld.start_time AS [StartTime],

ld.end_time AS [EndTime],

ld.error_number AS...

Hi thanks for your replay

*My ultimate goal is to keep the data in-live as much as possible

*My Database 24/7 it is SQL 2005 EE

*DB size 10GB

*Appx...

Thanks for your replay Ian

I am just trying to test which one would be better(Mirroring and/or Clustering) thats it.

My theme is -whether it is...

Supported Operating Systems:

Windows 7; Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista Service Pack 1; Windows XP Service Pack 3

32-bit systems

Computer with Intel or compatible...

I need to Satisfy the customers need with less amount of data lose.

In the event of a corruption, or other disaster, the maximum amount of data loss is the last...

Thanks Williams

How to check the service account running SQL Server and SQL Server Agent has access to the shared folder...

hi ,

Userid and Password is calling all time ,Why in reporting services SQL server?

Reason:

U have created the report through SQL auth/mode there...