I have created a VB 6.0 application that reads data from old db files into the SQL Server 2000 database using DTS stored structure files.
The application works fine with Windows NT but I keep getting an error in Windows 2000 environment.
"-2147220441(80040427) Execution Canceled By User"
Any ideas why?
I currently run SQL Server 2005 64-bit Developer Edition (Service Pack 2 - it will be SP 3 as soon as I can get hold of it). I am running this on a stand-alone box with Windows Server 2003 as the OS.
Soon, I will be buying another computer for a colleague who will be running SQL Server as specified above. However, I am not happy with Windows Server and am wondering about changing to either XP 64-bit or Vista 64-bit. The machine will not be networked.
I would welcome advice on this since, in some ways, I would be happy enough to use XP or Vista, and think that 64-bit development is more likely on Vista than on other Windows OS's. However, I am not convinced that SQL Server 2005 works with Vista and, like everyone else, have heard plenty of complaints about Vista.
All advice gratefully received.
Thanks.
Chris
I was going over this article , and was intrigued by this statement "If SQL Server 2005 Express is running on Windows XP Home, it is limited to five simultaneous connections. If it is running on Windows 2000 or Windows XP Professional, it is limited to 10 simultaneous connections. However, these are limitations of the operating system and not of SQL Server 2005 Express."
What are simultaneous connections? Is this related to Max worker threads defined as 255 on other editions? How does underlying OS impose how many connections can be done to SQL server. And finally how many simultaneous connections can be done in Windows Server 2003?
I have a problem where Backup Exec crashed during a backup of a SQL database and now SQL show 3 extent lock that are now redundant. These cannot be removed from Enterprise manager Is it therefore possible to remove them directly from the master database ??
Thanks
I need to syncronize two separate databases. One is SQL Server the other is MySql. I don't have a lot of experience with MSSQL and need a little advice on how best (in terms of speed especially) to gather records that have been added since the last sync and any that have been modified. The table in question has datetime fields for both, the time each record was created (CreatedTime) and the time that the record was last modified (ModifiedTime). Sync will happen daily.
I have worked out a few ways I might do this with DATEADD or DATEDIFF, but my question is, what is the most effecient way? Currently I'm just looking for a way to get inserted and updated records from SQL Server to MySQL. I may have to do a two way sync of some sort later.
I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I haven´t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks
informatics
I was wondering if anyone could suggest a web-based help desk systemthat uses MS SQL server that also has a knowledge base and also allowssupport employees to log how much time they have spent on eachparticular ticket. I'm after an 'affordable' system that would be usedby about 35 people.Otherwise, if you can think of a better place to ask around, let meknow!Regards,Belinda
View 1 Replies View RelatedI have a client that would like to archive all of the documents .word, .xls, .pdf, .jpg, email coorespondance, etc. into some sort of database so in the near future when the project starts up again all of the information is in a clear consise format. I was hoping that this forum could provide some guidance in selecting a software package and a discussion on how to proceed.
I have 6 gigs of documents in a folder on our server.
I was planning on delivering the organized data on a external hard drive after putting the data into some sort of database.
I would like to include metadata about each particular document.
like
who created the document,
Key words about the document's purpose,
time frame the document is revelant for,
and so on.
I would like to use a database structure and possibly hot link the document to the DB.
I would like to use xml (if possible) for the metadata.
any help is greatly appreciated on this
I can be reached at
khively at maximusa dot com
for any additional questions
Does anyone have a description of what is a System Analyst responsibility should involve. I was recently assigned the title and is no longer sure what my responsibility should entail. I asked mgmt for a description. Still waiting.
Thanks.
Hi everyone,
Im having a hard time deciding what approach should I take. The scenario is this: I have developed various systems (inventory, HR, accounting, etc.). All this systems are (and should be) tightly integrated with one another. At present, for all these systems, i've used a single DB prefixing the tables with the systems name (eg. Inventory.Items).
My question is: did I did the right (and practical) thing? Or should I create a DB for each system to organize them? The problem with multiple DBs is some system uses the other system's table(s). Example, if i created a separate DB for accounting, and a separated DB for inventory, and another for HR, how am I going to relate inventory and HR's accounts to the accounting DB's table? I want a single instance for each table; I don't want to create another account table for inventory or HR so I can enforce integrity. And if different DBs, is there a performance impact on this?
Or is there another way? My concern is performance and manageability. Please help. Thanks!
Hi evrybody,
I MBA Systems (2005 passout) and doing OCA & OCP.
but currently doing job as HR (1.5 yrs exp).
I want to know How tough it will be for me to get job in Software?
Is it so easy guys?
I'm working on an income deferral problem and we are using IRR to end up calculating periodic income.
As an example, I have the following inputs:
Number of periods = 9
Initial Loan = 21.46
Instalment amount =15.30
Future value=0
Guess=0.1 (10%)
Using a compiled function from Visual Studio in SQL Server 2008 we get a result of 70.71656373
Using a Microsoft Access function we get NaN
Using Microsoft Excel we get NaN
Using a web calculator we get 70 (ish, the calculator rounds the numbers)
I know that the numbers are odd, some of our data is dirty so we do expect that. I was expecting the SQL process to kick out an error (therefore converting the result into 0), but it doesn't.
In 2000 there was a server level setting you could change in EM, to allow direct modifications to systems catalogs.
in 2005 I would like to update some sids in sysusers tables, do I also need to find and set this option first
Hey guys want a suggestion from you I am a Masters Student here in USA This forum helped me a lot when I was doing internship.My university is offering tution wavier for these to jobs "1)backup systems support
2)Database admin" .I know MySql also took course for basic database .
The question is if any of you please tell me what all I have to do in these job if ...if ... :) I get this job .Thanks based on your answer only I will apply for this job its 20 hrs a week commitment with college
assignment .
Thanks
Sam!
We're planning to migrate our db to new and more disk drives, fasterRAID levels and more dedicated disk usage(e.g. placing the translog ondedicated disks). The db server runs on Win2003.Right now we're thinking about what file system to use on the newdrives. We opt for performance, but expect reliability as well.(Goeswithout saying, IMHO ;-))
Quote:
I want to change the (dateformat) columns in (syslanguages) tables from dmy to mdy in SQL Server 2005,
but the update query did not success, and error message (Ad hoc updates to system catalogs are not allowed) .
Although I used
sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE
before executing the update statement.
Can any body help me.
I am using SQL 2005 with reporting services, I have very basic reports, most users can print fine with the print icon in the toolbar, some users get the Blue screen and have to reboot. They have the rsclientprint.dll loaded in the browser, we have deleted it and reloaded, what do I do ?
View 1 Replies View Related
Hello,
I am in the process of learning SSIS to step into a business intelligence role in my company, which is a Microsoft CRM/GP VAR. I plan to use SSIS for building data warehouses. However, I'm aware that my company also uses a tool called Scribe to integrate data from non-CRM systems into Microsoft CRM. Can anyone explain to me the difference between SSIS and Scribe? Can SSIS reasonably accomplish what my company now uses Scribe to do? Mostly, Scribe seems to be used for scheduled one- or two-way scheduled data pushes.
Thanks,
Andy
We are currently utilizing a risk management software that is using a SSMS back end. However the database is extremely normalized and hard to find data. I am looking for one particular item (column) to bounce against another report I created, to find the delta's.
I found an XML string that looks to have data captured in it, almost like VB marked up in XML. This XML has the column name (source and the desitination column). However when I go into the other tables I am unable to find either column?
Could it be that the application is referencing the XML strings in the column to present the data through the application? Is this some sort of way to prevent people from back dooring their data? Maybe I just missed the table with the column name.
Hi all,
I am a Windows Sysadmin (Active Directory, infrastructure, etc) with light knowledge of SQL 2005. I can set up the database cluster on a shared storage device, I know how to get the heartbeat, do simple backups, etc.
My question pertains to disaster recovery. Right now, we use a product called DoubleTake to copy our database over and 'assume' the identity of the failed SQL server. There are two problems with this -- cost of the license of DoubleTake, and additionally, is it the best method?
I have read before, that you don't need to be a DBA to set up a DR scenario for SQL. My goal really is to have two databases -- one in our production location, and one in a DR location that is pretty much cold (for licensing issues).
If our production database should go down, then it would fail over to the DR site.
What is involved in doing this, what type of steps are required, do you NEED a DBA to manage this, or can a sysadmin (such as myself) take care of it? Also, is it worth having DoubleTake to do this job, and does it do a better or worse job, are there limitations, etc.
Thank you for any replies you can give, and please keep in mind that I'm far from a DBA .
hi all,
i have a requirement that web service running in one system and sql server 2005 database running in another systems which is not working currently.
suppose i create end point in the system where sql server 2005 database is there,then its working fine.
Actually for creating end point we should have windows server 2003 or SP2.Configuration part i dont have any hindrance.
Can any one tell how to run webservice in one system with sql server 2005 in another system.
Thanks
venkat
I am trying to build a query which will be used in an automated report to calculate failure rates of systems based on cases opened through support. Here is where I am stuck. Some systems may have multiple cases opened within the same span of another cases however we would consider this one failure:
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000
System ACase22013-07-12 16:27:50.0002013-07-12 16:29:12.000
System ACase32013-07-12 17:30:32.0002013-07-12 17:40:11.000
System ACase42013-07-12 19:00:24.0002013-07-12 19:04:14.000
System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
Lets say System A generated those 5 cases however Case 2,3 and 4 all happened within the same period as Case 1 so those 4 cases should count as one failure so my end result should be
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000
System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
And that system should show me 2 failures. I was thinking of using a temp table but not sure if that is possible as I am stumped on how to compare the dates to be able to validate if they fall within the range of an older case and whether or not to include them into the new Temp Table.
Hi All,
I am working on a server movement work.The application is moving from sql server 2000/windows 2000 to sql server2005/windows 2003.I have a DTS package including some stored procedures which operates on the sql server.
I am using xp_cmdshell for copying and deleting excel files.And I am using microsoft.jet.4.0 to fill the excel file with data from a temp table.
The dts goes fine but it is not copying the excel template from one location to other.Again while deleting the 2 months old file i got an error saying cannot delete the files.
It was running correctly in sqlserver 2000.I have enabled the xp_cmdshell feature in the configuration.
Please help me and suggest me.
Thanks
hi guys,
i am having a truble in accesing the server 2005 express edition from my client systems in server 2003 domain network. i get server not accessible. whereas my domain is working perfectly. i really tried alot and i have enable tcpip and named pipes and i am still getting errors while accessing. i have also created user reights for the domain users to access sql server. still i couldn't able to access it.
please guide me to over come this issue. I'm dying.My project is similar to SAP concept project and i am doing it in a production industry.so each department as to access the data from the server to update their daily production and activity.
thnks in advance.
Viswa
Hi,
How can I run operating system command like "DIR" in a stored procedure?
Thanx
Hi SQL TEAM
Can someone please assist, we have a Database roughly 10GB in size,
For the past 2 days now we get the following errors.
////////
FCB::Open failed: Could not open file D:MSSQL.1MSSQLDataHelpdesk.mdf for file number 1. OS error: 32(error not found).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
////////
FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'D:MSSQL.1MSSQLDataHelpdesk.mdf'. Diagnose and correct the operating system error, and retry the operation.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
////////
Can someone tell me what is causing this error?
What are the advantages and disadvantages of installing 32-bit SQL server 2005 editions on 64-bit operating system?
1) Does odbc drivers have any problems
2) Memory issues
Have anyone been in this situation. Expert advice will be appreciated.
I have code that instantiates a sqlserver object and starts a job. Ihave used this on numerous XP workstations successfully, when I triedto move this to a Windows 2000 Application Server attached to a SmallBusiness Windows 2003 network and run the code, I am receiving theerror:Automation Error. The Operating System Cannot Run %1.(Error Number -2147024714)The following is a code snippet:*********Dim app As New SQLDMO.ApplicationDim oSQLServer As New SQLDMO.SQLServerDim oJob As SQLDMO.JoboSQLServer.LoginTimeout = 30 ' ERROR OCCURS HEREoSQLServer.LoginSecure = True**********The code fails when setting the LoginTimout parameter. The SQLDMO.dllhas been registered successfully on the server.Any ideas whey the behavior of this code is different on my applicationserver vs the client workstations on the network?ThanksMike G
View 2 Replies View RelatedAre there any restrictions in the restored database after database mirroring?
I mean, Is it full mirror of my primary database?
What I want to do:
If my machine A(with primary database) will down I will redirect my clients to a real-time copied database - mirror server. I don't want to create cluster, but I want to use database mirroring function in ms sql 2005.
Can I use DB Mirroring to solve my problem?
p.s. sorry for my english
We were installing SQL Express 2005 on a Vista machine. This PC has a 64 bit CPU and a 64 bit Vista operating system. I know that we need to use WOW 64 to run SQL Express 2005. My question is how do I turn on WOW64 so I can run SQL Express 2005
Vista
Thank you,
Photomultiplier
I need to interrogate the date/time stamp on a network file. Any suggestions?
View 1 Replies View RelatedHow to insert or retrieve images type data in sql server?I want to put a jpeg file in sql server.How can I accomplish that?>How to input into the table and how to retrieve that from the table
I have a table contacts.The fields are
ID int
Name Varchar
Photo Image
Can anyone help me with this?
Hi, who have ever met the following errors, share an information of what could cause it??? I can't find any info that could help me find the reason. My DB went to SUSPECT mode and in the log file I got:
ForwardLogBlockReadAheadAsync: Operating system error 997(Overlapped I/O operation is in progress.) encountered.
Operating system error 997(Overlapped I/O operation is in progress.) on device 'd:MSSQLdataiservice_Log2.ldf' during ForwardLogBlockReadAheadAsync.
Error: 3414, Severity: 21, State: 1
Error: 9001, Severity: 21, State: 1
Unexpected error while commiting a ShrinkFile operation
/*************************/
What is weird the 997 error occured twice during last night and the DB went into suspect mode only after the sencond one.
The database restored but it's a second time for the last month just getting a bit annoying.
Thanks for any help
Dim