pull subscription

My name is Tech guy,
I want to use window script program to execute a pull subscription installed on SQL 2005 express edition. Because it free for downloand.
is there a script that can call an existing pull subscription execution.I want to use window script program to execute a pull subscription installed on SQL 2005 express edition.
Do you mean VB or Java script...?

Using Enterprise Manager you can generate a SQL script.

select Pull Subscription -> Press Right Hand Key -> Generate SQL Script.

Modify script for subscriber name, subscriber DB etc.|||thanks Rajesh for replying my question.
Here is the problem. I created a pull subscription and pull subscription script file in SQL 2005 Management express. but the express does not have option to run a schedule job. I want to create a vb script to run that pull subscription script file. I cannot find a command for execute the pull subscription package in vb script.
example:
dim objserver
set objserver = createobject("SQLDMO.SQLserver")
obvjserver.loginsecure = true
objserver.connect "."
objserver.script, "myPullSubscription.sql"
set objserver = nothing

I need a vb command to execute mypullscubscription.sql because the one I used above does not work.|||You could launch osql.exe (or sqlcmd.exe in 2005) to execute any .sql script from a shell script.|||Can you give me an example script using osql to execute a pull subscription file. do I need to log on SQL management in order to run qsql?|||there are many resources on the net for osql. just google "osql syntax". Here's an example:

http://www.sql-server-performance.com/rd_osql.asp

it's a console app that you can use to execute arbitrary scripts. If you are on 2005, use sqlcmd.exe though. it's better. :)|||Using osql you can run any TSQL script, it's command prompt utility. You can refer Books OnLine from Query Analyzer.

Public key Token = b77a5c561934e089

Hi Ppl,

I have installed my program and SQL server 2K5 on the server.

But when I try to run it (from he client machine)I get the following error :

It works fine on the SERVER

The appication attempted to perform an operation not allowed by the security policy.

The operation required the security Exception. To grant this application the required permission

please contact your systems Administrator or use the Microsoft .NET security policy administration tool.

If you click Bla,bla,bla

Request for the permision of type System.Data.SqlClient.SqlClient

Permission, System.Data Version - 1.0.5000.0. Cultre = neutral.

Public key Token = b77a5c561934e089

did you ever solve this as I now have the same issue|||

I've done some checking and this seems to be related to the fact that you're apparently running your application from a network share. When you run a managed application from the network, you need to either trust the network or trust the assembly by adjusting the security policy on the local computer. Check out the Code Access Security information for more details.

The alternative to adjusting the security policy is to install the application onto the local computer via either ClickOnce or MSI. More details on the these tools can be found at:

For .NET 1.1 see

Smart Client Architecture and Design Guide

Chapter 7 — Deploying and Updating Smart Client Applications

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scag-ch07.asp

For .NET 2.0 see

ClickOnce

http://msdn.microsoft.com/clickonce

Regards,

Mike Wachal
SQL Express team