Create Or Modify MSDE Database
Dec 4, 2003
Hi,
On Administrator session, I have created an CUSTOMER MSDE database. That's OK.
On user session, I want to access on my database CUSTOMER but I have on error : "Unable to connect to the database". And, in French : "Echec de la connexion de l'utilisateur Machine_Name/User_Name".
What is the error ? I don't know what to do any more.
How to give right to the user ? Have you an idea ?
Thank's.
Patrice A. BONNEFOY.
View 2 Replies
ADVERTISEMENT
Sep 25, 2005
I have install the MSDE from Ofiice 2000 cd and my MSDE sql server is running fine that I can see from my tray bar with green arrow button. Now i want to create the database so can any body tell me how do i create database. Is there ne query analyser or enterprise manager by which I can create database. Also when i try to install starterkit it doen not allow me to install it. It ask me to select database from the dropdown list and when I select Localhost (only option available) and click on test connection it gives me error UnsuccessfullI am new at MSDN so please help me.
View 4 Replies
View Related
May 12, 2004
Hi,
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
View 1 Replies
View Related
Jun 17, 1999
HOW TO GET A FILE'S CREATE DATE??
From SqlServer I need the create date of a file on C or D.
Is there a function or code to retrieve the create date,
or an API that could read and pass back the file's creation date???
View 1 Replies
View Related
May 22, 2006
Getting this message on my event log:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
View 1 Replies
View Related
Nov 22, 2005
Does anybody know how to create/modify a file without using one of the system stored procedures?
Thanks
View 1 Replies
View Related
Jul 20, 2005
Hi,I'm a newbie to sql server and this may be a really dumb question forsome you. I'm trying to find some examples of sql server triggers thatwill set columns (e.g. the created and modified date columns) if the rowis being inserted and set a column (e.g. just the modified date column)if the row is being updated.I know how to do this in oracle plsql. I would define it as a beforeinsert or update trigger and reference old and new instances of therecord. Does sql server have an equivalent? Is there a better way to dothis in sql server?Thanksericthis is what i do in oracle that i'm trying to do in sqlserver...CREATE OR REPLACE TRIGGER tr_temp_biubefore insert or updateon tempreferencing old as old new as newfor each rowbeginif inserting then:new.created_date := sysdate;end if;:new.modified_date := sysdate;end tr_temp_biu;
View 1 Replies
View Related
May 14, 2007
Hi, all experts here,
Thank you very much for your kind attention.
I am trying to modify the files path (primary file, log file) of databases, but it looks like I am not able to mofidy their files path directly from the database property dialogue? Would please any experts here give me some ideas on what else can I try to figure it out? Thanks a lot in advance and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
View 5 Replies
View Related
May 21, 2008
hi there,
After replicating a database, the stored procedures in that same database are not able to edit by other users than service account (sys admin users), When the normal users try to edit any of the stored procedures, sql server 2005 is throwing the following error...
Msg 21050, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 12Only members of the sysadmin fixed server role or db_owner fixed database role can perform this operation. Contact an administrator with sufficient permissions to perform this operation.
any suggessions are most welcome.
by
CHINNASAMY
View 1 Replies
View Related
Oct 2, 2007
I am using SQL express and Visual web developer on windows Vista.
When I try to create a new database the following message appears.
CREATE DATABASE permission denied in database master (error 262)
I log on to my computer as an administrator.
Help appreciated
Prontonet
View 4 Replies
View Related
Feb 20, 2006
Windows XP
SQL Expresss 2005
SQL Express 2005 Manager
I simply want to edit and data I have in a database that I made with Express Manager. This worked before .Net 2.0. Now, I have the table displayed as a datagrid with an "edit" pushbutton associated with each row in the database table. When I click on the "edit" pushbutton to edit a specific row in the database table, instead of posting me to a page where the chosen row is editable, I am posted back to the same page without the chosen row availible to be edited.
What am I doing wrong? How can I fix this? I am totally new to this so any help would be appreciated.
Cheers!
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" EnableEventValidation="false" %><%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %><MM:DataSet id="dsParts"runat="Server"IsStoredProcedure="false"ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_PartsAreUs"] %>'DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_PartsAreUs"] %>'CommandText='<%# "SELECT * FROM dbo.Parts" %>'Debug="true"> <EditOps> <EditOpsTable Name="dbo.Parts" /> <Parameter Name="Name" Type="VarChar" /> <Parameter Name="Description" Type="NVarChar" /> <Parameter Name="Price" Type="Money" /> <Parameter Name="PartID" Type="Int" IsPrimary="true" /> </EditOps></MM:DataSet><MM:PageBind runat="server" PostBackBind="true" /><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><title>Untitled Document</title></head><body><form runat="server"> <asp:DataGrid id="dgParts" runat="server" AllowSorting="False" AutoGenerateColumns="false" CellPadding="3" CellSpacing="0" ShowFooter="false" ShowHeader="true" DataSource="<%# dsParts.DefaultView %>" PagerStyle-Mode="NextPrev" DataKeyField="PartID" onCancelCommand="dsParts.OnDataGridCancel" onEditCommand="dsParts.OnDataGridEdit" onUpdateCommand="dsParts.OnDataGridUpdate" onItemDataBound="dsParts.OnDataGridItemDataBound" > <HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" /> <ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" /> <AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" /> <FooterStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" /> <PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" /> <Columns> <asp:EditCommandColumn ButtonType="PushButton" CancelText="Cancel" EditText="Edit" HeaderText="Edit" UpdateText="Update" Visible="True"/> <asp:BoundColumn DataField="PartID" HeaderText="PartID" ReadOnly="true" Visible="True"/> <asp:BoundColumn DataField="Name" HeaderText="Name" ReadOnly="false" Visible="True"/> <asp:BoundColumn DataField="Description" HeaderText="Description" ReadOnly="false" Visible="True"/> <asp:BoundColumn DataField="Price" HeaderText="Price" ReadOnly="false" Visible="True"/> </Columns> </asp:DataGrid></form></body></html>
View 3 Replies
View Related
Mar 1, 2006
I have replaced the installation of MSDE 1.0 with MSDE 2000.
Prior to installation of MSDE 2000, I can perform the activities of all
database role. Now, I can only add, change and delete data - no
more database design.
What should I do to regain database design permission?
I'm using "sa" user with blank password when I login to MS Access Project.
View 5 Replies
View Related
Jan 20, 2008
Hello, I have gone to work for a new company and I have seen this company is running out of drive space on a daily basis. The DBA before me created huge databases. For example we have a database that it's created size is 103 GB. Only about 52 GB is ever needed. I know you can resize the tempdb but how about user databases? I have never tried this. Can this be done for a user database?
For tempdb
Start SQL from cmd line sqlserver -c -f -s%instance_name%
alter databse tempdb modify file
(name='tempdev',size=150)
View 3 Replies
View Related
Oct 4, 2007
I have 30+ databases in sql 2000.
I want to dynalically loop though each of the databases and alter a column named 'EmpName' for all the 'Employees' tables in that database.
Here is my attempt.use Master
go
declare @SQLString Nvarchar(1000)
declare @DBName Nvarchar(100)
declare @SQL2 NVARCHAR(1000)declare @TABLE_NAME NVarchar(100)
DECLARE curDB CURSOR LOCAL FORWARD_ONLY STATIC FOR
SELECT name FROM sysdatabases
OPEN curDB
FETCH NEXT FROM curDB INTO @dbname
While @@FETCH_STATUS=0
Begin
SET @SQL2 = 'USE ' + @DBNAME + ' ALTER TABLE ' + @TABLE_NAME + ' MODIFY EmpName varchar(100)'
from information_schema.tables where table_type = 'BASE TABLE' and table_name like '%Employees%' PRINT @SQL2
EXECUTE SP_EXECUTESQL @SQL2
fetch next from curDB into @DBName
end
Close curDB
End
When i execute the above script in master, it says 'Query executed successfully' but when i see the all the Employees table in each of the database, the required change is not made.
Can anybody explain this or give an alternate solution?
View 2 Replies
View Related
Jun 25, 2015
We are running into the following error while changing a column data type from nvarchar (1200) to varchar(8000)
"Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'dbo.TBL1 '.'PK_CL_ID' in database 'Client01' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The statement has been terminated."
Now tried to change the filegrowth of the log file to unlimited
ALTER DATABASE Client01
MODIFY FILE ( NAME = Client01_log, MAXSIZE = unlimited);
The query executes without error but I do not see the auto growth as unrestricted. It's still 2GB
View 6 Replies
View Related
Nov 6, 2015
I can run this command to make changes for 1 DB USE [master]
GO
ALTER DATABASE [DBName] MODIFY FILE ( NAME = N'Name_log', FILEGROWTH = 10000KB )
GO
Is it possible to create a script which changes log file size to let's say 100MB for all DBs in all servers instead of running the above command by logging into each server? We have about 200 servers and close to 3000 DBs.
View 2 Replies
View Related
May 6, 2015
I need reflecting changes of csv file in oracle DB. Suppose, I load single csv file in oracle DB which contains 10 rows. After some time, I have loaded another CSV file which has the modified row of the previously loaded csv file. So, how can I capture the CSV changes and how it is going to get reflected in oracle DB?There is no unique column in csv file to identify particular row.
View 3 Replies
View Related
Apr 23, 2006
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!?
Or... is there a way to attach the databases to SQLExpress manually?
Help pls?
View 1 Replies
View Related
Jul 23, 2005
Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott
View 1 Replies
View Related
May 20, 2008
the subject pretty much says it all, I want to be able to do the following in in VB.net code):
{[If [table with this name] already exists [in this sql database] then [ don't create another one] else [create it and populate it with these values]}
How would I do this?
View 3 Replies
View Related
Jul 20, 2005
Can I dynamically (from a stored procedure) generatea create table script of all tables in a given database (with defaults etc)a create view script of all viewsa create function script of all functionsa create index script of all indexes.(The result will be 4 scripts)Arno de Jong,The Netherlands.
View 1 Replies
View Related
Apr 22, 2006
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Or... is there a way to attach the databases to SQLExpress manually?
Help pls?
View 3 Replies
View Related
Jul 20, 2005
I have some code that dynamically creates a database (name is @FullName) andthen creates a table within that database. Is it possible to wrap thesethings into a transaction such that if any one of the following fails, thedatabase "creation" is rolledback. Otherwise, I would try deleting on errordetection, but it could get messy.IF @Error = 0BEGINSET @ExecString = 'CREATE DATABASE ' + @FullNameEXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'CREATE TABLE ' + @FullName + '.[dbo].[Image] ( [ID][int] IDENTITY (1, 1) NOT NULL, [Blob] [image] NULL , [DateAdded] [datetime]NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorENDIF @Error = 0BEGINSET @ExecString = 'ALTER TABLE ' + @FullName + '.[dbo].[Image] WITHNOCHECK ADD CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ( [ID] ) ON[PRIMARY]'EXEC sp_executesql @ExecStringSET @Error = @@ErrorEND
View 2 Replies
View Related
Mar 26, 2008
I'm new to using SSIS and have been reading and learning slowly how to use it. I'm trying to create an identical copy of our database for reporting. I've used the Import/Export wizard, but have had some issues with foreign keys and with sql_variant columns.
I've tried searching for anything but haven't had any luck as of yet. I guess I don't even know where to start or what to look for.
Any help would be appreciated. Thanks!
View 9 Replies
View Related
Sep 26, 2006
Downloaded and installed MSDE and just finished creating a
website using the Community Starter Kit. I'm used to working with Access
Databases and this is my first experience with anything SQL. Can someone
provide my with some guidance as to what I need to do to upload the MSDE
Database to a server. Can I just upload the files like an Access Database
or is this more involved. Thanks for you help.
View 5 Replies
View Related
Nov 13, 2003
I'm using Visual Studio.Net enviroment, i have SQL desktop Engine installed and everything is working great. I have a problem that whenever i create a new database connections i can NOT delete it. I know that i have to select the node containing the connection and then press the DEL Key, but it seems that the delete option is not valid!
Any Suggestion?
View 3 Replies
View Related
Apr 6, 2004
OK
I've loaded MSDE and its running OK
I've run config.exe to install the sample .net databases,
......but I cannot find northwind or anyother db on the server!
I've never done any db work befor so may be I'm being a bit of a tit!!! sorry in advance if i am...
stuart
View 3 Replies
View Related
Dec 24, 2004
Hi, I am new to .net, I installed .net sdk and framework.
now I downloaded MSDE and installed it, I got this directory : C:MSDERelA
but when I double click in the setup file nothing happened, please help me on what should I do .
thanks
View 1 Replies
View Related
Mar 10, 2005
Hi,
I installed MSDE and the sample databases with it. They work fine.
Well I am using the server explorer of visaula studio standard 2002. I can see all the sample databases there and connect to them as well.
1.
--------------------------------------------------------------------
Now i created a new database named "testDb" and in a similar fashion i am using windows login thingy.
When i write my connection string in the program now it doesnt work
string connectionStr =@"Server=IMRANNetSDK;" + "Integrated Security=SSPI;" + "Connection Timeout=7;" + "Database=testDB;";
If i replace my Database clause to Northwind it works absolutely fine.
The ERROR it gives is:
Cannot open database requested in login 'testDB'. Login fails. Login failed for user 'IMRANASPNET'.
Why is this happenning? :(.
============================================
2.
-------------------------
How can i configure the MSDE to use the SQL Authentication.
It doesnt allow me to do that?
Thanx Heaps,
Imran
View 2 Replies
View Related
May 13, 2005
I'm running Windows 2003 .NET server (1
year trial) and I have the latest version of MSDE installed. I have
WebMatriX II installed.
I want to create an MSDE database I can use with a DSN so can use in .ASP or APS.NET.
I've successfully created a test
database (in Webmatrix II) via Windows Authentication security and have
created a DSN via ODBC/Windows Authentication security but don't know
how to access in ASP or ASP.NET web page.
All the SQL databases I use in .ASP have a DSN, User, Password as connection parameters. I want to continue this process.
I ran the command list: setup
SAPWD=**secret** SecurityMode=SQL after setting up MSDE SP3. I log into
the server as "Administrator" with a password.
Question:
1. What am I supposed to use as a ID and
Pass if I want to setup a MSDE database in WebMatrix II using SQL
Server authentication? Everything I try fails. I was never asked to
provide a beginning ID and Pass for SQL(MSDE) Server.
2. What does the connection string look
like to access the database in ASP.NET for Windows Authentication
security? Like this: ConnectionString= "server='localhost';
trusted_connection=true; database='ichapter_test'".
3. What would it look like in .ASP?
Thanks in advance!
JurekWorks
View 1 Replies
View Related
Jul 27, 2005
HiI am just starting my first .NET project using the web matrix and an MSDE database. I am pretty much at the limit of my knowledge - all very interesting. I have some data in an Access spreadsheet (6 columns and 365 rows) which in the past I have copied and pasted into an Access database table. How do I get it into a MSDE database table? This process does not need to be automated/programmed as I will only have to do it once a year. Any ideas on the easiest way forward would be much appreciated.Thanks in advance.Mike
View 2 Replies
View Related
Aug 18, 2005
I'm trying to build a record update form and I'm
going off the "Build Your Own ASP.NET Website" book. I'm not getting
any compilation errors; the database just doesn't update.
void Update(Object s, EventArgs e) {
SqlConnection upConn = new SqlConnection(
"Server=****\netsdk; database=CLASSIFIEDS; User ID=****; Password=****;");
SqlCommand upCmd;
upCmd = new SqlCommand("UPDATE CLASSIFIEDUSER SET
ITEMHEADLINE=@ITEMHEADLINE, ITEMDESCRIPTION=@ITEMDESCRIPTION,
CONTACTNAME=@CONTACTNAME, EMAIL=@EMAIL, HOMEPHONE=@HOMEPHONE,
WORKPHONE=@WORKPHONE, CELLPHONE=@CELLPHONE, BUILDING=@BUILDING,
ROOM=@ROOM, PRICE=@PRICE WHERE ID=@ID", upConn);
upCmd.Parameters.Add("@ITEMHEADLINE", headline.Text);
upCmd.Parameters.Add("@ITEMDESCRIPTION", description.Text);
upCmd.Parameters.Add("@CONTACTNAME", contact.Text);
upCmd.Parameters.Add("@EMAIL", email.Text);
upCmd.Parameters.Add("@HOMEPHONE", home.Text);
upCmd.Parameters.Add("@WORKPHONE", work.Text);
upCmd.Parameters.Add("@CELLPHONE", cell.Text);
upCmd.Parameters.Add("@BUILDING", building.Text);
upCmd.Parameters.Add("@ROOM", room.Text);
upCmd.Parameters.Add("@PRICE", price.Text);
upCmd.Parameters.Add("@ID", Request.QueryString["id"]);
upConn.Open();
upCmd.ExecuteNonQuery();
upConn.Close();
Response.Redirect("preview.aspx?id=" + Request.QueryString["id"]);
}
The Response.Redirect works so I'm thinking there must be an SQL syntax error or something but I can't see it.
View 16 Replies
View Related
Sep 25, 2005
I have installed the MSDE from Office 2002 CD and MSDE is running. I can see the SQL Server Icon in tray with green arrow. CAn ne body help me how to create database in the MSDE. I am new to this. Is there any query manager or entrprise tool by which I can create database and table in it. Also I am not able ro install the Starter Kit .Please help me in this.
View 1 Replies
View Related
