Showing posts with label assume. Show all posts
Showing posts with label assume. Show all posts

Tuesday, March 6, 2012

Adding Misc files to Solution Explorer

I assume this is the best forum for this quesiton; if not, please direct me.

I have noticed that I can add (for example) a text file to a misc folder in a SQL Server project by dragging and dropping the file from Windows Explorer onto the Misc folder inside the SQL Server project. Is this the only way to add a file?

I noticed, for example, I could not copy and past to the Misc file folder.
Is there another way? If so, what is it? what is the preferred way?

I noticed that there have bee 55 views of this thread. It was posted Monday morning. would someone take a stab at it?|||The other way to add a file is to right click on the Project, select Add Existing Item, then Browse to the file in question (you need to change the File Type at the bottom to "All" in order to see text files, etc.).

Thanks, MJ

Monday, February 13, 2012

Adding column to table

Just wanted to check. Running merge replication on SQL 2000. If I add a
column to a table that is a published article, I assume I just run
sp_repladdcolumn is that correct and is that all I need to do in order for
the laptops to get the change with their next synch? Also, what do I set
the value for @.force_reinit_subscription to? Thanks.
David
Yes. However I believe you need to set @.force_reinit_subscription and
@.force_invalidate_snapshot to 1.
Basically these switches will stop your script from working if they are set
to their defaults of 0. If you set them to 1 your scripts will run but you
may have to reinitialize your subscriptions.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23IOG4PPOHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Just wanted to check. Running merge replication on SQL 2000. If I add a
> column to a table that is a published article, I assume I just run
> sp_repladdcolumn is that correct and is that all I need to do in order for
> the laptops to get the change with their next synch? Also, what do I set
> the value for @.force_reinit_subscription to? Thanks.
> David
>