Create Pull Subscription from client

I am trying to create a pull subscription through RMO as described in books online. However, the only way that the creation (or deletion) will succeed is if the windows user that is creating the subscription is a member of the sysadmin role on the publisher. The windows login has been added to the PAL for the publication, but this seems to have no effect. The windows login has been added to the subscription database and is a member of the dbo role.

Please help!

Thanks!

More Info:

This is a nonupdateable transactional publication on SS05 64bit standard edition SP1. The client is .net 2 Sql Express SP2.

create index with drop existing

Create index with drop existing after succesfull creation,
when dbcc checktable is run, at times it does not finish
at all, when killed and again submitted runs okay.
Vinodh,
Are you saying that the dbcc does not finish or the create index? How long
did you wait? How big is the table, and how many indexes on there?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Vinodh" <anonymous@.discussions.microsoft.com> wrote in message
news:b85901c437d6$ef3b81c0$a401280a@.phx.gbl...
> Create index with drop existing after succesfull creation,
> when dbcc checktable is run, at times it does not finish
> at all, when killed and again submitted runs okay.
>

create index with drop existing

Create index with drop existing after succesfull creation,
when dbcc checktable is run, at times it does not finish
at all, when killed and again submitted runs okay.Vinodh,
Are you saying that the dbcc does not finish or the create index? How long
did you wait? How big is the table, and how many indexes on there?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Vinodh" <anonymous@.discussions.microsoft.com> wrote in message
news:b85901c437d6$ef3b81c0$a401280a@.phx.gbl...
> Create index with drop existing after succesfull creation,
> when dbcc checktable is run, at times it does not finish
> at all, when killed and again submitted runs okay.
>

create index with drop existing

Create index with drop existing after succesfull creation,
when dbcc checktable is run, at times it does not finish
at all, when killed and again submitted runs okay.Vinodh,
Are you saying that the dbcc does not finish or the create index? How long
did you wait? How big is the table, and how many indexes on there?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Vinodh" <anonymous@.discussions.microsoft.com> wrote in message
news:b85901c437d6$ef3b81c0$a401280a@.phx.gbl...
> Create index with drop existing after succesfull creation,
> when dbcc checktable is run, at times it does not finish
> at all, when killed and again submitted runs okay.
>

Create DTS PACKAGE programmatic

Hi guys..!!

i am working on Dynamic creation of DTS-packages in C#.NET 2005(sql server 200)

but i not must create package in Sql Server.
but i cant...

can i do ?
any ideas ?

thx...

DTS has a Save as VB option. This is a great way of getting sample code, so try that on a demo package. VB to VB.Net has some differences, see this link for some tips.

Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net
(http://www.sqldts.com/default.aspx?264)

VB.Net to C# should not be hard, plenty of tools that do this.

Hopefully when you view the VB sample code you will get a feel for the object model and how it is used, and going forward you can just write the C# directly.

There is a DTS specific newsgroup (microsoft.public.sqlserver.dts) which may be worth search and posting on, as it is DTS not SSIS focused.

|||

but this source not contain code for vb or vb.net
no problem is writing vb or vb.net

problem is "how to create programmatic (dynamic) DTS-Package in dotnet? "

thx...

|||

You appear to be repeating yourself, so can we try again...

Mehmet Metin Altuntas wrote:

problem is "how to create programmatic (dynamic) DTS-Package in dotnet? "

To create a DTS package dynamically in dotnet you need to write some code. DTS uses an object model, have you added a reference?

Mehmet Metin Altuntas wrote:

but this source not contain code for vb or vb.net

What is not source code? I suggested using the Save as VB option to generate some sample code. If you already know how to use the DTS object model in code, what are you asking? If you do not know how to use the DTS object model in code, try generating some sample code as a guide.

Mehmet Metin Altuntas wrote:

no problem is writing vb or vb.net

Sorry, that does not make sense.

The Save as VB option wil give you VB code. The link told you how to convert this to VB.net. There are tools that convert VB.net to C#. It may be a three stage process but it will give you C# code. Once you are familiar with this you can write c# directly, but to HELP you LEARN how to use it in code, Save as VB is a start point.

Surely some code, even VB is easier to learn from than no code at all. There is no Save As C# option, so learn from the VB.

Any help?

Create DB using OSQL is SLOW

The creation of a database, tables, stored procs, etc is EXTREMELY slow. This same script with Sql Server 2000 took about 8-10 minutes is now taking 45-50 minutes with Sql Server 2005.

This is an example: osql -E -S (local) -n -d <DB> -i <StoredProc>.sql

using SQL Server 9.0.1399

Any thoughts are appreciated.

with sql server 2005 you should use sqlcmd instead. You should find that is faster.

Create Database on Remote server specifying a path

using SQL SERVER 2K
I have registered a server that sits on TestServer\TestInstance and I have a
bunch of Database and table creation scripts... but I didn't think it was
possible to run something like the following unless it was run from that
actual machine (while at the machine or TermServed in or in some way remotel
y
controlling the box )
Create Database MYDB on(name=N'MYDB_DATA',
filename=N'E:\SQLDATA\MYDB_DATA.MDF,...)'
I know that I can use EM to visually create each database and then script
the tables, but the scripted option would be nice and quick.Kevin,
Connect via Query Analyzer or OSQL to the TestServer\TestInstance and run
the create database script.
HTH
Jerry
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:4257D77D-4BC8-44C9-B69C-7BD9F2793E7D@.microsoft.com...
> using SQL SERVER 2K
> I have registered a server that sits on TestServer\TestInstance and I have
> a
> bunch of Database and table creation scripts... but I didn't think it was
> possible to run something like the following unless it was run from that
> actual machine (while at the machine or TermServed in or in some way
> remotely
> controlling the box )
> Create Database MYDB on(name=N'MYDB_DATA',
> filename=N'E:\SQLDATA\MYDB_DATA.MDF,...)'
> I know that I can use EM to visually create each database and then script
> the tables, but the scripted option would be nice and quick.
>|||Jerry,
I actually did that just before I begin this post, went to the john and
strolled my slow ass back and it finally completed in 15:54. This explains
why it was failing from VS, it was timing out.
"Jerry Spivey" wrote:

> Kevin,
> Connect via Query Analyzer or OSQL to the TestServer\TestInstance and run
> the create database script.
> HTH
> Jerry
> "kevin" <kevin@.discussions.microsoft.com> wrote in message
> news:4257D77D-4BC8-44C9-B69C-7BD9F2793E7D@.microsoft.com...
>
>