Newbe To SQL2005 && MSDE
Aug 29, 2005
HELP!!having on trouble installing, just gettting everything connected.(xp sp2)First i loaded MSDE, then realized i needed the web admin tool to create the db...but can't get the web admin tool to connnect to anything..so I took a stab at SQL 2005 Std ed beta.....loaded fine, but then realized i need another admin tool to create db so I loaded the xpress manager...again, loads fine, but doesnt'connec to any DB..why is this so difficult for me.....SQL Svr v6 was so much easier with enterprise manager!!!HELP!!Don
View 1 Replies
ADVERTISEMENT
Mar 31, 2008
Hello,
this is my problem:
I installed SQL 2005 Standard Edition first, then MSDE plus its SP4. Both instances are named (MC05WXPPROSQLMC for 2005 and MC05WXPPROUCTO for MSDE). I inadvertently had not allowed the TCP/IP protocol for MSDE during the installation, so I did it manually later, through SVRNETCN.exe which also ships with SQL 2005.
Now:
I CAN connect to the MSDE instance with any SQL2005 tools through shared memory. But I CANNOT connect to it through TCP/IP. I guess that this is because wrong port binding for the SQL2005 instance, MSDE instance and SQL Server Browser, but I'm not sure.
My system is Windows XP Professional.
Please help.
Any hints welcomed,
Pavel
View 5 Replies
View Related
Jan 19, 2004
Ey,
I need to do few operations on every record in a table. Do I have to use cursor? Do SQL has something like 'FOR' or 'WHILE'? I've read somewere that cursors should be avoided due to their time consumption.
Thnx
View 2 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
May 27, 2008
Hi.
I will try to abstract my problem to an example, simple as possible.
In a relational database exists 2 tables: Cars (containing car name and car id) and Costs (containing costs caused by cars - with columns like cost_id, car_id (fk to table cars), cost_category (something like 'buy', 'cleaning', 'maintenance'), cost_date and costs)
In the olap cube I've 2 dimensions: Cars and Costs and a measure sum(cost).
How can I create a measure containing the max value of the sum(costs) group by car_id?
In the SQL world it would be something like
Code SnippetSELECT
MAX(COSTS_PER_CAR)
FROM
(
SELECT
CAR_ID,
SUM(COSTS) AS COSTS_PER_CAR
FROM
tblCOSTS
GROUP BY CAR_ID
) AS TBL
But how can I realize it in MDX for using it as measure?
Thanks in advance.
Greetings.
Anatoli Rejditsch.
View 8 Replies
View Related
Jul 8, 2004
Hi, I'm developing a page in asp.net using a sqldb and one of the values I'm sending to the database is a date/time value. I only want the table to show the date in short format, no time. Is there a way to restrict or convert the data in the table design mode?
Thanks
Raif
View 4 Replies
View Related
Aug 5, 2007
Hi ppl
I just started with all this 'replication' subject and run into some 'stange ?' problem. I suscesfully set-up publisher and distributor on one computer. create subscriber on another. And seems that this is working with no errors as I see in Replication monitor, details. All agent turned to verbose output and showing no errors at all. but the strange problem that the database does not (!) appear at subscriber (?????) I mean - no tables, no stored procedures, no nothing - how it can be possible ? What I'm doing wrong ? Or what I should do ?
P.S. Forgot to add: Both servers running latest SQL server 2005 with latest Service Pack. Subscribtion of type 'push'
View 1 Replies
View Related
Dec 10, 2006
Hey All,
This is really simple basic question, and it's just so I can start to learn about MVS.
I have a sql-database called "Test" with a Table called "Agents" with just three colulms "ID", "FNAME" and "LNAME".
On the Default Page I have three Textboxes and a submit Button,
All I want to do is type "Select" criteria in Textbox1 and have Textbox2 Display the "Fname" and Textbox3 Display the "Lname".
(Using VB in ASPX)
Dim i As New SqlDataSource()
i.ConnectionString = ConfigurationManager.ConnectionStrings("Test").ToString()
i.SelectCommandType = SqlDataSourceCommandType.Text
i.SelectCommand = ((((((Now What???)))))))
End Sub
PLease Help, Thanks in advance
A....
View 2 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
Feb 26, 2007
Could someone please point me in the right direction on how to read ina large query with .net.I am trying to emulate a legacy database system so I don't know theupper bounds of the sql query. An example query would be somethinglike:Select * from invoices where year 1995the query must be updatable and only return say 10 to 100 rows at atime.It should also be forward only and discard rows no longer in use tosave memory.And if at all possible I would like to lock one row at a time as therow is read in.
View 5 Replies
View Related
Jul 20, 2005
Hi!I have a scalar function that returns integer:xview (int)Now, I'm trying to build a procedure that has the following selectinside:select atr1, xview(atr2)from tablenameBut, I get the 'Invalid name' error when I try to execute thatprocedure.If I got it right, I must use user.fn_name() syntax, but I cannot usedbo.xview() inside my procedure since it means xview will always beexecuted as dbo, which is unaccaptable.I'm a bit confused, so any hint is very welcomed.Thanks!Mario.
View 4 Replies
View Related
Feb 28, 2005
Hello, I need some help, I am in school right now and I am in a SQL server class. We have been working in the query analizer making a database. Well I have to print out everything that I have typed. But I want to view it first. How do I do that?
Sorry I did a search and couldnt find anything.. Probably cause I dont really know what to search for or look under. Thanks for your guys time.
~Matt
View 2 Replies
View Related
Dec 15, 2005
hi
i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
pls some one can help me ???
thanks
chaus
View 62 Replies
View Related
Oct 12, 2007
Can you open/use a database created in SQL2005 in SQL2005 Express?
Thanks for the help!
Max
View 4 Replies
View Related
Dec 27, 2005
I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?
View 3 Replies
View Related
Jan 4, 2007
Hi
We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,
currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.
is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.
This has to be done for our production and very critical, please help
Thanks
Samuel I
View 4 Replies
View Related
Sep 19, 2007
I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.
I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."
I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.
Can anybody please advise?
View 1 Replies
View Related
Jul 8, 2007
Hello,
I have a vb program that include a dts package that has been saved to vb with sql2000 dts wizard and works very good.
Now that I upgrade my website to sql2005, this vb dts package doesn't work.
The error I get is:
Microsoft Data Transformation Services (DTS) Package
Invalid STDGMEDIUM structure
(Microsoft Data Transformation Services (DTS) Package (80040066): Invalid STDGMEDIUM structure
) (Microsoft SQL-DMO (ODBC SQLState: 42000) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.)
I searched in the internet how to make dts package in sql2005 and save it to vb and found no information about it.
What Can I do to get the vb code of the dts package I create in sql2005 or how do i migrage the sql2000 vb dts package code to sql2005?
Thanks,
Kubyustus
View 4 Replies
View Related
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
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
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
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
Nov 13, 2006
I have some production boxes on Win 2000 32-bits OS and some production servers have been upgraded to Win2003 64-bit OS runing SQL Server 2005. There are also a number of Win2003 32-bit OS running SQL 2005.
The issue is that when linking the 64-bit production servers to the 32-bit boxes running SQL 2005 / Win 2003 OS, the linking seems to succeed, but I am unable to see a number of entries in sys.objects. Typically, these objects are User Stored Procedures.
Moreover, the linking seemed to have worked, but data extraction does not take place between the servers. However, there are no errors. The objects (user stored procs) exist on the 64-bit side, but linking does not actually happen.
Microsoft KB has addressed this in SQL 2000 case in this KB article, but has not suggested a solution for SQL 2005.
Any ideas? Has anyone else encountered this?
Thanks.
View 1 Replies
View Related
Dec 27, 2007
when iam trying to open a table in sqlserver 2005 it is showing an error as
SELECT permission denied on object 'LoginDetails', database 'LOGIN', schema 'dbo'.
how to rectify the error.
plz help me.
Thnaks in advance.
View 1 Replies
View Related
Jun 5, 2008
Dear all,
Is it possible to say sql server 2005 to use this much number of CPU..?
For Example I have 1 CPU License of SQL 2005, but I have 2 sockets in my physical box. One socket is having 2 cores. So I want to say the SQL server (2005) to use the 2 cpu's only( i.e Any of one socket)
Please advise me to do this.
I have one more question,
Is there any CPU limitation for SQL 2005 and 2008? If Yes how much cpu we can allot for the SQL 2005 and 2008
Thanks
Lakshmi.S
View 2 Replies
View Related
May 25, 2007
Hi All,
Can you send a SMS (text message to a cell phone) from stored proc?
Can it be done in SQL Server 2005?
Thanks
Live Today as if tomorrow is a DAY away :) - SuperGreen
View 2 Replies
View Related
Apr 9, 2007
On the MSDN site, I noticed new releases of SQL 2005, SP-2, dated on 4/5/2007. Are these an actual "update" to original release of SP-2?
View 1 Replies
View Related
Oct 8, 2007
I am installing sql2005 sp1 on a w2k3 Cluster. All we need is the database engine however the vendor I am working with said to install sp1 which is fine but they also said you need to install Integration services with SP1 for the Maintenenace plans.
Do I need to install Integration services on the cluster to create maintenance plans with sql2005 sp1 ??
I am getting mixed answers.
View 1 Replies
View Related
Sep 7, 2006
I hope you would help me in this problem. I use the code below for executenonquery command for mdb DB.But I do not know the changes I should made when Using SQL2005.-------------Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=C:ASPNET20dataNorthwind.mdb" Dim dbConnection As New OleDbConnection(connectionString) dbConnection.Open() Dim commandString As String = "INSERT INTO Employees(FirstName, LastName) " & _ "Values(@FirstName, @LastName)" Dim dbCommand As New OleDbCommand(commandString, dbConnection) Dim firstNameParam As New OleDbParameter("@FirstName", OleDbType.VarChar, 10) firstNameParam.Value = txtFirstName.Text dbCommand.Parameters.Add(firstNameParam) Dim lastNameParam As New OleDbParameter("@LastName", OleDbType.VarChar, 20) LastNameParam.Value = txtLastName.Text dbCommand.Parameters.Add(LastNameParam) dbCommand.ExecuteNonQuery() dbConnection.Close()--------
View 2 Replies
View Related
Dec 31, 2005
What is the quivalent of EM for SQLExpress2005? With the old SQL 2000 I used EM to manage tables, SPs and such. Now, I cannot even find the databases - I installed the Club Starter Kit and I want to view and modify some tables. How do I do that?
View 3 Replies
View Related
Jan 19, 2006
Hi folks,
i have VSTS installed and TFS beta refresh 3. all is working fine.
How can i use Visual Studio 2005 to create a new database on the remote server? i can connecto to it fine using the 'server explorer' tab .. but of course it only lists databases that currently exist. How can i create a new one?
lastly, i have no installed sql2005 express edition or whatever it is called LOCALLY on my machine. the reason i didn't do this is becuase i was hoping to use the enterprise sql 2005 server.
View 4 Replies
View Related
Feb 12, 2006
Help... I am new to C# and .net and I am trying to build a insert page with a couple of drop down controls where I pull a categoryID and subcategoryID to populate my dropdown controls from a MS sql2005 express database. I am using a book that only shows how to build the script and access a access database and I am getting this error when trying to pull up the page:
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0246: The type or namespace name 'OleDbConnection' could not be found (are you missing a using directive or an assembly reference?)Source Error:
Line 3:
Line 4: <script runat="server" language="C#">
Line 5: OleDbConnection objConn = newOleDbConnection(
Line 6: "Server=SIMBA\NETSDK;" +
Line 7: "Database=btuniverse;" +Source File: c:Inetpubwwwroot\_addnews.aspx Line: 5
Below is my code and I am not sure what the syntax needs to be when connecting to a ms sql datasource. Thanks in advanced :)
MYCODE:
<%@ Page Language="C#" MasterPageFile="~/main.master" Title="Untitled Page" %>
<script runat="server" language="C#"> OleDbConnection objConn = newOleDbConnection( "Server=SIMBA\NETSDK;" + "Database=btuniverse;" + "User ID=sa;Password=password"); OleDbCommand objCmd; OleDbDataReader objRdr; void Page_Load() { if (!IsPostBack) { objConn.Open(); objCmd = new OleDbCommand("SELECT * FROM dbo.tblNewsCategories", objConn); objRdr = objCmd.ExecuteReader(); ddlCategory.DataSource = objRdr; ddlCategory.DataValueField = "CategoryID"; ddlCategory.DataTextField = "CategoryName"; ddlCategory.DataBind(); objRdr.Close(); objCmd = new OleDbCommand("SELECT * FROM dbo.tblSubCategories", objConn); objRdr = objCmd.Executereader(); ddlSubCategory.DataSource = objRdr; ddlSubCategory.DataValueField = "SubCategoryID"; ddlSubCategory.DataTextField = "SubCategoryName"; ddlSubCategory.DataBind(); objRdr.Close(); objConn.Close(); } }
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table> <tr> <td align="right">Title:</td> <td align="left"><asp:TextBox ID="txtArticleTitle" CssClass="textbox" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="txtArticleTitle" ErrorMessage="*" runat="server" /> <br /> </td>
<!--- <asp:CompareValidator ID="cvArticleTitle" ControlToValidate="txtArticleTitle" Operator="DataTypeCheck" Type="String" ErrorMessage="No numbers allowed" />---> </tr> <tr> <td align="right"><p>Article Category:</td><td align="left"><asp:DropDownList ID="ddlCategory" CssClass="dropdownmenu" runat="server" /></td> </tr> <tr> <td align="right"><p>Article Sub Category:</td><td align="left"><asp:DropDownList ID="ddlSubCategory" runat="server" /></td> </tr> <tr><td align="right">News Article:</td><td align="left"><asp:TextBox ID="txtArticleDesc" CssClass="textbox" Columns="40" Rows="4" TextMode="MultiLine" runat="server" /> <asp:RequiredFieldValidator ID="rfvArticleDesc" ControlToValidate="txtArticleDesc" ErrorMessage="*" runat="server" /> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr></table>
<asp:Button ID="btnSubmit" CssClass="button" runat="server" Text="Submit" /></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server"></asp:Content>
View 3 Replies
View Related
Jun 13, 2006
Hi,
Just wondering if some one can help me out here I know that we can work with access2003 as a front end and SQL2000 as a back end. What I am trying to do now is working with SQL2005 as a back end I was wondering if it can be done ( I can access it but having errors creating tables etc).
Thanks
Sorry I was not sure where exactly to post this topic as it relates to both dbs so I have posted this same thread in Access as well.
View 2 Replies
View Related