Management Tool For MSDE
Mar 9, 2000Does anyone know of a third party tool similar to Enterprise Manager to manage a MSDE database (except Access2000)?
Thomas
ADVERTISEMENT
MSDE Tool Question
Oct 28, 2002--------------------------------------------------------------------------------
Say an application is developed with Visual Basic using MSDE and installed on a user PC.
The MSDE databases from time to time will/may need:
a. to be backed up
b. to be restored
c. to be shrunk
d. to be integrity checked
e. to be detached
f. to be attached
g. maybe a few more things
To provide support for these activities, it seems to me like you have the following choices:
a. Build into the VB application
b. Build/use SPs (stored procedures)
c. Use OSQL
d. Use a quasi DBA GUI tool independent of the VB application
Now it seems that building the support into the VB application is not the best choice.
Ditto on having your client use SPs and/or OSQL.
This leaves the quasi DBA GUI tool.
I am not particular keen on reinventing the wheel. Anyone know of any quasi DBA tool(s) which have already been developed? Where to find them? Their cost? Their limitations? etc.?
Many thanks in advance!!
solart
Manage The MSDE With Command Tool
Mar 4, 2005i an newbie to MSDE, but i have experience Mysql before, can someone tell me how can i find help to manage MSDE with commands ??????
View 6 Replies View RelatedMSDE 2000 Administration Tool
Jul 20, 2005Hi all,I have installed MSDE on my computer but it's missing, as all you alreadyknow, a serious (well, osql IS TOO serious but not very newbie friendly)admin tool.I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy withit but was wondering if there's something better or that may complete whatDbaMgr2k is missing... and preferably is as free as DbaMgr2k.Thank You,Lorenzo
View 2 Replies View RelatedDatabase Management Tool
May 24, 2005Hi All,
I installed sql server 2005 express edition beta 2. which come as part of visual studio 2005 beta 2.
Please tell me which administration tool i have to use to manage my database.
Thanks
mk_garg
Configuration Management Tool
Dec 19, 2007Dear All,
Where to find configuration management tool in sql server 2005???
Vinod
Even you learn 1%, Learn it with 100% confidence.
Configuration Management Tool
Dec 19, 2007Dear Experts,
where can i find configuration management tool
actually i'm trying to change my MSDB mode from suspect to normal...
Vinod
Even you learn 1%, Learn it with 100% confidence.
Tool To Create Small Database With MSDE
May 12, 2004Hi,
I'm a newbie with SQL so excuse my igorance. I'm running an application that uses MSDE2000 as its source db and would like to create a small [10 field] db that would also use MSDE. I want to use a separate db though and not share the first one. What I'm looking for is suggestions on a development tool to create the database with as I'm not familiar with SQL tools. I have a lot of Access experience though so the concepts are not new.
Database requirements are pretty basic.
10 fields [8 text, 2 numeric]
A button field to Add New Record
A search field
Column sorting.
That's it. I could do this in a pinch with Access so knowing what tool to use should make it easy. Any chance that I could do it with Access and then port it to a SQL db?
Thanks,
Bob
Where Is My Databases In The MS SQL Express Management Tool?
Mar 24, 2008Where is my databases? I have 2 different DotNetNuke installations on this machine running very well but in the db management tool I cannot find my databases ... I am positive that they are there somewhere collection/holding data but why doesn't they appear in the SQL Express management tool?
My connection string is the classic:
which says there should be at least one databse --> Database.mdf
Doesn't this .mdf file appear in the SQL Express management tool ? Se picture of my control view
/Johan
SQL 2005 Express, Studio Management Tool
Sep 30, 2006I have just downloaded VB Express, that comes with SQL Express
In order to manage and use SQL databases it seems I have to use SQL
Studio Mgt Tool. But, where is it? I can only see Configuration Tools,
but not any Mgt tool or DB Engine......
Maybe my installation is incomplete?
thanks
SQL Express Datadase Not Visible To SQL Server Management Tool
Dec 18, 2005I have created a new database using Visual Web Developer and wanted to manage it using either the SQL Server Management Tool or MS Access via ODBC.
Niether of these tools will connect to the database.
The database file , called srx.mdf, the connection string is
Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootSRExchangeApp_Datasrx.mdf;Integrated Security=True;User Instance=True
I can however connect successfully to the master file, the conenction string for this is
Data Source=.sqlexpress;Integrated Security=True
Any help appreciated.
Microsoft SQL 2005 Express Management Tool-errors
Sep 10, 2006Hi guys, I've tried to back a database from a server on the net ie: discountasp.net by using Microsoft SQL 2005 Express management tool.
After all the set up:
(1) the part "Destination", in the "Disk" radio button was cheked, the path for the backup file shows like: D:MSSQL.1MSSQLBackupmyDatabase.back; As I understand D: is the CD drive(?), so I put a CDisc in the drive, and kept going with the process. The Process went very well and inform that the Database has been fully backed up. But I never have found the "saved" or "backed up" that I backed up. Can anyone show me where this backup Database in that D: drive, and where is that D: drive anyway?
(2) In that "destination" part, if I clicked "add", and then typed in the path address part like: C:....mybackupDatabase.bak for example, the the tool gave me the error: ... not set to an instance ...; I counldn't even select the Browse to browse to the directory that I wanted to back up the Database.
Please help me for this.
Regards.
Joey
Asp.net Confgiguration Tool. Tool Keeps Timing Out
Mar 2, 2006is 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 RelatedLooking For A Tool/ Middleware Tool Which...
Jul 23, 2005Hi 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 RelatedMSDE Text Datatype - Unable To Store More Than 900 Characters. (msde + Visual Studio 2003)
Jun 6, 2005Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
How Do I Change The Name Of A Computer Running MSDE With Out Reinstalling MSDE
May 27, 2000I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
MSDE: Renaming Machine Without Reinstall Of MSDE
Mar 27, 2001We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??
regards,
Manfred
MSDE Worth Using Or Should I Invest In MySQL? (was MSDE)
Mar 9, 2005I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
Management Studion Express Alongside Full-blown Management Studio?
Oct 9, 2006Is it possible to run both Sql Server Management Studio: Express and full blown side by side?
I am developing with the full blown product but would like to test Management Studio Express on the same box.
Is this possible?
Thanks
Eric
SQL Server Management Express Studio Management Tools
Apr 5, 2007
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
Can Anyone Help Me Regarding Tool
Jul 22, 2005hiis 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 RelatedSQL Tool
Aug 5, 2005Hello,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 RelatedSql Bcp Tool.
Apr 23, 2008Hi 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
SQL Bcp Tool
Oct 18, 2007Hi,
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.
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.
Is This The Right Tool?
Jul 20, 2006I 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.
SubSonic Tool
Jul 3, 2007Hi, 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 RelatedTool To Convert Mdf To Sql?
Nov 10, 2007Hi 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
Tool To Convert Mdf To Sql
Nov 12, 2007Hi 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
Search Tool
Mar 6, 2008I 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!!!
ASP.NET Configuration Tool
Apr 4, 2008Hi 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
SQL Web Admin Tool
Mar 4, 2004Hi,
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
Modelling Tool Help
Jan 6, 2005Hello,
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