I have an article with 70,000 rows in it. I need to run an update script
from the subscriber that will update all 70,00 rows. Is there anyway I can
prevent these changes from being replicated? I realize I can drop the
trigger so the rows are not added to msmerge_contents. I'm looking for a
more automated approach since my subscribers are running MSDE.
TIA
Tina
do a sync with your merge agent, make sure it is not running in continuous
mode. Then when it has completed and shut down, set the -ExchangeType
parameter to Download, then restart your merge agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tina Smith" <tb.smith@.earthlink.net> wrote in message
news:OGOALZ56EHA.936@.TK2MSFTNGP12.phx.gbl...
> I have an article with 70,000 rows in it. I need to run an update
script
> from the subscriber that will update all 70,00 rows. Is there anyway I
can
> prevent these changes from being replicated? I realize I can drop the
> trigger so the rows are not added to msmerge_contents. I'm looking for a
> more automated approach since my subscribers are running MSDE.
> TIA
> Tina
>
|||Thanks Hilary, I'll give it a shot.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23fqa4$B7EHA.1564@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> do a sync with your merge agent, make sure it is not running in continuous
> mode. Then when it has completed and shut down, set the -ExchangeType
> parameter to Download, then restart your merge agent.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Tina Smith" <tb.smith@.earthlink.net> wrote in message
> news:OGOALZ56EHA.936@.TK2MSFTNGP12.phx.gbl...
> script
> can
a
>
Showing posts with label article. Show all posts
Showing posts with label article. Show all posts
Friday, March 23, 2012
Monday, March 12, 2012
Manual creation of DSNs
I'm trying to adapt the code in the article "How to Create ODBC DSN on
multiple SQL server Machines"
(http://www.databasejournal.com/feat...cle.php/2238221) to
create a script that will automate the creation of SQL Server DSNs.
The article's code writes the DSN to the appropriate location in the
registry--HKLM\SOFTWARE\ODBC\ODBC.INI\<DSN Name>. However, the code doesn't
seem to address how to write the SQL UserID and Password. It appears that
the SQL driver doesn't store that information in the registry.
Any suggestions on how to proceed? Thanks!"Stan" <NoSpam@.I> wrote in message
news:#qSSJ77zDHA.1740@.TK2MSFTNGP09.phx.gbl...
doesn't
This article was designed to use Trusted Connections -- reference the
TrustedConnection = "yes" entry.
Usually it's not a good idea to embed the user name and password with the
DSN entry. Consider using DSN-less entries if you are writing a VB
application to access SQL Server. Here is a starting point for the
connection strings: http://www.able-consulting.com/ADO_Conn.htm
Steve
multiple SQL server Machines"
(http://www.databasejournal.com/feat...cle.php/2238221) to
create a script that will automate the creation of SQL Server DSNs.
The article's code writes the DSN to the appropriate location in the
registry--HKLM\SOFTWARE\ODBC\ODBC.INI\<DSN Name>. However, the code doesn't
seem to address how to write the SQL UserID and Password. It appears that
the SQL driver doesn't store that information in the registry.
Any suggestions on how to proceed? Thanks!"Stan" <NoSpam@.I> wrote in message
news:#qSSJ77zDHA.1740@.TK2MSFTNGP09.phx.gbl...
quote:
> I'm trying to adapt the code in the article "How to Create ODBC DSN on
> multiple SQL server Machines"
> (http://www.databasejournal.com/feat...cle.php/2238221) to
> create a script that will automate the creation of SQL Server DSNs.
> The article's code writes the DSN to the appropriate location in the
> registry--HKLM\SOFTWARE\ODBC\ODBC.INI\<DSN Name>. However, the code
doesn't
quote:
> seem to address how to write the SQL UserID and Password. It appears that
> the SQL driver doesn't store that information in the registry.
> Any suggestions on how to proceed? Thanks!
This article was designed to use Trusted Connections -- reference the
TrustedConnection = "yes" entry.
Usually it's not a good idea to embed the user name and password with the
DSN entry. Consider using DSN-less entries if you are writing a VB
application to access SQL Server. Here is a starting point for the
connection strings: http://www.able-consulting.com/ADO_Conn.htm
Steve
Saturday, February 25, 2012
Management Stusio install via SMS
s there a way to only install sql management studio via SMS?
I found the article on the unattend install, but I do not want the connectivity tools, etc.
I only need the management studio portion installed, nothing elsre. Has anyone accomplished this?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478384&SiteID=1|||I replied to that post, but it did not really help me out.
I do not know the msi
|||IS SSMSE (SQL Server Management Studio Express) any help here?
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
|||The full Management Studio application is able to manage all our SQL Server products - including SQL Server, Analysis Services, Integration Services, and SQL Server Agent. Because of its scope, SSMS has a lot of dependencies under the covers that end needing most of the components you aren't interested in running in order to start.
We tailored Management Studio Express to not have all those dependencies, so the install is fairly small and doesn't bring in anything other than what's needed to work with the SQL Server relational engine. Management Studio Express is missing functionality from the full SSMS that some users use frequently, like the ability to work with SQL Server Agent and SSIS, which prevents it from working with maintenance plans, importing and exporting data using a wizard, and using a wizard to copy databases. If you don't use that functionality, SSMSE might work well for you.
You can download SSMS Express here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en
Hope this helps,
Steve
Management Stusio install via SMS
s there a way to only install sql management studio via SMS?
I found the article on the unattend install, but I do not want the connectivity tools, etc.
I only need the management studio portion installed, nothing elsre. Has anyone accomplished this?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478384&SiteID=1|||I replied to that post, but it did not really help me out.
I do not know the msi
|||IS SSMSE (SQL Server Management Studio Express) any help here?
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
|||The full Management Studio application is able to manage all our SQL Server products - including SQL Server, Analysis Services, Integration Services, and SQL Server Agent. Because of its scope, SSMS has a lot of dependencies under the covers that end needing most of the components you aren't interested in running in order to start.
We tailored Management Studio Express to not have all those dependencies, so the install is fairly small and doesn't bring in anything other than what's needed to work with the SQL Server relational engine. Management Studio Express is missing functionality from the full SSMS that some users use frequently, like the ability to work with SQL Server Agent and SSIS, which prevents it from working with maintenance plans, importing and exporting data using a wizard, and using a wizard to copy databases. If you don't use that functionality, SSMSE might work well for you.
You can download SSMS Express here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en
Hope this helps,
Steve
Subscribe to:
Posts (Atom)