1. Stopping SQL Server Agent will allow you to open Outlook on the active node.  Essentially you have a sharing violation

2.  We were able to get mail to work on an...

Check the port that sql server is running on.  You may need to add it to this:

data source=10.9.675.3,port#;

Another technique which seems easy is to create a sql server...

Is your password using special charachters ie & which needs to be translated in the web.config (xml)

replace & with &

 <add key="connString" value="data source=mysqlserver; initial catalog=northwind; workstation id=webserver; User ID=webuser;Password=pass&amp;word" />

The old data will not be syncronized if you select "subscription already has schema and data", when you create the subscription. 

If you select "Yes, initialize schema and data", then...

Try this:

-- set the value to your query

set @ReceiptAuto = (SELECT @costCenter + RIGHT(DATEPART(yy,GETDATE()) ,2) + REPLICATE('0',5-LEN(@nextNum)) + CAST(@nextNum as varchar(5)))

"-- (I need to move a copy of this...

Yes, the statistics have been updated on both databases prior to checking the execution plan.

The query does not use an indexed view.

Thanks

If the reports are near-real time, say data needs to be current within the hour, then snapshot replication will work fine, since only the changes are applied to the subscriber.

Yes transactional...

Since your reports need to be near real-time, then "log shipping" or "snapshot" replication would be good solutions.

"Snapshot" replication will not interfere with the reports and is simple enough to...

The "owner" of the stored procedure needs permission to write to the tables in database 2.  Who owns the sproc?  When a procedure is executed it is run with the permissions of...

1. drop the subscription

2. remove the table(article) from the publication

3. Alter the column

4. Add the table(article) back into the publication

5. ReRun the snapshot

6. Create the subscription and start the merge agent; the...

This option will prevent replication conflicts:

1. Start the identity on the publisher at an odd number and increment by 2

Start the identity on the subscriber at an even number and...

See this posting.  It probably has to do with the server names between the publisher and subscriber.

Although you successfully registered the server(subscriber); the name that you registered the subscriber...

You can also try CASE in the select

t1.tid,count1,count2,(count1 - count2)

select CASE  count1 WHEN null THEN 0 END, CASE  count2 WHEN null THEN 0 END,...

See this posting.  It probably has to do with the server names between the publisher and subscriber.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=132613#bm132783

DTS Import Data wizard will work, or right-click tables..all tasks..import data.

1. Select Excell for your datasource..next

2. destination should be sql server and database you want

3. copy tables

4. select the...