Viewing 15 posts - 151 through 165 (of 1,069 total)
Non replicated object on subscriber would not break replication. 🙂
Transaction replication basicaly happens with DDL/DML SQL statements (CREATE, INSERT, UPDATE, DELETE, etc).
So objects that are not referred in the...
July 26, 2012 at 4:38 am
Changes to the replicated objects on the subscriber would interfere with transactional replication.
You can add indexes to the replicated tables on subscriber.
July 26, 2012 at 1:04 am
quackhandle1975 (7/25/2012)
Now I want to create views on the subscriber, will this break the replication?qh
Generally speaking, views on the subscriber do not break the replication.
But if the views are...
July 25, 2012 at 9:33 am
namrata.dhanawade-1143388 (7/24/2012)
Can a new table be added to the subscriber without needing to add to the Publisher?
Yes.
Will this affect the current replication in any way?
No.
Meaning will it break...
July 25, 2012 at 1:57 am
Suresh B. (7/18/2012)
You need to change the SQL Agent service Startup type to "Automatic" using Services applet.
July 18, 2012 at 11:56 pm
You need to change the SQL Agent service Startup type to "Automatic" using SQL Server Configureation Manager (or Services applet).
July 18, 2012 at 11:55 pm
I think BIN folder is not needed.
.rdl file is the required file.
If you created data source, you fill find a .rds file
You can deploy them using BIDS or Report Manager.
July 18, 2012 at 11:48 pm
Few points:
1) Run SQL Server setup program. Select the component SQL Server Reporting Services
2) If you select SSRS component, you will get option to just intall SSRS or install and...
July 18, 2012 at 4:26 am
Capture both the execution plans (slower and faster) and upload them here.
July 18, 2012 at 4:16 am
BOL:
NULL when mode = LIMITED.
July 18, 2012 at 12:52 am
TLOG backup does not contain entries which are already backedup.
July 18, 2012 at 12:05 am
durai nagarajan (6/29/2012)
Suresh B. (6/29/2012)3) Storage drive failure - Use RAID. It should be left to SAN team.
does that mean raid will have very minimal failure or SAn will...
June 29, 2012 at 6:17 am
durai nagarajan (6/29/2012)
we have to configure cluster on a 2 node server, i have to gather some points before suggesting active- passive or active - active on 2005 node.
I...
June 29, 2012 at 4:51 am
Try this:
1) Looks like the default database of the logins is deleted. Changed the default database to some other database.
2) Use Failover Cluster Manager to bring the SQL Agent resource...
June 28, 2012 at 12:23 am
You cannot take backup using linked server. Linked server is meant for querying only.
What error did you get?
I guess, it was related to permission.
Service account should have write access to...
June 20, 2012 at 4:03 am
Viewing 15 posts - 151 through 165 (of 1,069 total)