Can I Manage MSDE With SSMS??

Jul 26, 2007

Hello,

We have an XP workstation containing a very important MSDE-based
application. Its MSDE database isn't likely to change for quite a
while.

The app contains an internal backup method (File, Backup, Backup) and
an auxiliary app/script for shrinking the database and logs. I would
like to automate the backup and shrinking so end users don't have to
remember to do them.

The workstation has a static IP so it can go out to the Internet when
necessary.
The workstation is presently not joined to the domain.

1. Can I install SSMS Express *only* as a local app (without SQL
Express 2005) and thus use SSMS to set up nightly backups and periodic
shrink database/logs jobs??

2. We have SSMS running on SQL 2005 server box in the domain. If I
join the workstation only to the domain (local account logon is not
changed, still used), could I use SSMS from the SQL 2005 box?? Would I
need a domain login on the XP box to make this work??

Thank you, Tom

View 1 Replies


ADVERTISEMENT

Using SSMS To Manage SSIS

Jun 9, 2005

(Also posted on the beta newsgroups...)

View 16 Replies View Related

Third Party Software To Manage MSDE?

May 19, 2004

Hi, it's my first time to use MSDE. So would you guys please recommend me a third party software or application which has interface to manage it? thank you!

View 1 Replies View Related

Manage The MSDE With Command Tool

Mar 4, 2005

i 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 Related

MSDE Text Datatype - Unable To Store More Than 900 Characters. (msde + Visual Studio 2003)

Jun 6, 2005

Hello,

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.

View 1 Replies View Related

How Do I Change The Name Of A Computer Running MSDE With Out Reinstalling MSDE

May 27, 2000

I 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"

View 1 Replies View Related

MSDE: Renaming Machine Without Reinstall Of MSDE

Mar 27, 2001

We 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

View 3 Replies View Related

MSDE Worth Using Or Should I Invest In MySQL? (was MSDE)

Mar 9, 2005

I'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?

View 4 Replies View Related

Manage SQL Express Over Lan

Oct 27, 2006

Hey EveryoneI have a desktop machine and a laptop machine.  Both have XP Pro.  I prefer to code on my laptop, but I want to use my desktop machine as a home server/development environment because its always on.  I have IIS (HTTP and FTP), .NET 2.0, my mp3 server, etc up and running just fine on my desktop.When I'm working on an application, I access the site with VWD through a network share.  It's worked great so far.  What I haven't been able to do, however, is connect to the database with VWD or Management Studio Express.  I don't even really know where to begin with this one.  What I don't want to do is open this up to the internet.  I'd like to just keep it accessible from the LAN (the database, not the website)I'm new to database stuff, and I don't really know where to look to figure out how to do this.  Basically, I want to have the same functionality with VWD or Management Studio that I would have if I was physically on the machine with the SQL Express server.If anyone can provide some advice, I'd really appreciate it.Thanks!Brandon 

View 6 Replies View Related

Manage Data

Apr 14, 2008

Hello,I am working on an ASP.NET web site using an SQL database. Is there a way to Insert/Delete and Update data in the database without creating all the forms in ASP.NET?Since I am the only person to work with the database it would be easier for me than creating all ASP.NET forms.Thanks,Miguel

View 1 Replies View Related

How Do You Manage Your Remote MS SQL?

May 28, 2007

How do you manage your remote MS SQL?

I have worked with mysql for sometimes now and everywhere there was a mysql there was phpmyadmin for managing it but now on my new windows hosting with plesk I don't see such program. The only thing I see is a pothetic program called ASP.NET enterprise manager that doesn't allow uploading data.

.

View 3 Replies View Related

Remote Manage

Jun 11, 2004

Before I just manage the SQL serve in LAN.

Right now i have a SQL server on internet I want to Remote manage

Can I still use QA and Enterprise Manager ?

View 5 Replies View Related

Manage Data

Apr 14, 2008

Hello,

I am working on an ASP.NET web site using an SQL database.

Is there a way to Insert/Delete and Update data in the database without creating all the forms in ASP.NET?

Since I am the only person to work with the database it would be easier for me than creating all ASP.NET forms.

Thanks,
Miguel

View 2 Replies View Related

How Do I Manage 100.000 Actions A Day ?

Mar 27, 2008

In a previous application i stored about 100.000 actions ( coming from an external system )in an access database for each day. Therefore i created everyday a new accessdatabase to have enough performance. Each month i copied automatically all databases in a new 'month' map as a backup.

The goal of the application is the view all actions of one day of week in one grid. This is a kind of history of the external system.

I'm afraid the application will become to slow if i save all actions in one database. ( after 1 month i will have 3.000.000 actions.

How this is done in an sql server ?
Do i have to use a different kind of method ?

View 2 Replies View Related

How To Manage 16 Bit Number

Jul 3, 2006



is there any datatye that can accept 16 digit number

View 4 Replies View Related

How Do I Manage This Mess? Thanks!

May 24, 2007

Say for example I have the following 2 database tables, the first one contains the old employee data, and has the fields shown below:
oldEmployeeID
FirstName
LastName
DateOfBirth
HiringDate
TerminationDate
and another one containing the new employee data with similar fields but instead of oldEmployeeID, it is showing the newEmployeeID.
During the conversion process, something were messed up and instead of putting in the original hiring date of the workers into the new employee database, the conversion date was put in, which, depending on the mood of HR ladies, could be any date, and at the same time, of course, new employee join the company, and we assume their hiring dates were entered correctly. On top of that, there are some employee who were terminated before the conversion took place but we still need to keep a record of that.
And I created a third table, say, emplyeeAll with similar fields to the employee data tables.
So here is what I need to do: if the firstName, lastName and DateOfBirth in the old employee data table and the new employee data table matches, I would assume they are the same employee, hence I would put the information for the employee obtained from the new employee data table to the employeeAll table, with the Hiring Date changed to the Hiring Date of the old employee data table (and do not copy the record from the old employee table to prevent duplicates), otherwise, I would simply copy and paste the data in new and old employee table to my employeeAll table.
I know this is really confusing, but...well...hope you know what I am saying...
Is it possible to have a SQL statement for all these? If so, how should the statement looks like?

Thanks a lot!

Regards,
Anyi

View 6 Replies View Related

Manage Ssce 3.5

Aug 5, 2007

I have been having "fun" trying to get all the bits (SSCE 3.5, Orcas Beta 2, SQL Managment Studio) in Vista 64 and Xp 32.

So far I have found at the SQLMetal does work with SSCE 3.5 but not in Vista64

BUT I cannot get any tool (tried SQL and SLQ express) to manage my SSCE db - ie make relationshipos so that SQLMatal can do its stuff


Any advice as to which tool to use to manage SSCE 3.5


Thanks

Mike

View 5 Replies View Related

Manage Sql Table

Mar 18, 2008

create

View 4 Replies View Related

How To Manage A DTS Package Usin Asp.net

May 18, 2007

Hi
How i can manage a DTS Package usin Asp.net

View 1 Replies View Related

Manage Indexes In Sql 2005

Jun 5, 2007

Hi,
I'm currently migrating to Sql 2005 from 2000 and have a quick question about indexes.
In 2000 i used to click on Table > All Tasks > Manage Indexes... to view and create all my table indexes. There doesn't seem to be anything similar in 2005 Management Studio. I thought it was under Table > Modify but there's nothing there for indexes. I've had to create all my indexes manually through t-sql but this doesn't help when needing to view and manage current indexes.
Can anyone help me on this?

View 2 Replies View Related

Manage A SqlDataSource In Code Behind (VB.Net)

Dec 30, 2007

Hi All
 It´s my DropDownList data source from my page1.aspx:
<asp:DropDownList ID="ddlChampionships" runat="server" DataSourceID="sdsSearchChampionships" DataTextField="name" DataValueField="id_championship">     </asp:DropDownList><asp:SqlDataSource ID="sdsSearchChampionships" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Tupi_Campeonatos]"></asp:SqlDataSource>
When I put a new championship name in a TextBox and click on the button "ADD", this button event click is called:
 Protected Sub btAddChampionship_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btAddChampionship.Click
     insertNewChampionshipIntoDataBase()
End Sub
The Page then reloads but my DropDownList is not updated. The way I found to do it is to put the DDList update code after the calling of the insertNewChampionshipIntoDataBase() method, but how???
thnx

View 2 Replies View Related

How To Manage Sql Server 2005

Jul 25, 2005

What admin tool do I use to create databases, stored procedures, etc in the Sql Server 2005 CTP?

View 9 Replies View Related

Manage Permissions Script

Jan 4, 2006

How can I create a script that will set all the permissions for a specific user for some objects in a database?
Thx in advance.

View 2 Replies View Related

How To Manage Multilingual Data

Apr 12, 2008

Hi Fellas,

I have a problem and it is described as follows:

1. The user may browse any website on the internet that may be in any language and enter the data into my application.
2. The data entered can be in English or any other language.
3. That’s were the problem arises; the data that enters the database other than English is displayed in wrong format like small boxes.
4. The user who had previously entered the data in the database can also alter that data. So when I display the data (other than English) to him it is not in the format in which the user had entered.

So can anybody help me out how to manage multilingual data?

View 2 Replies View Related

What Permissions Do I Need To Manage Users?

May 23, 2006

I have a user that I have granted the server role "securityadministrator" and a database role "db_securityadmin". When logged inas this user I can create new logins but not run sp_adduser to add thenew login to as this says I don't have permission to do this. I canhowever run sp_revokedbaccess to get rid of a user from the database.

View 2 Replies View Related

Manage Detached Mdf File

Oct 13, 2006

I want to manage my sql express .mdf database file (e.g. set Roles) but I seem to only be working with a temporary instance of my database when I attach to .sqlexpress and manage in SQL Server Management Studio Express (SSMSE). The Role I set is gone when I detach and re-attach.

If I try to manage my file in Visual Studio under Server Explorer, I do not see the "Roles" folder to modify roles.

Any help is appreciated.

View 3 Replies View Related

How Can I Manage SQL Server Remotely?

Apr 15, 2008

Hi

I have SQL server admin id and password, and I want to do some create/delete new database, or mimium do some select statements. What do I need to install on my workstation in order to connect to SQL server remotely? What's the equivalent tools as SQLPlus in Oracle?

Thanks
Jirong

View 5 Replies View Related

Looking For Suggestion Of How To Manage A DB File When It Getting Too Big.

Aug 18, 2006

Hi all,

At our facility, we have a > 350 gigs database and the DB is breaking into 2 files. One file is our Image table with the size of 300 gigs. The other file contains all of the other tables. The image file is getting bigger and bigger everyday, I am worry that eventually when a data file getting too big it could lead into problem. - DB fragmentatio, hard to manage etc

My question is anyone has run into this problem, and how do you solve it?

I am open for any suggestion.

BTW: I am using SQL 2000.

Thanks in advance.

View 9 Replies View Related

Recovery :: How To Manage DB Space

Jul 8, 2015

i've a server which is reside in remote area. my database store in drive E where disk capacity is 1000 GB and DB size reached 800GB , now disk free space showing 10 GB only . how to manage space.couple of week back i've tried to shrink the database but it is not completed successfully and since the time db size drastically increase. now i'm sitting in corner.can we perform partial shrink only on MDF. so that we can manage the space (starting from 10 gb only)

View 33 Replies View Related

Manage Exception Message

May 26, 2006

How to manage sql server runtime message to users understand it?

In my web form I added folowed code

If Session("Action") = "Edit" Then

Try

ObjectDataSource1.Update()

Catch ex As Exception

lblMessage.Text = ex.GetBaseException.Message

End Try

for manage user input for update the record.

This is message returned by sql server 2005

The UPDATE statement conflicted with the REFERENCE constraint "FK_DEVIZE_RELATION__DRZAVE". The conflict occurred in database "Trgo2006", table "dbo.Devize", column 'Drzava'. The statement has been terminated

This message not understand for users. How to manage messages retrned by sql server, or prepare exception to return message understanded for users.

View 1 Replies View Related

How To Manage Errors With One File

Nov 15, 2006

Hi,

I am pretty new in SSIS 2005, and I have some problems... I want to add logging and error management in my package. I found how to made logging. But for errors managing i have some difficulties.

In my package I have only a flat file source and an ole db destination. I want add errors management for both of them. So I create a connection manager for errors on a file. For both element i add redirect row for all available error type and then i add 2 flat file destination. I branch red arrows of flat file source and ole db destination to the flat file destination.

When i run packge i have an error which indicate me that file error is already take by another process... I don't understand why. And i don't want to create on file for each element on package. Have you any idea on why i have this error? Or how can i made what i want do?

Krest

View 2 Replies View Related

How To Manage Large Text Data

Apr 10, 2001

Hi All,
How do I input a large text page (notepad) into a SQL column. Or assign a pointer to the data. I've tried to use BOL (writetext) and to no avail, I guess I'm missing something. I'm just using EM and Query analyzer. I thought this should be easy. Image data should work the same way.

TIA,
Dave

View 1 Replies View Related

Manage SQL Servers On Multiple Domains

Aug 24, 2000

I have to maintain several SQL Server 7 DBs across multiple NT Domains (same network). How do I access the SQL Server on the second domain from enterprise manager?

Thanks!

Lia

View 1 Replies View Related







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