Enumerate Subscriptions in a Merge Replicated CE Database?

How can I list all of the Subscriptions in a CE Database that was created with the .Net System.Data.SqlServerCe.SqlCeReplication.AddSubscription method?

After I create the CE database in an sdf file, I can connect to it with SQL Servr Mgmt Studio, then see the list of Subscriptions in the Object TreeView, under "Replication"

But I can't find that Subscription list in any properties or methods of System.Data.SqlServerCe.SqlCeReplication or System.Data.SqlServerCe.SqlCeConnection

Should I be looking in RMO features like Microsoft.SqlServer.Replication?

We want to confirm that a local CE database was last synced from the expected SQL Server database by checking the Publisher property of each subscription in the CE database.

Thanks

There are a number of system tables available with all the required information, see http://blogs.msdn.com/sqlservercompact/archive/2007/02/19/howto-detect-the-database-is-merge-replicated.aspx|||

Thanks.

Relational database systems keep their data in relational tables - even SQL Server CE!

Select*from __sysMergeSubscriptions

;Select*from __sysMergeArticles

entity relationship diagram

I have VS 2005 and SQL Server 2005 Express installed and I created 4 tables and setup the primary and foreign keys and can view the individual foreign key relationships by right clicking on the foreign key.

Is there a way to view a table relationship diagram (fields with primary and foreign keys), such as Access provides. Does VS 2005 or SQL Server 2005 have that capability?

Thanks

If you right-click on the folder named Database Diagrams, you can create a databse diagram. You can create a diagram here. To view the folder, click the plus sign next to the database that you want to create the diagram for.

Enterprise Manger Crash Creating user

Please can you help with this?
I created a new users for the first time in SQL Server 2000. While doing
that, Enterprise Manager crashed...and:
1. If I try to add the user again, I get an error because the User already
exists...yet I cannot see it on the console.
2. The user name does not show under Users (or Roles)
Any idea what I need to do to fix it - or what I might be doing wrong?
Is there a problem with Enterprise manager, how can it be fixed? (Looks to
me like it fails while waiting for a response from NT...)Patrik
Open Query Analyzer and use
sp_adduser ,sp_dropuser system stored procedures
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
> Please can you help with this?
> I created a new users for the first time in SQL Server 2000. While
> doing
> that, Enterprise Manager crashed...and:
> 1. If I try to add the user again, I get an error because the User already
> exists...yet I cannot see it on the console.
> 2. The user name does not show under Users (or Roles)
> Any idea what I need to do to fix it - or what I might be doing wrong?
> Is there a problem with Enterprise manager, how can it be fixed? (Looks
> to
> me like it fails while waiting for a response from NT...)
>|||Thx.
Q. Does a SQL Server User Id have be created on the NT Server on which SQL
Server resides? Or can the NT user id be on another server?
"Uri Dimant" wrote:

> Patrik
> Open Query Analyzer and use
> sp_adduser ,sp_dropuser system stored procedures
>
>
>
> "Patrick" <Patrick@.discussions.microsoft.com> wrote in message
> news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
>
>|||Patrick
Users and Logins are two different things
1)Logins are created to allow the person access to SQL Server .
2) Users are created to grant/allow access to the database/s located on the
server
http://vyaskn.tripod.com/sql_server...t_practices.htm --sec
urity
best practices
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:21715426-1674-48EE-A782-0709C183E456@.microsoft.com...[vbcol=seagreen]
> Thx.
> Q. Does a SQL Server User Id have be created on the NT Server on which
> SQL
> Server resides? Or can the NT user id be on another server?
> "Uri Dimant" wrote:
>

Enterprise Manager User Log-in DB Visability

I have created new login in my Enterprise Manager. The login is not part of any roles and only allowed access to 1 database (of 200). However, they can see all the databases in Enterprise Manager.

They can't do anything with them, but I don't even want them to see them.

Have I set something up wrong?Hi ,

I posted earlier the same questune , i think that its not possible for users wont be bale to see the dbs , but i couldnt prevent also access to the master db objects that is realy bad thing .|||There must be something that can be done! How would an ISP that wants to host SQL Server for people deal with it?

Enterprise manager (romote connection problem)

hi everybody

i have a problem while trying to connect to my sql server database

1st i have created my database from my HELM control panel

database name :ramy

IP Address: 74.52.76.178

Local Port: 1433

Remote Port: 1501

thats all but now iam trying to open it via ms sql server enterprise manager but i cant

1st i click on register server

then he ask me for available servers i write :74.52.76.178

then i select sql server login info

then he asks about username and password

username : ramy

password : 5402248

(these are correct values ) use it freely its just for trials

i get error message that he cant connect or login faliure

my question now

where i put the ip address and where to put the port

thanks

well this question should be posted to a SQL Server forum because this forum is for accessing databases via ASP.NET through programming.

Also, for the sake of security and my faith in mankind : Dont post your ip address, username, and password. Your just Begging people to come hack you.

mcm

|||

at all thanks man for your reply

about hacking my database never mind about this as i said its trial database

i dont know where is this forum you talk about

i which somebody help me

|||

MSDN Forums SQL Threads are here :

http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1

hth,mcm

Enterprise Manager (Import Data) - DTS Error

I created a new database in Enterprise Manager and then attempted to import data into this new database from an existing database via the "import data" option. This launches the Data Transformation Services Import/Export Wizard. I select the data source
. I select the destination. I select 'Copy table(s) and view(s) from source database." I select all tables. I select the 'run immediatedly' option. When I click the 'Finish' button, I receive the following message in a message box entitled 'Initializ
e Com:"
Could not create an instance of the DTS Package.
Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.
Problem solved. I installed SP3a and import/export works fine now.
"Ross Russell" wrote:

> I created a new database in Enterprise Manager and then attempted to import data into this new database from an existing database via the "import data" option. This launches the Data Transformation Services Import/Export Wizard. I select the data sour
ce. I select the destination. I select 'Copy table(s) and view(s) from source database." I select all tables. I select the 'run immediatedly' option. When I click the 'Finish' button, I receive the following message in a message box entitled 'Initial
ize Com:"
> Could not create an instance of the DTS Package.
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.

Enterprise Manager (Import Data) - DTS Error

I created a new database in Enterprise Manager and then attempted to import
data into this new database from an existing database via the "import data"
option. This launches the Data Transformation Services Import/Export Wizard
. I select the data source
. I select the destination. I select 'Copy table(s) and view(s) from sourc
e database." I select all tables. I select the 'run immediatedly' option.
When I click the 'Finish' button, I receive the following message in a mess
age box entitled 'Initializ
e Com:"
Could not create an instance of the DTS Package.
Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.Problem solved. I installed SP3a and import/export works fine now.
"Ross Russell" wrote:

> I created a new database in Enterprise Manager and then attempted to import data i
nto this new database from an existing database via the "import data" option. This
launches the Data Transformation Services Import/Export Wizard. I select the data s
our
ce. I select the destination. I select 'Copy table(s) and view(s) from sou
rce database." I select all tables. I select the 'run immediatedly' option
. When I click the 'Finish' button, I receive the following message in a me
ssage box entitled 'Initial
ize Com:"
> Could not create an instance of the DTS Package.
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.