I created a little test application with SQL server. After everything was tested successfully I builded a setup file with Installshield. I installed the setup file on a different mashine. Everything runs without problems, but when I make entries to the database and I reopen the application no entry is saved. I am new to SQL server.
thx for any help
Hi
I had run a stored procedure in my server that update statistics against all user defined tables in my database (MSSQL 7.0).
Since then I am getting errors in my ASP application where I am reffering to adovbs.inc.
Here is an example of errors I get.
Microsoft VBScript runtime error '800a0411'
Name redefined: 'adOpenForwardOnly'
/Essai/adovbs.inc, line 14
Below is the stored procedure I have run against the database.
Can anybody help tank you guys.
CREATE PROCEDURE update_all_stats
AS
/*
This PROCEDURE will run UPDATE STATISTICS against
ALL user-defined tables within this database.
*/
DECLARE @tablename varchar(30)
DECLARE @tablename_header varchar(75)
DECLARE tnames_cursor CURSOR FOR SELECT name FROM sysobjects
WHERE type = 'U'
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @tablename
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
SELECT @tablename_header = "Updating " +
RTRIM(UPPER(@tablename))
PRINT @tablename_header
EXEC ("UPDATE STATISTICS " + @tablename )
END
FETCH NEXT FROM tnames_cursor INTO @tablename
END
PRINT " "
PRINT " "
SELECT @tablename_header = "************* NO MORE TABLES" +
" *************"
PRINT @tablename_header
PRINT " "
PRINT "Statistics have been updated FOR ALL tables."
DEALLOCATE tnames_cursor
We have an application that takes an existing cube, clones it and then updates it in C#.
Database dbTarget = dbSource.Clone();
dbTarget.Name = databaseName_Target;
dbTarget.ID = databaseName_Target;
dbTarget.DataSourceImpersonationInfo = new ImpersonationInfo(ImpersonationMode.ImpersonateServiceAccount);
sSAS_CalculationServer.Databases.Add(dbTarget);
dbTarget.Update(UpdateOptions.ExpandFull);
We are receiving the following error when trying to Update the cube (the last line of code)Cannot update the 'Database' object 'DB Cube_Temp', it needs to be part of a connected Server object.
I am working on a package to insert and update contacts from a database into an application. To insert into application I am using script component.
So my question is can I do both insert and update script seperately in two different script components of same package.
My package looks something like this.
Can we push new inserts into one script component and updates to other script component?
Does both the script components execute at the same time?Will there be any conflicts between insert and update in the application?
Hi all,
Can anyone give me a ready-made sample script to display a search reslut from a database?
My intention is to give a dynamic web page for the search in the BookStore website.
The result will show the following:-
First the picture of the book.
To the right of it, 'Title' field, below that, 'description' field
It should be created programatically as the contents are in the database.
I tried several ways, but could not succeed. I have the BookID, Title, BookPicture, and the Description fields
Thanking you in advance,
Tomy
Can someone at Microsoft comment on this article, specifically, how it relates to SQL Replication? Will SQL Replication fall into the category of what this article describes, or only the mirroring feature?
View 1 Replies View Relatedi created a asp.net application using sql server. it retrieve data from a sql server and shows it in the form. it uses textbox control to show it. i wanna update it or add a new item in database. i wrote the code for it under update and add buttons. when i click on the update button after changing a data in textbox, the page is getting refreshed nad comign back to initial state without getting updated. but when i change the textbox1.text with a string in the code, its getting updated with string without any problem. even same problem for addition too, am using a dataadapeter and dataset for this. when i assign a string to the datset columns, its getting updated well but wheni assign it with textbox.text.tostring, nothing is happenig to database. can anyone help me in this issue, why the data was not sent to the datbase and the page is getting refreshed.. plz need help.. its urgent
View 1 Replies View Related
i have a database for an application, which has some particular fields in some table. i want to make sure that data update in those fields should be only thru the application, and no one (even dba) should be able to update data in those fields thru sql tools.
this is to make sure that no body is updating the field except the users thru the application. as these fields contain infor about "approval" of documents.
we have a new requirement that calls for also (in addition to RS's automatic directory updates) updating an organizational application database with metatdata about instances of scheduled reports, or alternatively having our app query RS's metadata for such info.
So, let's say we have a report called Sales Detail, and it runs at 8am every day of the week for client A thru the scheduling mechanism that comes with RS. Each time it runs to completion, an entry would have to be made in our organizational database representing a new run (instance) of the report under the client for whom it was run, in this case A.
Forgetting for the moment potential issues with a reporting system interfering with the transactional, or vice versa, can datasets in RS also do updates?...or can the scheduling mechanism in RS be extended to also log info to other places?...or is the metadata kept by RS (about instances of reports) easy to get to and decipher, and possibly be extended to record for which client this particular instance was run?
Hi,
Apologies if this question is similar to one posted under "Click once deployment" but I got no replies and I REALLY need to know the answer to my problem!
I am using VB on VS 2005 Express and SQL Server 2005 Express.
My application is nearing the stage where I can start to use real data (from the end user) for testing purposes. Once I am as happy as I can be, I will install the application on the user's machine and he will use the application for a few weeks, with real data, before giving me a list of problems/suggested improvements etc.
I will then need to make the changes and re-install the application on his machine without losing all the changes he has made to the DB in those weeks.
Presumably, there must be a way of updating the executables without making changes to the DB on the client machine.
This is a very serious issue for me as the data will be around 2,000 records each of over 60 fields and the raw data will come from a variety of sources including paper so the data inputting will be a massive task that I do not want to repeat!
Also, if the application were ever to be sold, then other users would want to apply updates to the software whilst keeping their own data secure.
I have tried re-publishing and installing the application after setting the Publish Status of the DB files to "Exclude" but the newly installed application fails to connect to the old version of the DB.
I would very much appreciate any help in this matter as I hope I haven't just wasted several months of coding!
Rich
SELECT ContactID,FirstName,MiddleName,LastName,Description FROM Contact
Contact table contains 4 columns as explained. in the application there is one tab called Contact where it displays Above information and description is non editable.Now the new requirement has come user can update the description information and save information in a new column say 'Description1'. that means new column needs to be added in the db and also necessary changes needs to be done at the application side
For ex :SELECT ContactID,FirstName,MiddleName,LastName,Description,Description1 FROM Contact
Now when user views the contact table it should display description info by default from 'description' table.If he edits he should see edited data from 'description1' table.the logic should if updated data is there display that data from 'description1' table other wise display from 'description' table
Hello All, i am trying to create a normal ASP.NET application using VS2005. Yesterday i was adding tables.. entering data from within "View Table Data" tab, but today i am unable to do any data insertion or updating except by entering the insert or update statement by hand. When updating data of existing record or trying to add new data, it reports that "Cell is readonly!". I did not modify any settings or configuration and actually did nothing to set it to readonly! I am quite confused to be honest and writing sql statements by hand is kinda time consuming for me if i want to update a single field. What can i do to re-enable data modifications from VS2005 without reporting readonly? Thanks,Rakan
View 1 Replies View RelatedI must release a new Db on 4/1 into an isolated small network (pier workgroup) and my choices are MSDE or Express. I'm new to both (MSDE yesterday, Express today). I am familiar with SQL Server and prefer using the tools with Express, but is it stable enough to use in this type of production environment?
View 5 Replies View RelatedI will be hosting my website in the next few months and doing more testing and I was having trouble finding a place to host the site that allows enough space for my sqlserver2005 database. I am estimating that the database will be around 40-50GB. Most hosting companies only give about 500MB for the database. Does anyone know of a company that provides more space? Also, is SQL Express production ready, or is it just for developing applications? If it is production ready, is there any "major" performace impact in using it over the full version. The reason I am asking is because hosting companies only give 500MB for a database, but alot more space for the web page. If I can put the SQLExpress file in the App_Data folder, then I will have more space. Does this even sound like it will work? Opinions are appreciated!
View 9 Replies View Relateddo i need a host with MS SQL SERVER? how do i upload my database? hmm
View 3 Replies View RelatedWe have an application that runs Jobs, each of which affect ## number of child objects (usually around 1M). When a thread gets to 5000 updated child objects it bulk inserts into a table called ActionLog with the child Id and JobId.
When the job is complete a sproc SUMs the children from the ActionLog table:
select sum(id) from ACTIONLOG where JOBID = @JobId;
It then updates the Jobs table AffectedObjectCount column with the sum(*) from above.
Instead of writing to the ActionLog table and calculating the SUM at the end I would like to do this 'real time'. After the bulk insert I would like to update the AffectedObjectCount column with the number of rows that were just bulk inserted. I tried this in the past and ran into major contention issues. There are usually 20 threads running a job so there exists a lot of potential for deadlocks.
Is there a recommended way to handle updating one column on one row from multiple threads? What is the best practice for a counter like this?
Hello,
Is SQL Server 2005 mirroring production ready yet. We have two servers and plan to set up mirroring between them. We have the Standard Editon installed on them.
Is Standard Edition sufficient or does it need Enterprise Edition?
Thanks in Advance,
Sarath R
I just set up a server with Windows 2003 Standard x64. I have a copy of SQL Server 2005 Standard Edition that I got from the Microsoft Launch event. On the back of the case, it gives version requirements for both the x86 and x64 versions. When I went to install it, it didn't ask me which one I wanted to install. When I look on the CD, I see different installers for x86 and x64 for various pre-requisites, like MSXML. As I'm installing SQL Server I see that it is installing most things to "C:Program Files (x86)" which is where 32-bit programs go.. I decided to let it finish. Most of the binaries and everything, include sqlservr.exe, are in the Program Files (x86) folder, but it did install a few things in Program Files, so it must be aware of the difference.
I checked task manager and, I see that the sqlservr.exe and SQLAGENT90.exe are NOT 32-bit processes. So, great, they're running natively in 64-bit mode! But when I look at the server options in SQL Server Management Studio, the patform is listed as NT INTEL X86. The memory page also shows an option to use AWE which according to the documentation is only available and relevant to 32-bit installations.
SO I'm pretty confused. Almost everything points to this being an x86 installation, but the running processes are running natively in x64. Does anyone know what's going on here?
I just tried to run the x64 version of SP1 for SQL 2005, and it told me that it cannot update x86 products, so I guess that clinches it. I'm still pretty confused and annoyed though. If this isn't x64, how can I get an x64 version of the same product, and will my license key work?
We are using SQL Server CE 3. So far, the product gets an A for ease of installation and its ability to deal with complex queries and but fails in a number of other areas. This is causing mjor project overruns.
1. Speed is a major concern. Small simple queries take an unreasonable tme to execute. This has required fundamental changes to current design patterms and a major re-write.
2. Bugs: Set identity_insert tablename on: tablename appears to be case sensitive (10 hours to track this beasty down)
3 Vista seems to have its own issues - refusing to cast fieldnames for simple column names
eg 'Select UID as DepositID ...' returns a "DepositID" under Windows XP but returns "UID" under Windows Vista.
Does this mean there is a different engine operating in the Vista environment. [I have since tracked this to a quirk in the SDAC interface ]
All this in a product we are intending to ship in the near future.
Ar others having these / similar problems?
Is there a register of known issues and workarounds?
Is the product under active repair / development ?
Why is behaviour different under Vista?
I am getting alerts as Availability group not ready for automatic failover , how to check and resolve the issue ?
How to check the databases status whether they are in sync unsync in High availability ?
We're using ADO disconnected recordsets. On SQL 2000, we could update these on the client (without propagating the changes to the server) even if the underlying view or table was non-updatable.
When running our apps against SQL 2005 (using the same client-side environment), we can no longer change any attributes of those disconnected recordsets, that connect to a non-updatable database object (the rest of the app runs fine, we can update all updatable database objects through disconnected recordsets) . Does SQL 2005 respond to such calls differently from SQL 2000, so that ADO recordsets are built in a new way (which makes them read-only in our setting)?
Thanks for any suggestions.
Rene
how to resolve and trouble shoot the availability group is not ready for automatic failover in sql2012
View 4 Replies View RelatedHello,Is the multiple instances capability of SQL2K mature enough for aProduction system?We're looking at upgrading our hardware but the proposed solutioncalls for consolidating two currently separate SQL Server's onto onemachine with two CPU's.Of the current two servers, one is for OLTP (~800Mb) and the other forreporting (some ad-hoc, some canned queries, 2-3Gb). We purge the OLTPdb nightly and archive the purged data in the reporting server whereit stays for a couple of months before getting purged from there.Maybe I'm being overly cautious here but the OLTP system is especiallytime-sensitive. If anything causes it to slow down significantly welose $$$.Thanks,Martin V.
View 1 Replies View RelatedI cannot understand how this was allowed to happen, but I can recreate the situation all day long. Someone, please tell me that I have missed an obvious solution to this;
With a fresh install of SQL 2005 Express (SP2) I have 4 databases installed and two service-based applications running. One of the service applications uses/requires three of the four databases and the second service application uses/requires the fourth database.
On boot, with the above described services set to depend on SQL Server service startup I get repeated failures on initial database access. Looking at the event log reveals why (in sequence):
SQL Server Startup...
Event: Server local connection provider is ready to accept connection on...
Event: Server named pipe provider is ready to accept connection on...
Event: Server is listening on [ 'any' <ipv4> 1911]
Application Service Startup...
Event: SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again
Moments Later:
Event: SQL Server is now ready for client connections. This is an informational message; no user action is required.
Now, its clear that the SQL service has started, and that this opens the floodgates for dependant services to start, each of which is told - essentially - to go away and come back once the SQL server has **really** started. With the accompanying suggestion to 'look for the informational message that indicates that SQL Server is ready' in the event log.
Am I reading the situation right so far?
In response to this, with my developer way of thinking, I could probably script the startup of application services rather than have them start automatically at boot or some such insane idea. But its not really the way that I had planned to spend the next few hours of my life, and it seems to me that I should not have to do such a thing.
Our in house service application (one of the two described) is in fact robust enough (just enough) to survive and to try the connection periodically, accomplishing a successful startup even with no database available.
The second of the two services is external and is unfortunately unable to start with no database available (Business Objects XI CMS). The normal means of making this service robust against database outages is the service restart procedure setting. But since the service doesnt ever start successfully, this doesnt work (learn something new every day - the restart is literal. It does not provide an initial startup retry and the service must have been started and fail for the retry to kick in)
Now, im not trying to bash anyone over this situation and regardless of the inflexible nature of the external service application and the general sillyness of the SQL server startup sequence - i mean c'mon... we are started but not ready? How about dont report startup until after you are ready? - the end result is that I need to come up with a solution to this problem.
I cant imagine that this is the first time that this behaviour has been questioned and I have to believe that there will be a simple, reliable workaround. I will keep looking for myself, but if any of this sounds familiar and you have a suggestion, your response will be greatly appreciated.
Hi,
I have a package which reads an XML file from a certain folder and parses it.
I deployed my package onto the server. Copied XML files on the D: drive the following folder on the server.
Dim reader As New Xml.XmlTextReader("D:AppsRequestClientsClientsStatus.xml") is fine.
But
Do While (reader.Read())
generates "The Device is not ready"
I think it is still trying to read it from my desktop on which I don't have a D drive.
Any help is appreciated.
When I execute the following transaction log backup TSQL in SSMS
BACKUP LOG ProductDB
TO DISK = 'D:Database_BackupTransProductDB.trn';
I get this error:
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'D:Database_BackupTransProductDB.trn'. Operating system error 21(The device is not ready.).
Msg 3013, Level 16, State 1, Line 2
BACKUP LOG is terminating abnormally.
I also have a daily database backup job that puts the backup file under this directory.
D:Database_BackupData
So I changed the path to this and it still fails.
BACKUP LOG ProductDB
TO DISK = 'D:Database_BackupDataProductDB.trn';
However if I change it to this path, it works:
BACKUP LOG ProductDB
TO DISK = 'MyServerDataProductDB.trn';
This turns out to be the path I used a few weeks back when I backed up the log for the very first time. But I now wanted to store my transaction log backups in D:Database_BackupTrans.
1. Created a database with a couple of tables with no data.
2. Taken a full database backup - db.bak.
3. Deleted the database.
4. Restored the database db.bak and filled the tables with some data.
5. Taken log backup - dblog.trn
BACKUP LOG <dbname> to DISK='D:Demodblog.trn' WITH NO_TRUNCATE, INIT
6. Dropped the database again.
7. Restored the database again from db.bak.
8. But when I am trying to restore log file dblog.trn on this database, i keep getting this error :
The log or differential backup cannot be restored because no files are ready to rollforward.
Msg 3013, Level 16, State 1, Line 2 RESTORE LOG is terminating abnormally.
Hi folks
I attended one of the SQL Server 2005 "Ready to Launch" parties a couple of years ago and was given a complimentary SQL Server Standard Edition CAL along with a copy of the SQL Server 2005 Standard setup DVD.
As there's no mention in the "Ready to Launch" pack of an included Server license I was wondering whether it is possible to install a copy of SQL Server 2005 on a standalone server and use the single CAL in a Production environment without having to purchase a Server license? The pack does include a Product Key - is this the Server license?
Thanks
Chris
Hi, I attended the Technet Ready to Launch event and obtained the dvd set, but when I tried to install the sql product, the software won't take the product key (the key is the same as the studio product). Anyone experience the same?
View 16 Replies View RelatedI missed the ability to restore based on a time (10/23 6pm) due to our purge cycle in our production environment, but I was able to obtain the 10/18 full backup, the 10/23 differential backup, and the 4, 10/23 trans. log backups. I moved all the fore mentioned files to a staging environment, and now I am trying to restore all of the files to 10/23 6pm and I get :
"The log or differential backup cannot be restored because no files are ready to rollforward" error.
I have a simple class libarray that I have compiled into DLL using csc.exe
Source code is as follows: -
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using Microsoft.SqlServer.Server;
namespace RTFTextParser
{
public class ParseText
{
[SqlFunction(DataAccess = DataAccessKind.None)]
public static String ParseRTFText()
{
return "Imtiaz";
}
}
}
When I try to run the following
CREATE ASSEMBLY RTFTextParser FROM 'E:Class1.dll'
I get the following error
Msg 6501, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not open the physical file 'E:Class1.dll': 21(The device is not ready.).
hi need help how to send an email from database mail on row update
from stored PROCEDURE multi update
but i need to send a personal email evry employee get an email on row update
like send one after one email
i use FUNCTION i get on this forum to use split from multi update
how to loop for evry update send an single eamil to evry employee ID send one email
i update like this
Code Snippet
:
DECLARE @id nvarchar(1000)
set @id= '16703, 16704, 16757, 16924, 17041, 17077, 17084, 17103, 17129, 17134, 17186, 17190, 17203, 17205, 17289, 17294, 17295, 17296, 17309, 17316, 17317, 17322, 17325, 17337, 17338, 17339, 17348, 17349, 17350, 17357, 17360, 17361, 17362, 17366, 17367, 17370, 17372, 17373, 17374, 17377, 17380, 17382, 17383, 17385, 17386, 17391, 17392, 17393, 17394, 17395, 17396, 17397, 17398, 17400, 17401, 17402, 17407, 17408, 17409, 17410, 17411, 17412, 17413, 17414, 17415, 17417, 17418, 17419, 17420, 17422, 17423, 17424, 17425, 17426, 17427, 17428, 17430, 17431, 17432, 17442, 17443, 17444, 17447, 17448, 17449, 17450, 17451'
UPDATE s SET fld5 = 2
FROM Snha s
JOIN dbo.udf_SplitList(@id, ',') split
ON split.value = s.na
WHERE fld5 = 3
now
how to send an EMAIL for evry ROW update but "personal email" to the employee
Code Snippet
DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX)
SET @xml =CAST(( SELECT
FirstName AS 'td','',
LastName AS 'td','' ,
SET @body = @body + @xml +'</table></body></html>'
EXEC msdb.dbo.sp_send_dbmail
@recipients =''
@copy_recipients='www@iec.com',
@body = @body,
@body_format ='HTML',
@subject ='test',
@profile_name ='bob'
END
ELSE
print 'no email today'
TNX
Hello,I am trying to update records in my database from excel data using vbaeditor within excel.In order to launch a query, I use SQL langage in ADO as follwing:------------------------------------------------------------Dim adoConn As ADODB.ConnectionDim adoRs As ADODB.RecordsetDim sConn As StringDim sSql As StringDim sOutput As StringsConn = "DSN=MS Access Database;" & _"DBQ=MyDatabasePath;" & _"DefaultDir=MyPathDirectory;" & _"DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" &_"PWD=xxxxxx;UID=admin;"ID, A, B C.. are my table fieldssSql = "SELECT ID, `A`, B, `C being a date`, D, E, `F`, `H`, I, J,`K`, L" & _" FROM MyTblName" & _" WHERE (`A`='MyA')" & _" AND (`C`>{ts '" & Format(Date, "yyyy-mm-dd hh:mm:ss") & "'})"& _" ORDER BY `C` DESC"Set adoConn = New ADODB.ConnectionadoConn.Open sConnSet adoRs = New ADODB.RecordsetadoRs.Open Source:=sSql, _ActiveConnection:=adoConnadoRs.MoveFirstSheets("Sheet1").Range("a2").CopyFromRecordset adoRsSet adoRs = NothingSet adoConn = Nothing---------------------------------------------------------------Does Anyone know How I can use the UPDATE, DELETE INSERT SQL statementsin this environement? Copying SQL statements from access does not workas I would have to reference Access Object in my project which I do notwant if I can avoid. Ideally I would like to use only ADO system andSQL approach.Thank you very muchNono
View 1 Replies View Related