Graphical Tool

Aug 22, 2005

Do you guys use a graphical tool for building SQL - like MS Query? I know its lazy but it does save lots of typing for long multiple-table queries.
Also, the graphical drag-drop method of adding relationships in Access would seem much quicker than adding rules thru sql.

View 10 Replies


ADVERTISEMENT

SQL Tools :: Tool To Create Graphical Layout Of Tables?

Nov 6, 2015

SQL Server 2008 R2.  SQL Server Management Studio 2016 CTP2. I am looking for a tool where I could create and save a nice graphical layout of some tables in a database and their relation to each other (how they join or connect).  I get something like this in the Query Editor, where it shows the fields and joins of tables as I select them.  However, I cannot save this representation to show say in a PowerPoint or Word document (Visio, etc.). 

Is there a tool that would enable me to create a nice document showing my tables and their relationships, which would also allow me to annotate each table with notes about the fields, etc.? 

I searched and found a reference to "Visual Database Tools" which is supposed to be part of Management Studio 2016.  However, I cannot find such a set of tools listed anywhere in my menus.

[URL]

View 3 Replies View Related

Graphical CPU Use From SQL

Oct 5, 2007

Has anyone created a report that shows something like performance monitor, but shows only SQL CPU use. I would be interested to see which users cause high CPU use, at what moments in time is SQL processing high and what queries are causing the processor to spike.

View 3 Replies View Related

DB Mail; Graphical View

Apr 28, 2008

Is there a graphical view in SSMS, to check the properties of DBMail?


------------------------
I think, therefore I am - Rene Descartes

View 4 Replies View Related

Tools For Graphical Format

Oct 8, 2014

Other than SSRS, is there a cheap product or free tool that can present SQL Queries in graphical format that is easy to implement?

View 1 Replies View Related

Graphical Usrer Interface For SQL Server 7.0

Nov 15, 2000

Dear SQL Server users,
I would like to build a Graphical User Interface for my MS SQL Server 7.0 database.
Should I use Visual Studio, Visual Basic, or Dalphi?
I am new to this community. Any advice will be appreciated.
Thank You.

View 1 Replies View Related

Graphical Edit Interface For MSDE 2000 A Database

Jan 23, 2004

Greetings all,

Is theyr an Graphical edit interface for the MSDE 2000 A database ? Windows based would be best.

Tnx for the answer.

Greetz,
Stefan

View 3 Replies View Related

How To Load/Unload Non-Graphical Files Into/From IMAGE Field?

Dec 13, 2007

I want to be able to load and unload, byte-for-byte, a file to and from a field of data type IMAGE in a SQL Server CE database. The files are larger than 8000 bytes so IMAGE appears to be the way to go data type wise.

I'm using VB 2008 but pseudocode for any VS language would be awesome.

I was able to do this without much effort using ADODB and its stream object, fetching a recordset object and updating the appropriate data field one "chunk" of bytes at a time. I cannot for the life of me find a way of doing this using, for example, a SqlCeResultSet.

I've tried using ADODB to connect to a SqlCe SDF database file, using a connection string that I found online, and am able to write action and select queries successfully against the database... but when I try and return a recordset that is updatable, it returns an error. So no help there.

I've searched other threads in the forums, and online in general, and I've found information on loading/unloading graphic files using a memoryStream and the toArray method thereof, but this will not work as many of the files I want to load and unload as BLOBs are not graphical in nature. FileStreams do not implement the toArray method, so I can't just stream an arbitrary file's worth of bytes that way. I also do not want to change the original file in any fashion--e.g., a hash of the source file should be identical to the file after it has been loaded into the data field and then unloaded into a new file.

Any thoughts? Your help is MUCH appreciated!

View 4 Replies View Related

SQL 2012 :: Power Pivot Graph / Need To Display In Graphical Format

May 19, 2014

Power pivot graph. I do have different transaction names, dates, count, exec time with me, I need to display each transaction execution day, execution time in graph format. Suppose execution time is on Y axis and Exec time is on X-axis then to display the which transaction takes more time for execution.I have Query just I need to display in graphical format

View 1 Replies View Related

SQL Server 2008 :: Graphical (Include Execution Plan) Left On By Default?

Jun 25, 2015

Is there a way to leave the graphical 'Include Execution Plan' on by default in SSMS? I don't know how many times I run a long-running query, say to myself, "wow, that took a while; I wonder what the execution plan looks like?" only to realize that I left it turned off. Now I have to turn it on, and wait for the query to run again. I'm guessing there's a setting in the options somewhere to always leave it on, but I'm not sure where

View 2 Replies View Related

Asp.net Confgiguration Tool. Tool Keeps Timing Out

Mar 2, 2006

is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??

View 1 Replies View Related

Looking For A Tool/ Middleware Tool Which...

Jul 23, 2005

Hi all.I'm looking for a tool which should act like some kind of middleware/logical layer bewtween the SQL server and the webbased user interface.- It should be possible to easily create simple web forms (only datainput and output) without programming effort by "clicking" the fieldsand their order on the web mask within an admnistrative interface.- It should also be bossible to add "new fields" to the database,including field type, permissions, value lists etc. (excluding anybusiness logic) without programming effort by administration.I know, that most workflow tools or "Trouble Ticket Tools", based ondatabases have this feature to easily configure new masks and add newfields to the database, but i need it as an tool-unspecific layer forthe MS SQL Server.Thank you very much for your feedback, any ideas are welcome!Best regards, Heiko.

View 1 Replies View Related

Can Anyone Help Me Regarding Tool

Jul 22, 2005

hiis there any tool to write stored procedurei have long queries to write instead of that i want a tool or editor where i can click or drag and drop to write procedurei make my work to complete fasterif any please tell me the site to downloadthanx byeramesh

View 1 Replies View Related

SQL Tool

Aug 5, 2005

Hello,I'm looking for recommendations for SQL tools used for comparing schemas from different databases. I would like the tool to be able to compare schemas for at least two databases and list the difference in tables, sps, functions, and view. Even if the both schemas contain the same structures I would like to know what differences exist. Also, I would like to be able to type in a table field name and get a list of every place in the db that field is referenced. On another note, how do others go about maintaining a version history of db structures? Any tools available for this functionality? Currently, I use visual source safe for my app. code. I could place copies of my SPs in visual source safe and edit them within  visual studio. I'm not sure how I would easily get the edited version into my sql database without having to create a script or copy the edited version back to the db. Any thoughts?Any information is appreciated.Oscar

View 1 Replies View Related

Sql Bcp Tool.

Apr 23, 2008

Hi guys, Im trying to use Bulk copy to transform a csv file into a table

BULK INSERT [BULK_INSERT_TEST]
FROM 'c:stock.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = 'N'

)

--*STOCK LOOKS LIKE THIS
stockcode,barcode,qty
10002,"10002087",0

TABLE Looks like this

id, stock,barcode, qty

can anyone give any guidance on performing this - at present this doesn't seem to work. Worth mentioning id is autoincrementing. I would also need to strip quotes around the second field. Note. Stock file has a header - do I need to strip this to use BCP?

Any help appreciated.





2,10002,"10002087",0

View 4 Replies View Related

SQL Bcp Tool

Oct 18, 2007

Hi,

I am using bcp to copy some data from a flat file to a data table using the format file that look like this.

9.0
7
1 SQLCHAR 0 4 "" 1 Col1 SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 9 "" 2 Col2 SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 0 8 "" 3 Col3 ""
4 SQLCHAR 0 7 "" 4 Col4 SQL_Latin1_General_CP1_CI_AS

There are 4 columns in total, however some rows have missing values for Column 4, and but given there are no field separators (all columns have fixed width and data is truncated if needed), how should the format be written to define a row terminator to apply to Column 3 if Column 4 is null.

Thanks for your suggestions.

View 3 Replies View Related

What Ad Hoc Tool Do You Use?

May 23, 2008



I'm in the process of delivering a SQL Server BI solution to a customer. I have the cube built, SSIS working and an SSRS package with several hundred reports. They would like to roll their own reports.

I've looked at ProClarity (or whatever MS calls it now) and Report Builder. Both seem to have their pros and cons.

What tool does the community recommend?

Thanks.

View 4 Replies View Related

Is This The Right Tool?

Jul 20, 2006

I think Service Broker is the right tool for what I want to do but need confirmation. Here is what I want to do.

Our company sells small business consulting services. When a client signs up with us, we put a server at their site that runs our app (using SQL Server 2005). Once the server is setup at their site and operational we constantly send certain information from that server to our central corporate server. There could be thousands of records every day being sent from each of these servers to our corporate server. We're using webservices now to transfer this data from each server but I'm afraid we're reaching a point where webservices will no longer work because of the volume of data.

1) I assume that Service Broker was created, in part at least, to address these types of situations?

2) If #1 is correct, is there any step by step examples/instruction that shows me how to use Service Broker to communicate between two SQL Server databases on two different servers?

Thanks very much.

Amos.

View 1 Replies View Related

SubSonic Tool

Jul 3, 2007

 Hi, I'm not sure this is the right place to ask this question (please re-direct me if it isn't). I would like to learn about SubSonic tool:1. do you recommend this tool ? if so what are its best uses?2. is its license allows me to work with it for free for commercial uses? any license limitations I should be aware of for using it as a tool? thanks,   

View 6 Replies View Related

Tool To Convert Mdf To Sql?

Nov 10, 2007

Hi all,
I downloaded the StudentActivities sample app from http://technet.microsoft.com/en-us/library/ms345152.aspx
When I want to go through this tutorial I encounter the following problem:
Database 'C:WebSitesStudentActivitiesRegistryDataStudentActivities.mdf' cannot be upgraded because its non-release version (587) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.Could not open new database 'C:WebSitesStudentActivitiesRegistryDataStudentActivities.mdf'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)
So attaching the DB seems to doesn't work. The reason for this is probably that this sample app src was written in an older version of Visual WebDeveloper Express 2005 +SQL Server Express 2005.
Therefore I would like if someone can provide me with the sql src of this StudentActivities database. Then I can create the database myself from this. Or is there some tool which canconvert a mdf to sql?
 I hope someone can help me with this. Thanks in advance.
 GJ

View 1 Replies View Related

Tool To Convert Mdf To Sql

Nov 12, 2007

Hi all,
I downloaded the StudentActivities sample app from http://technet.microsoft.com/en-us/library/ms345152.aspx
When I want to go through this tutorial I encounter the following problem:
Database 'C:WebSitesStudentActivitiesRegistryDataStudentActivities.mdf' cannot be upgraded because its non-release version (587) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.Could not open new database 'C:WebSitesStudentActivitiesRegistryDataStudentActivities.mdf'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)
So attaching the DB seems to doesn't work. The reason for this is probably that this sample app src was written in an older version of Visual WebDeveloper Express 2005 +SQL Server Express 2005.
Therefore I would like if someone can provide me with the sql src of this StudentActivities database. Then I can create the database myself from this. Or is there some tool which canconvert a mdf to sql?
 I hope someone can help me with this. Thanks in advance.
 GJ

View 4 Replies View Related

Search Tool

Mar 6, 2008

I have a typed dataset where I used the sql query builder to build the following:
SELECT     DealManager.*, Contact AS Expr1FROM         DealManagerWHERE     (Contact = @Contact)
How can I incorporate the "where % % " clause into this statement and still except the required parameter. In other words, I want something like this:
SELECT     DealManager.*, Contact AS Expr1FROM         DealManagerWHERE     (Contact like %@Contact%)
but I get an error when I compile this...
Any help always appreciated!!!

View 2 Replies View Related

ASP.NET Configuration Tool

Apr 4, 2008

Hi Guys
Got this problem, ive setup some new roles and users through asp.net configuration and it creates ASPNETDB.MDF in the App_Data folder when ive got a DB in SQL server 2005 express.
Basically how do i change it so the tables created for the users and roles are created in the SQL Server 2005 Db? p.s I'm very new to sql server 2005
Thanks

View 5 Replies View Related

SQL Web Admin Tool

Mar 4, 2004

Hi,

I've been having trouble getting this tool to work with my server/database. I'm using XP Pro, MSDE, .NET 1.1.4322 and IIS 5.1. IIS has been installed and tested with the help of others. .asp pages are being served locally and to another PC on the network. No obvious problem here. When I installed MSDE I used the SAPWD='strongpassword" command to create a password. I also built a new database. I had positive feedback on both of these actions.

Now to the tool - when I activate the administrator it pops with the little window saying Web Server Configuration. It lists the following options:

Desired Port:
IIS
Cassini Personal Web Server
Restore Faults

and Start and Stop buttons.

If I leave the setting on IIS and click Start it opens a webpage entitled Web Data Administrator. Moving further down I have a welcome message and then the line -

Please enter a SQL Server name:

Username: [Desktopob shadowed entry]
Password
Server (local)

Authentication Method:

Windows Intergrated
SQl Login

and then a Login button

If I select SQL Login and enter "sa" as the username and then my password leaving (local) as the server I get the following error:

Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.

I have tried all combination of \desktopsa, sa, you name it. The password I selected is correct because I made a point of writing it down so I wouldn't forget it. I have also tried all the combos using Cassini as well.

This is where I'm stuck at this point. All suggestions are appreciated.

Thanks,
Bob

View 3 Replies View Related

Modelling Tool Help

Jan 6, 2005

Hello,

For management that doesn't have the software I do, I've been using a PDF postscript utility to print the model and give it to them. However, I have to fit the model for the specific page (which is really small, and you have to zoom in), or you have to view it on multiple pages. Well multiple pages can be a pain, because the table you are looking at is on page 1, but the relationships are on page 12, 22, or 50, for example. So I was looking for a tool that is cheap enough to implement that we could look at the entire model on one "surface" (not necessary to print), that the model could be viewed in.

Thanks,

Brian

View 2 Replies View Related

Sql Documentation Tool

Dec 3, 2005

Does anyone knows a good FREE tool for documenting a DB?

so far i'm with ApexSQL but its not free, wondering if anyone knows a free tool.

Thanks,

View 1 Replies View Related

Third Party Tool

May 1, 2001

Hi All,

I have to load data from from a text file ( approx 3-5 million rows) into a table .

I can use straight bcp with the format file , but the loading of data has to follow some business logic

Let me know if there are any third party tool to load the data instead of regular bcp

I have SqlServer 7.0 on Windows NT 4.0

Thanks in advance

View 2 Replies View Related

Conversion Tool

Jul 24, 2001

Dear all,

Is there any tool to convert Oracle's sql, sp.. to SQLServer's sql, sp. vice versa?

View 1 Replies View Related

SQL Diagram Tool

Sep 19, 2000

Has anybody see a tool can draw a Tree diagram for Parent-Child(PK-FK) relationships for SQL 7.0 DB.

Appreciate your help.

Thanks

View 3 Replies View Related

Does Anyone Know Of An T-SQL Reporting Tool

Oct 7, 2002

Does anyone know of a T-SQL Reporting Tool that can be attached to either SQL 7 and/or 2000 databases.
I am looking for something similar to the Oracle 'Discoverer' tool.

The requirements are that users be able to create there own reports using a GUI with the minimum of prior knowledge of T-SQL.

Thanks in advance for any replies.
David Goodman.

View 3 Replies View Related

SQL Formatter Tool !!!!!!!!!!!!!!

Jun 27, 2002

1) Is there a tool out there that formats sql code for (SQL 2000) ?

2) if you have a date split into year = 2002, month =1 and day= 22
how can l combine it or rather concatenate it so it looks like
'2002-01-22'

View 1 Replies View Related

Db Design Tool

Jan 23, 2007

Hi all -

I'm looking for a free or shareware database design tool that can connect to Sql Server 2000. Anyway know of one? Thanks

Joe

View 2 Replies View Related

DB Monitoring Tool

Jan 28, 2005

Hi all,

I am new to the db world so please let me know if I don't make any since.

I was wondering if there is an open source SQL database monitoring tool out there that I can run on my desktop that would give me a log of what is going on on the database (or the server).

Thanks.

View 2 Replies View Related







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