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 Publisher to Express Subscribers (2005)

I implemented a merge replication publication on a SQL Server 2005
Enterprise instance on a test server. On my laptop I have VS.NET 2005
installed with SQL Server 2005 Express.

It's my understanding that I can subscribe to a publication with
Express. I also have SQL Server Workgroup installed on my laptop so I'm
able to use Management Studio to control the Express instance.

The first issue I encountered was that you cannot subscribe to a
publication if you are not on the same network as the publishing
instance (it requires the actual server name). And in lieu of this I
tried to implement Web synchronization, but had problems with SSL
(which is my problem since I'm not entirely familiar with how to
implement SSL certs so they don't show the security warning on the
client without purchasing a certificate).

So then I decided to go ahead and create an account on my laptop and
add it to the domain of the test publishing server. I was then able to
subscribe to the published replication.

So then I look at my Express instance and the synchronization never
runs. In the documentation it says that you're supposed to be able to
right-click on the subscription and "View Synchronization" and force it
to run. This is not available in the Express instance, but it is
available in the Workgroup instance.

So I'm looking at cleaning up my web synchronization issues to make
that work, but I see two issues here.

1) Why do I have to specify the "real name" of the publishing database?
Why can't I access it like any other sql server via an IP address? This
seems like a highly restrictive implementation of replication to me.

2) Why do I have to implement SSL for replication? I understand the
need for security, but that should be left to me to implement. I
shouldn't be forced to use SSL as my security layer.

3) Why doesn't Express have "View Synchronization"?

Any help here is greatly appreciated.

David Cornelson

Hi David,
You should be able to use Web synchronization in your case.

Regarding your questions:
1) Not sure what you mean here. You need to have the actual and real publishing database name. Without it, we cannot know which database the subscription is referring to.

2) SSL is required for Web Synchronization. It is for Security Purposes. A security feature cannot be optional.

3) SQL Server Express does not have SQL Server Agent. Hence you do not have 'View Synchronization' (Workgroup has it and hence you see the option). You need to either use RMO or ActiveX sync components or use the Window Sync Manager to synchronizing.|||

re 1) So why can't I direct a subscriber to ipaddress\instanceName? Why does it have to be serverName\instanceName?

2) If all of my replication is done within my own company, say I have Smart Clients that are on different segments of my network, so they can't actually "see" the publishing database, I might want to use web synchronization and _not_ use SSL. You're making a security decision that I don't need. I understand that this should be default behaviour, but I should be able to turn it off. You're actually making my architecture more complex by forcing SSL into my replication strategy.

3) Where can I find information on Windows Sync Manager?

Thanks,

David C.

|||1) Not sure, but looks like there is no option for you to provide an ipaddress of the publisher to connect to. Servername/instance may be the only way.

2) Security is always a big concern and that is the reason for mandating the SSL. If you wish, you could workaround with a test certificate. MSDN has a tool for installing a test certificate.
For IIS6.0: http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&displaylang=en
For IIS5.0: http://support.microsoft.com/default.aspx?scid=kb;en-us;228984

3) Windows Sync manager comes with Standard windows installation. Books online has more information about synchronizing using Sync Manager. To open Sync Manager follow either of the steps:
a) Windows Explorer-->Tools-->Synchronize
b) Start-->AllPrograms-->Accessories-->Synchronize|||1) Okay

2) Alright

3) It only has a Sql Server 2000 and an IE sync listed. Where's 2005?

Thanks for the help.

David C.|||3) I dont understand what you are saying. Where do you see SQL Server 2000 listed?
Windows sync manager is a windows mechanism for synchronization which can be launched using the 2 methods I described in my previous post. You have to enable the subscription on the Subscriber to be using the Windows Sync Manager. Once you have done that, you will start seeing the subscription in the Sync Manager and you can synchronize the subscription with the publication at the Publisher.

Enterprise Or Express Edition?

Hello. Through something called the MSDN Academic Alliance (MSDNAA), I installed what what they told me was going to be SQL Server 2005 Developer Edition. However, using the shared directory on their server, the installation program read "Enterprise Edition." Using a method found at KB article 321185, "How to identify your SQL Server version and edition," I finally figured out that I was using 9.00.1399.06/RTM/Express Edition.

Express Edition? The downloadable file at Microsoft is 55MB. My installation is over 500MB. Is there any way I can quickly check whether I have the Enterprise Edition? I have a feeling something in the installation was warped.

Example: How can I quickly do something that requires FULL-TEXT SEARCH?

Thanks.

Alex

If you do a select @.@. version it will tell your the SKU that you have installed.

Michelle

|||

Hello. Where would you do this? I did the following,

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

...under New Query and ran it. It gives me EXPRESS EDITION. Where would you type in your line -- and what exactly is it you want me to type?

Thanks!

Alex

|||

Can someone answer my question precisely, please? I really need this to get started. If it is the Express Edition I am working with, I have to uninstall and return the product; if the 500+ MB sitting in the directory are in fact the Enterprise Edition, then I can get to work.

|||

Yes the query you ran works fine. The alternative method is In a tsql window when you are connected to the server you would exectue "select @.@.version" which also gives you all the properties back in one string.

Yes you have Express Edition installed.

sql

Enterprise Mgr Snap-In Issue

I have been running SQL Server 2000, client tools only.
i installed SQL Server Express (and associated .NET
framework upgrade) to take a look.
I then uninstalled sql server express and went back to
version 1.1 of .NET framework.
My query analyzer works fine, however when i try to load
Enterprise Manager, it says:
Snap-in failed to initialize.
Name: Microsoft SQL Enterprise Manager
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I have looked through the knowledge base articles and
have not found one specific to my situation.
I have uninstalled/reinstalled sql server 2000 (and
therefore, MDAC as well) and I am running into the same
issues.
Any help is appreciated.
Did you try regsvr32 c:\...\...\sqldmo.dll
http://www.aspfaq.com/
(Reverse address to reply.)
"RR" <anonymous@.discussions.microsoft.com> wrote in message
news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
> I have been running SQL Server 2000, client tools only.
> i installed SQL Server Express (and associated .NET
> framework upgrade) to take a look.
> I then uninstalled sql server express and went back to
> version 1.1 of .NET framework.
> My query analyzer works fine, however when i try to load
> Enterprise Manager, it says:
> Snap-in failed to initialize.
> Name: Microsoft SQL Enterprise Manager
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I have looked through the knowledge base articles and
> have not found one specific to my situation.
> I have uninstalled/reinstalled sql server 2000 (and
> therefore, MDAC as well) and I am running into the same
> issues.
> Any help is appreciated.
|||I just tried it with the same result.

>--Original Message--
>Did you try regsvr32 c:\...\...\sqldmo.dll
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"RR" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
load
>
>.
>
|||> I just tried it with the same result.
Did you find the actual sqldmo.dll file that corresponds to the SQL Server
2000 install? Or did you run exactly what I posted? Did you get a dialog
that told you the registration was successful?
http://www.aspfaq.com/
(Reverse address to reply.)
|||Yes - the file came from the sql 2000 install and
received a message that is was successful.

>--Original Message--
>Did you find the actual sqldmo.dll file that corresponds
to the SQL Server
>2000 install? Or did you run exactly what I posted?
Did you get a dialog
>that told you the registration was successful?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>.
>
|||You might want to post your issue and any relevant log files from the
install/uninstall to the SQL Server 2005 newsgroups. I'm sure they are
dealing with a lot of similar issues.
For information on access to those groups:
http://communities.microsoft.com/new...elcomePage.htm
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:508f01c489e1$cf7b55b0$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes - the file came from the sql 2000 install and
> received a message that is was successful.
>
> to the SQL Server
> Did you get a dialog
sql

Enterprise Mgr Snap-In Issue

I have been running SQL Server 2000, client tools only.
i installed SQL Server Express (and associated .NET
framework upgrade) to take a look.
I then uninstalled sql server express and went back to
version 1.1 of .NET framework.
My query analyzer works fine, however when i try to load
Enterprise Manager, it says:
Snap-in failed to initialize.
Name: Microsoft SQL Enterprise Manager
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I have looked through the knowledge base articles and
have not found one specific to my situation.
I have uninstalled/reinstalled sql server 2000 (and
therefore, MDAC as well) and I am running into the same
issues.
Any help is appreciated.Did you try regsvr32 c:\...\...\sqldmo.dll
http://www.aspfaq.com/
(Reverse address to reply.)
"RR" <anonymous@.discussions.microsoft.com> wrote in message
news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
> I have been running SQL Server 2000, client tools only.
> i installed SQL Server Express (and associated .NET
> framework upgrade) to take a look.
> I then uninstalled sql server express and went back to
> version 1.1 of .NET framework.
> My query analyzer works fine, however when i try to load
> Enterprise Manager, it says:
> Snap-in failed to initialize.
> Name: Microsoft SQL Enterprise Manager
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I have looked through the knowledge base articles and
> have not found one specific to my situation.
> I have uninstalled/reinstalled sql server 2000 (and
> therefore, MDAC as well) and I am running into the same
> issues.
> Any help is appreciated.|||I just tried it with the same result.

>--Original Message--
>Did you try regsvr32 c:\...\...\sqldmo.dll
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"RR" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
load[vbcol=seagreen]
>
>.
>|||> I just tried it with the same result.
Did you find the actual sqldmo.dll file that corresponds to the SQL Server
2000 install? Or did you run exactly what I posted? Did you get a dialog
that told you the registration was successful?
http://www.aspfaq.com/
(Reverse address to reply.)|||Yes - the file came from the sql 2000 install and
received a message that is was successful.

>--Original Message--
>Did you find the actual sqldmo.dll file that corresponds
to the SQL Server
>2000 install? Or did you run exactly what I posted?
Did you get a dialog
>that told you the registration was successful?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>.
>|||You might want to post your issue and any relevant log files from the
install/uninstall to the SQL Server 2005 newsgroups. I'm sure they are
dealing with a lot of similar issues.
For information on access to those groups:
url]
[url]http://www.aspfaq.com/" target="_blank">http://communities.microsoft.com/ne...www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:508f01c489e1$cf7b55b0$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes - the file came from the sql 2000 install and
> received a message that is was successful.
>
> to the SQL Server
> Did you get a dialog

Enterprise Mgr Snap-In Issue

I have been running SQL Server 2000, client tools only.
i installed SQL Server Express (and associated .NET
framework upgrade) to take a look.
I then uninstalled sql server express and went back to
version 1.1 of .NET framework.
My query analyzer works fine, however when i try to load
Enterprise Manager, it says:
Snap-in failed to initialize.
Name: Microsoft SQL Enterprise Manager
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I have looked through the knowledge base articles and
have not found one specific to my situation.
I have uninstalled/reinstalled sql server 2000 (and
therefore, MDAC as well) and I am running into the same
issues.
Any help is appreciated.Did you try regsvr32 c:\...\...\sqldmo.dll
--
http://www.aspfaq.com/
(Reverse address to reply.)
"RR" <anonymous@.discussions.microsoft.com> wrote in message
news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
> I have been running SQL Server 2000, client tools only.
> i installed SQL Server Express (and associated .NET
> framework upgrade) to take a look.
> I then uninstalled sql server express and went back to
> version 1.1 of .NET framework.
> My query analyzer works fine, however when i try to load
> Enterprise Manager, it says:
> Snap-in failed to initialize.
> Name: Microsoft SQL Enterprise Manager
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I have looked through the knowledge base articles and
> have not found one specific to my situation.
> I have uninstalled/reinstalled sql server 2000 (and
> therefore, MDAC as well) and I am running into the same
> issues.
> Any help is appreciated.|||I just tried it with the same result.
>--Original Message--
>Did you try regsvr32 c:\...\...\sqldmo.dll
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"RR" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
>> I have been running SQL Server 2000, client tools only.
>> i installed SQL Server Express (and associated .NET
>> framework upgrade) to take a look.
>> I then uninstalled sql server express and went back to
>> version 1.1 of .NET framework.
>> My query analyzer works fine, however when i try to
load
>> Enterprise Manager, it says:
>> Snap-in failed to initialize.
>> Name: Microsoft SQL Enterprise Manager
>> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
>> I have looked through the knowledge base articles and
>> have not found one specific to my situation.
>> I have uninstalled/reinstalled sql server 2000 (and
>> therefore, MDAC as well) and I am running into the same
>> issues.
>> Any help is appreciated.
>
>.
>|||> I just tried it with the same result.
Did you find the actual sqldmo.dll file that corresponds to the SQL Server
2000 install? Or did you run exactly what I posted? Did you get a dialog
that told you the registration was successful?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Yes - the file came from the sql 2000 install and
received a message that is was successful.
>--Original Message--
>> I just tried it with the same result.
>Did you find the actual sqldmo.dll file that corresponds
to the SQL Server
>2000 install? Or did you run exactly what I posted?
Did you get a dialog
>that told you the registration was successful?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>.
>|||You might want to post your issue and any relevant log files from the
install/uninstall to the SQL Server 2005 newsgroups. I'm sure they are
dealing with a lot of similar issues.
For information on access to those groups:
http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm
--
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:508f01c489e1$cf7b55b0$a301280a@.phx.gbl...
> Yes - the file came from the sql 2000 install and
> received a message that is was successful.
>
> >--Original Message--
> >> I just tried it with the same result.
> >
> >Did you find the actual sqldmo.dll file that corresponds
> to the SQL Server
> >2000 install? Or did you run exactly what I posted?
> Did you get a dialog
> >that told you the registration was successful?
> >
> >--
> >http://www.aspfaq.com/
> >(Reverse address to reply.)
> >
> >
> >.
> >

Enterprise Manager?

If I understand correctly, Enterprise manager has been replaced with SQL Ser
ver 2005
Express?
Can I use SQL Server 2005 Express from my desktop to connect to an SQL 2000
database on
the internet?
Thanks,
VicAm Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:

> If I understand correctly, Enterprise manager has been replaced with SQL S
erver 2005
> Express?
> Can I use SQL Server 2005 Express from my desktop to connect to an SQL 200
0 database on
> the internet?
> Thanks,
> Vic
You can use the new Server Management Studio Express to manage SQL2005 and
SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 to
work with SQL2005. Only EM is not compatible.
And if you connect over internet, then the only problems may be when
routers or firewalls are not right configured. I support all my clients, no
matter if MSDE, SQLExpress or any other server edition, over internet.
bye, Helmut|||"Helmut Woess" wrote...
> Am Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:
>
on[vbcol=seagreen]
> You can use the new Server Management Studio Express to manage SQL2005 and
> SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 t
o
> work with SQL2005. Only EM is not compatible.
> And if you connect over internet, then the only problems may be when
> routers or firewalls are not right configured. I support all my clients, n
o
> matter if MSDE, SQLExpress or any other server edition, over internet.
> bye, Helmut
Thanks, Helmut!
From here:
http://msdn.microsoft.com/vstudio/express/sql/download/
I downloaded "SQL Server 2005 Express Edition with Advanced Services SP1" be
cause it
supports full-text search (which my SQL 2000 db uses). Is that all I need?
How does my firewall need to be configured? I assume that if I access my db
over the
Internet, Server Management Studio Express will require a particular port to
access my
db over the Internet.
Also, can Server Management Studio Express be used to access a remote mysql
database?
Thanks so much!!!
Vic

enterprise manager doesn't load

me bad - i installed visual studio (with sql express) then put the patches on
and sp2 for sql express.. then loaded the development version -- now
enterprise manager for sql 2005 won't load --
how do i make it - it doesn't give an error - just isn't there.
Do you mean Management Studio?
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.
|||yes - it turns out that you have to have IIS installed to allow the
management studio to work - seems stupid to me - but it is what it is.
"Aaron Bertrand [SQL Server MVP]" wrote:

> Do you mean Management Studio?
>
> "Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
> news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
>
>
|||> yes - it turns out that you have to have IIS installed to allow the
> management studio to work - seems stupid to me - but it is what it is.
Well, that's not true because I use Management Studio on several systems
without IIS configured. But maybe you tripped something else when you
installed IIS. <shrug>
|||You don't need to have IIS installed to run SQL Server 05 or any of it's
tools.
Your issue may be caused by conflicts with .NET framework 2.0. Try
uninstalling the 2.0 framework and then reinstalling the latest copies from
Microsoft.
Search MS knowledge base and you'll find that many users have had problems
with sql server 05 and .NET 2.0
Sincerely,
John K
Knowledgy Consulting, LLC
www.knowledgy.org
Atlanta's Business Intelligence and Knowledge Management Experts
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.

Enterprise manager compatibility

Hi
I trying register SQL Server 2005 Express Edition instance in Enterprise
Manager 2000 without success. Enterprise Manager 2000 do see instance and
lists its name in the list of available servers. But connection check
returns error: "SQL Server does not exist or access denied. ConnectionOpen
(Connect())".
Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?Igor Solodovnikov (IgorSolodovnikov@.discussions.microsoft.com) writes:
> I trying register SQL Server 2005 Express Edition instance in Enterprise
> Manager 2000 without success. Enterprise Manager 2000 do see instance and
> lists its name in the list of available servers. But connection check
> returns error: "SQL Server does not exist or access denied. ConnectionOpen
> (Connect())".
> Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?
No, you cannot connect to SQL 2005 with Enterprise Manager 2000. Query
Analyzer works though. (With some restrictions.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Igor Solodovnikov wrote:
> Hi
> I trying register SQL Server 2005 Express Edition instance in Enterprise
> Manager 2000 without success. Enterprise Manager 2000 do see instance and
> lists its name in the list of available servers. But connection check
> returns error: "SQL Server does not exist or access denied. ConnectionOpen
> (Connect())".
> Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?
No. Use SQL Server Management Studio for 2005. SSMS can also manage SQL
Server 2000 instances.
David Portas
SQL Server MVP
--

Entering data into tables

How does one enter data into the tables of a new database in the first place? I'm using SQL Server Management Studio Express. I can name the columns, but that seems to be as far as I get. Thanks for any Help.

I would recommend you use the T-SQL INSERT statement for adding data to the table.

Please take a look at the following tutorial titled "Inserting and Updating Data In a Table"

http://msdn2.microsoft.com/en-us/library/ms365309.aspx.

Kind Regards,
Jaaved

|||

Thanks a lot, as you can tell, I'm brand new to this SQL. Just trying to learn the ropes.

Thanks again.