Create Database Diagram And Send To User

Aug 11, 2014

I've been tasked to create a database diagram, save it and send that db diagram to the user. Now, I am confused as I don't know where sql server stores the db diagram...what is the path where it stores the diagram. How do I export it in case if I need to provide it to the user. How, am I supposed to grant user permission so he himself can create a database diagram.

View 9 Replies


ADVERTISEMENT

Not Able To Create A DB Diagram In SQL Server 2005. No Menu Option For Creating A DB Diagram??

Apr 23, 2007

I have created a database with several tables. I want to create a database diagram to show the relationshipbetween the tables. Below are the steps from the SQL Server 2005 documentation on how to create a database diagram. The problem is that when I right click on the Database Diagrams folder I am only given two options. They are:"Working with SQL Server diagrams" and "Refresh"There is no menu choice to create a new database diagram. Can anyone tell me what the problem here is?
 
To create a new database diagramIn Object Explorer, right-click the Database Diagrams folder or any diagram in that folder.
Choose New Database Diagram on the shortcut menu.
The Add Table dialog box appears.
Select the required tables in the Tables list and click Add.
The tables are displayed graphically in the new database diagram.

View 1 Replies View Related

How To Create The ER Diagram For SQL Server Database Objects

Dec 15, 2006

Hi,I have to prepare an ER diagram for the objects in my SQL Serverdatabase. I have used the option "DIAGRAMS" in EnterPrise Manager ofSQL Server 2000. It is creating the diagram for the selected tables(but the diagram contains only the table which i have selected. It isnot displaying its depended tables). But i am not able to export it toany of the flat file like MS WORD or paint. I want this diagram to beuploaded to one Flat file and send to my customer for his reference.Could anyone suggest me how to create the ER Diagram for the SQL 2000database and export it to a flat file.Thanks for your help in advance.-Rao

View 2 Replies View Related

DB Design :: Create Diagram From Existing Database

Oct 22, 2015

Is it possible to create diagram from existing database? Need to understand the schema of database which has no documentation. So would like to create diagram for that database.

View 7 Replies View Related

After I Create A Database Using Database Diagram In SQL Server7,there's Nothing To See In 'd

Jun 10, 2001

I am a beginner in learning SQLServer 7.And I learn it by using its own help file.
The only problem troubles me is that after I do some options in database diagram,there's nothing happen.And then no matter what I do,database diagram panel is always blank.

View 2 Replies View Related

Send A Messege To User Those Who Access A Specified Database In A Server

Oct 12, 2006

/* -------------------------------------------------

The Following Procedure Helps You To

Send a Messge to all Users

those Who Access a Specified Database in a Server

*/

Create Proc Sp_SendMsg

@Msg Varchar(100),
@DbName VarChar(100)
as

if db_id(@DbName) = Null
begin
Print 'DataBase dose not Exist'
end
else

Begin
Declare @spId Varchar(1000)

DECLARE TmpCursor CURSOR FOR
Select 'master..xp_CmdShell ''Net Send ' + rtrim(convert(Varchar(50), HostName))+' "Dear ' + upper(max(rtrim(loginame)))+ space(1) + @Msg + '"''' as spId
from master..SysProcesses
where db_Name(dbID) = @DbName and
spId <> @@SpId
and rtrim(ltrim(HostName)) <> ''
and HostName <> host_Name()
and dbID <> 0
and spId > 50
group by HostName

OPEN TmpCursor

FETCH NEXT FROM TmpCursor
INTO @spId

WHILE @@FETCH_STATUS = 0

BEGIN

Exec (@spId)

FETCH NEXT FROM TmpCursor
INTO @spId

END



CLOSE TmpCursor
DEALLOCATE TmpCursor

end

View 2 Replies View Related

Unable To Send Database Mail To External User

Jul 13, 2015

I have two domains. forest domain abc which has the exchange infrastructure. forest domain xyz which does not have exchange. There is a two way trust set up.

I have set up database mail which sends internally but not externally on the xyz domain its uses mailrelay address to comunicate with exchange. The receive connector is set up correctly on exchange on domain abc as I have managed to send email from a sql server to external contact in the abc domain.

The IP addresses are correct on the receive connector.

The problem is I am unable to send to an external contact from the sql server in the xyz domain. Not sure if this an exchange issue or database mail.

View 2 Replies View Related

How To Create A Data Diagram In SQL Server 2005 Management Studio For A SQL Server 2000 Database

Jan 9, 2008

Hello:
I have an old database created in SQL Server 2000,
now I can open, access it in SQL Server 2005 Management Studio, but I can't create Data Diagrams.
Please advise on how to make it work....
Thank you

View 2 Replies View Related

Create A Relational Diagram From Non-relational Database

Aug 4, 2005

Hi all,
I am trying to create a diagram for our database, during the creating, I create some of the relationships which were not there(basically our original database is not relational database, that's why I am doing it)
So sometimes I have to chage data type in order to create a relationship for the coloumns in different tables. i.e. change char(16) to varchar(7) (I checked the field that make sure all the data in this field is <= 7 characters)

But when I saved the diagram, there is an error message that state:
Errors were encountered during the save process. Some of your database objects are not saved on your diagram.

'agent' table saved successfully
'VisitUSA' table
- Unable to create relationship 'FK_VisitUSA_agent'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_VisitUSA_agent'. The conflict occurred in database 'CMC', table 'agent', column 'AgentCode'.

What does that mean? is it caused by some of the agentcode data in VisitUSA table which is not in agent table?
Thanks!
Betty

View 3 Replies View Related

Cannot Create Db Diagram

Apr 19, 2006

When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error:
cannot insert the value null into column "diagram_id"
I have searched the web and can't seem to find anything on this.
I just simply drag one table from my local db onto the diagram windows and try to Save it and that's what I get. I'm able to save diagrams on a networked SQL Server.
Does anybody know how I can resolve this issue?

View 1 Replies View Related

Is It Possible To Create A Diagram?

Mar 22, 2007

Hi,

I€™m trying to create a DB for my course at Uni and as far as I€™m aware to create a DB on my desktop at home I need to use CE.

So I created a new DB in CE and then created some tables and I now want to create a relationship diagram but there isn€™t an option to do it. In the toolbar the relationship icon is permanently greyed out and unusable and there isn€™t a node in object explorer.

Can this be done and am I just missing something obvious? I€™m running it on Vista and I have installed the latest SP, could that cause any problems?

Im going crazy and any help would be greatly appreciated!

Thanks,

Ricky

View 4 Replies View Related

How To Create Subtype Tb By Using This ER-Diagram?

Jun 26, 2007

Hello.. I have a problem only on this relation (supertype and subtype) I have no idea how to create the table in MSSQL2000. I have try all the way that I can guess.. but unfortunately I can't solve this problem >,< I try to build it in diagram but can't.. in diagram I can create only normal relation.. would you please help or advise me some SQL code or the way to create it.. thank you in advance!

Supertype and Subtype ER-Diagram is below:

View 3 Replies View Related

Cannot Create Diagram In SQL 2005

Nov 29, 2006

i get the following message



Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

I am the db owner but still wouldnt let me install and create diagrams.



help!

cheers

View 3 Replies View Related

Data Modeling - Create ER Diagram?

Mar 4, 2014

I have a case study requesting to create an ER diagram, with the attributes listed in each entity. The data I have is an Excel Spreadsheet listing:

CustomerName
PurchaseDate
Destination
Airline
Flight#
departDate
DapartTime
ArriveTime
Hotel
CheckIn
CheckOut
Car Rental
Pickup
Return

The case is related to travel agency that specializes in booking interesting vacations for people who are single. Note that the travellers have a variety of travel bookings: some may rent a car and drive to the hotel at their destination, others may be staying with friends or relatives at their destination, while others will need flights, hotel and car rentals in their booking.

creation of the Tables and their attributes to Normalize the model to 3NF.

View 2 Replies View Related

Create New Database As A User Instance

Mar 2, 2007

Hello...
Is there any way to create a new database directly as a user instance. I guess this means creating a new mdf/ldf pair which is detached from the server after its created.
Thank you...

View 9 Replies View Related

Can We Able To Create A Database User Name As ‘sa’ In Sql Server?

Aug 13, 2007

Can we able to create a database user name as €˜sa€™ in sql server 2k5?

View 2 Replies View Related

Transact SQL :: Create A User For Only One Database

Jul 17, 2015

I have a Java application (APP) that use SQL Server 2008 - 20014. In the SQL server there can be more than my database. During setup of the database the first user (ex:ADM) is created using MS SQL Server Management Studio (SMS). ADM can then launch the APP with proper credentials and connect to the database.ADM can then, in the APP, create new users for the APP and database. After some testing for proper CREATE and GRANTS I use the following code to create a new Create, Read, Update, Delete (CRUD) user for the APP and database: CREATE LOGIN testuser WITH PASSWORD='password', DEFAULT_DATABASE = testdb

USE testdb
CREATE USER testuser FOR LOGIN testuser
GRANT AUTHENTICATE TO testuser WITH GRANT OPTION
GRANT CONNECT TO testuser WITH GRANT OPTION
GRANT ALTER ANY USER TO testuser WITH GRANT OPTION
GRANT CONNECT SQL TO testuser WITH GRANT OPTION
GRANT INSERT,SELECT,UPDATE, EXECUTE, DELETE TO testuser WITH GRANT OPTION

USE master
GRANT CONTROL SERVER TO testuser

USE testdb..When I the use the SMS and look at security the "testuser" is only added to testdb. To test I create a second database "testdb2" --> launch the APP to connect to testdb2 and can login with "testuser".I don't know if I give to much grants or missing one...proper TSQL so new users only have CRUD access to "testdb" and no other database on the SQL server.

View 5 Replies View Related

DB Design :: Create Table On Given Data Model Diagram

Jul 27, 2015

I never created table on the basis of Data model diagram . I have to create the 3 table on the basis of given Data model diagram. There are 3 tables

1.md_geographyleveltype
2.md_geographylevel
3.md_geographylevelxref

I have tried to create 2 table but unable to create 3rd table.

CREATE TABLE [dbo].[md_geographylevel](
[type_key] [int] NOT NULL,
[geog_key] [int] NOT NULL,
[Type_description] [nvarchar](50) NULL,
[Store_flag] [nvarchar](10) NULL,
[Type_short_desciption] [nvarchar](50) NULL,

[Code] ....

I am getting difficulties to create table script for table

md_geographylevelxref

How to create the table create script for

md_geographylevelxref

View 2 Replies View Related

Trying To Create A New User With Windows Authentication For My Sql Database

Dec 30, 2007

I have a website written in asp.net and the current DATABASE logins do not use windows authenticaton. They are for online use only with a username and password.  I'm trying to run my program locally on my machine and access the database locally.  This is very frustrating. I'm able to connect to my database, but I can't login to it.  Here's my connection string from ym webconfig file:
<add name="sqlConnectionString" providerName="System.Data.SqlClient" connectionString="Connect Timeout=8; Initial Catalog=linkexchanger; Data Source=SCOTSQLEXPRESS; "/>
I have the MSSQL engine running and I have connected with the SERVER.  My database is in my directory tree of Microsoft SQL Management Studio Express.  The server is SCOTSQLEXPRESSI have attempted to add a login to my sql database by right clicking on the security folder to create a new login.  My understanding is that under windows, I don't need a uid and pwd in my connection string .  Thus I tried removing all of this just as you see above, and I get an error message every single time I try to create a login with windows authentication.
Can someone please explain how I make this work? 
Thank you.
 Scot

View 1 Replies View Related

Create User - Permit In Database Role

Jan 7, 2004

Hi,
I hv an application which is using ASP.net. The connectionstring in web.config is
<appSettings>
<add key = "constring" value = "Initial Catalog=mydatabase;Data Source=mypc-pc;User ID=User1; Password=password1"/>
</appSettings>"

Then, i hv created a user in SQL Server 2000 which is User1. What should i put for the database role? db_owner or just db_datareader and db_datawriter?

pls help.

Thnx

View 4 Replies View Related

Script To Create User And Login For Database

Jan 9, 2007

Hi gurus i am new to sql server.... so plz help me out ... i need script to create new database user and login.i know how to create by enterprise manager but have no idea to create it by QA.
please help me out
thanks in advance
shekhar

View 3 Replies View Related

SQL Server 2012 :: Create Table On Given Data Model Diagram

Jul 27, 2015

I never created table on the basis of Data model diagram . I have to create the 3 table on the basis of given Data model diagram. There are 3 tables

1.md_geographyleveltype
2.md_geographylevel
3.md_geographylevelxref

I have tried to create 2 table but unable to create 3rd table. Need to review the script of first 2 table and to create table script for 3rd table.

View 5 Replies View Related

How To Grant Create Procedure Permission To Database User?

Apr 7, 2008

Can somebody tell me without pointing to any other link how to grant Create Procedure permission to DB user.

View 3 Replies View Related

SQL Security :: Create Database User And Give Grants To Few System Tables

Aug 12, 2015

Need to create a user in sql server provide grants to few system tables to the above user.

View 10 Replies View Related

Question About Create Database,login,user,schema And Grant Permissions.

Apr 25, 2007

Hi,



I created a database,login,user and schema like belows.









-- 2. create database
CREATE DATABASE MyTempDatabase;



-- 3. create login
CREATE LOGIN MyTempLogin WITH PASSWORD = '#mytemplogin$',
DEFAULT_DATABASE = MyTempDatabase,
CHECK_EXPIRATION = OFF,
CHECK_POLICY = OFF;

--
USE MyTempDatabase;



-- 4. create user
CREATE USER MyTempLogin FROM LOGIN MyTempLogin WITH DEFAULT_SCHEMA = MyTempSchema;



-- 5. create schema
CREATE SCHEMA MyTempSchema AUTHORIZATION MyTempLogin;









The created user,MyTempLogin, must have permissions that can create tables,drop tables,select,insert,delete,update and bulk insert.



How can I grant permissions to the user?(or schema?)

I failed to grant by T-SQL query.



Additionally, what is purppose of the ROLE? Should I create or use it?



I'm confusing in security concept(login,user,schema,role).



Thanks.

View 3 Replies View Related

Sp To Send A Message To A User ?

Sep 23, 2006

Do you know a stored procedure ( or a query) to send a message to a SQLServer user ?

Something like NET SEND but with a spid user

Thanks

View 4 Replies View Related

Trying To Send Message To User

Jan 14, 2004

I am having a problem getting informational type messages to display for my end users.

I have a SQL2000 db with a Delfi front end. When I issue either the raiserror or print nothing is displayed inside the app. With raiserror I can get it to display if I make the severity higher than 10. The problem with this is that it stops the app from processing the transaction. This is ok in one case but not with just informational type stuff. Any suggestions? Thanks.

Jim

View 1 Replies View Related

Create A Trigger To Send Email

Aug 18, 2005

I have a basic trigger that populated an audit table, but I want to add logic to that to send an email everytime the trigger is called,Is there a easy way to add code to my basic trigger to send an email to me everytime the data changes.Thanks

View 1 Replies View Related

Database Diagram

Dec 31, 2006

I am working through a book about setting up a database, though i'm doing it slightly differently, using a sql server database on a remote server rather than the local sql server express database shipped with visual studio.
everything has been going fine until i've reached a part where they want to add a database diagram to the existing database. they talk about right clicking the database diagram node, and selecting add, but for some reason there is no database diagram node, so i can't do it this way. the book also says using the data>add new>diagram from the menu, but when i do this i either have no diagram option (when i have no table opened) or else the diagram option is greyed out and unselectable (when i have a table opened).
 any ideas on how i can add a database diagram?
dc

View 2 Replies View Related

Database Diagram

Apr 27, 2001

How do u print the database diagram...basically is there any process that can generate the database diagram from the database which is already existing with the referential integrity...

Any resources where i can look for the same.

thanks,

Kavitha

View 1 Replies View Related

Database Diagram

Nov 13, 2000

Hi All,

How to get the Database Diagram to a separate file like .doc or some formats.

Thanks,

Seenu. S

View 1 Replies View Related

Database Diagram

Oct 13, 2000

Hi

Can anyone tell me about the storage of Database Diagrams. I want to know where these diagrams are stored in SQL Server? If it is in System table, which table and how to copy these diagrams into another database?

Thanks
Jag

View 2 Replies View Related

DataBase Diagram

Apr 17, 2008

Hi,

i Created DataBase diagram in Sqlserver2005. Now i want to save as a file.Is there any way to save as a file ? or any Alternative Method.
Please Help Me.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved