rakesh_itcvrce (5/15/2012)

---

Thanks Suresh B. and Geoff A for the reply.

However unfortunately I didn’t get what I want.

Suresh B. : I have executed both the query, I got results but...

Jeff Moden (5/14/2012)

---

Geoff A (5/14/2012)

---

Hi Lynn,

Q1: Why were table variables introduced when temporary tables were already available?

A1: Table variables have the following advantages over temporary tables: •As mentioned in the...

or this;

select *

From ReportServer.dbo.Subscriptions Subscriptions

where(LastStatus like '%[1-9] errors.'

or LastStatus like 'Error%'

or LastStatus like 'Failure%')

and LastRunTime >= GetDate() - 2

I know that, But manual failover still changes server names on the app side.

re-install with new instance name is the recommened method.

yes, because the...

i have had this issue with a product from a vendor called GFI.

it creates a new database based on time or number of rows in the staging table.

no matter what...

Perry Whittle (5/14/2012)

---

with replication you have a manual failover action, depending upon your mirror session type this will also be either manual or automatic failover. For sessions using a witness...

and by Admin login, i mean the NT SERVICE account.

and it its the default instance, you will have to change the server name too.

sometimes, it just easier to re-install. but...

you do this with sp_dropserver and sp_addserver

a restart will be required.

you will also have to handle the Admin login, msdb SQL Agent jobs and linked servers (if any)...

Hi Lynn,

Q1: Why were table variables introduced when temporary tables were already available?

A1: Table variables have the following advantages over temporary tables: •As mentioned in the SQL Server Books Online...

or even better, declare a table variable.

declare @temp table (MyColumns varchar(128),......)

insert into @temp

exec usp_myprocedure

you always could let the app create the databases and then move the files by de-attaching and re-attachning them. the app will not care (or at least is should not...

thanks for the reply.

just reading your response made me consider things I had not previously considered.

in my case, i guess my biggest worry is this senario;

Server1 has a single 150...

http://www.lmgtfy.com/?q=set+up+transactional+Replication+on+SQL+Server+2008