Hi all,
I have some problem :
I use sql server 2000,I have about 20000 records !
I delete all data unfortunately !
So , i need to restore all .
Are there way to do this ? I don't setup automatic backup !
My data is very important !
Thank you very much.
Hi - quick question.
I wanted to upgrade pre-release version of SQL Express to the latest version, and wanted to make sure that none of the database information would be lost. The thing that concerns me is that it states to uninstall previous versions of SQL Server 2005 Express before installing the latest version. I threw the database tables into a backup directory, and I think this should be fine, but I want to be sure. Let me know. Thanks!
I am running into an issue while executing a sproc from Excel VBA. Everything connects fine, and I am passing a parameter, however, after a few seconds, it seems like the connection receives a "completed" command and continues down it's code, but the sproc is still executing. The result is that I never receive the record set from the sproc.Here is the code snippet from VBA:
' Create Recordset objects.
Dim cmd As New ADODB.Command
Dim conn As ADODB.Connection
Dim prm As ADODB.Parameter
Dim sConnString As String
Dim rs As ADODB.Recordset
Dim strQry As String
Dim rowCount As Long
[code]....
And here is the sproc that is being called. the first thing it performs after the "IF" block (there are multiple steps that would consecutively be called after this, but all of the data hinges on this first step working) is a TRUNCATE statement. After running a SQL profiler while executing the VBA code, I consistently see an "account log out" entry; almost as if the connection from the Excel workbook is sent a disconnect instruction. The sproc continues to run and perform the rest of the script in the "IF" block, but the returned recordset is never returned back to Excel.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET NOCOUNT ON
GO
[code]....
Dear all,
I'm using SQL Server 2005 as my backend application. I had strange experience on it, sometime some of my records suddenly disappear without any deletion action.I've check the log files and I've already set a trigger on deletion to copy the deleted record to a history table, but I found nothing. Are there anybody that have same experience like me ?
We are running SQL 7 with a front end that links to the tables through ODBC.In our main table, the user has no way to delete a record through theinterface, though it is possible to delete it by opening the ODBC link.Users would have no reason to delete a record, but one of our records turnedup missing.Now, it's possible that a user may have accidentally deleted the record.But, since users don't have any reason to delete records, and since theydon't access the ODBC links, it seems unlikely (though possible).I was wondering if anyone had every heard of SQL Server ever "losing" arecord that had previously been saved. I checked the nightly backup from thenight after it was added, and the record was there. So either a user deletedit, or somehow it got lost in SQL Server. I have no code that deletesrecords in this table in any way, shape or form, so it couldn't have beenmalfunctioning code.So, while I have a hard time believing that SQL Server would just "lose" arecord, I also know that anything's possible, so I thought I'd ask if anyonehad ever heard of such a thing.Thanks!Neil
View 8 Replies View RelatedHi,
i've a store procedure has a strange behavior, As soon as created has a good performance , but after some times (indeterminated) it takes more time to be execute.... (up to 70s!!!)
The thing that i've not understood was if i take the query inside to the store i execute it separtely I get result immediately... :eek:
Dropping and re-creating procedure,it become newly fast... I've just scheduled a maintenance plan with index optimization and integrity check, but this seems doesn't work ...
Any idea?
Thanks .
I've got a project with 12 packages. One of them runnning and at the same time when I try to alter another one or even add a new task I see that all the tasks on toolbox are disabled.
Why?
I would like to hear a good reason for this behaviour, afaik I don't get the point...
I have a database that has a table with tons of data in it and it is getting close to the 999 days before it starts deleting the oldest records. Is there a way to allow the table to keep all of the information? I don't think there is, so here is my next question. Is there a way that I can move the entire table into another database to save all the information and start over with the 999 days? My main goal here is to not lose ANY information from any table from the database.
Also, I was thinking that when an entry is added into the main table, if it can also be added into the other table where I move the old data? I think a trigger can be used here, but I'm not sure how to do one in 2005. Thank you very much in advance for your help!!!
I created a linked report and I see that the original height and width settings which were set for landscape have changed into portrait:
View 7 Replies View RelatedI used the URL approach to call the reporting service. In the ASP page, I use javascript to open a new window to view the report. But when I close the new window and work on the original window. It seems that the DB connection to the SQL server is not working.
We run std 2008 r2. On my col heading text boxes and data text boxes i'm purposely picking only borders above and left in an attempt to get rid of what looks like a double border between text boxes.
The only places I see what appears to be a single thickness is the left of the 1st column hdg and data, and above any col hdg text box I set this way.
Also, when I pick .5 instead of 1 pt thickness, ssrs always puts it back to 1 pt.
How can I get the appearance of single thickness borders instead double?
We recently had a problem were a webserver lost connection to sql 2000 database after we put in a new router. When we failed back to old router it was able to connect to database again. It is using a non standard port 2125 to connect to sql database. Why would a new router cause connection problems to a database.
View 4 Replies View RelatedThe programmers encountered a problem as following:
Different programmers use the same account(Admin) to login to the same database to create table from different workstation. The tables were created through the same steps which is highlighted the Table folder -->New table then go through the wizard. The table were created successfully but the ownership were different. One with Admin as owner, the other has dbo as owner. Even Admin is the owner of the database but this created a problem for them that they need to specify differently for the tables depend on who created them.
what is the cause of this, sevice pack 3 is installed on the machine.
Its Sql Server 7.0
Thanks in advance.
RSVP
hi, i have got 10 dts packages i want to create a job and put them all into that job. I could not execute the dts create in tsql. Can any one say as how to execute that in the job.
View 1 Replies View RelatedBabu.G here,
Working as MS-SQL DBA IN MNC..I HAVE A DOUBT SO PLEASE
CLARIFY THAT..WHERE SHOULD I DECLARE GLOBAL VARIABLES..FOR EXAMPLE @@ROWCOUNT AND MANY..
LIKE THAT I NEED TO DO..
IN CASE IF I AM DECLARING ONE @@GLOBAL VARIABLE IN PROC AND STORING SOME VALUES IN THAT
IF CALLED THAT VARIABLE INTO SOMEOTHER PROC ..IT IS GIVING ERROR..
PLEASE TELL ME..
BABU.G
Thanks in advance
I have several reports that are set to landscape but then lose this layout when a linked report is created from the original report. I found the link below describing Brian Welcker's workaround and my question is where do you place the vb.net code he provided?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1
This is sort of a DR issue since it involves reboots and power failures.
We have MSSQL 2005 SP1 and unpatched systems, but in particular we have this problem still with the SP1 server (in addition to the unpatched systems). Running on Win 2k3.
It seems that upon reboot, our stored SSIS jobs lose their pemissions and/or ownership for execution. It doesn't happen at every reboot or power failure, but seemingly more than half the time.
Here is the error reported:
The job failed. The owner () of job Job_1 does not have server access.
But checking the properties of the job and it shows an valid owner in the Owner field. I believe we are using Active Directory for authentication and the user listed is valid in that respect.
We have "fixed" this problem before by removing the job completely and re-installing it, with the same owner. No issues until the next system outage.
Has anyone else seen this before? Is there a fix or is this some kind of bug?
hey people...
im currently using sql server 2000... is there a datatype or a way so
that you dont have to limit the length that a user can enter into a
textbox (for example) that will be saved in a column in a table in sql
server?
thanks!
I'm in deep problem...please help...
There was someone who got into the system and modified the database properties to DBO use only..what we want to do is to track such changes with when they did.
As like what happened earlier..some told me about turning the audit level to all will help but it does not give the information about who has did and what did they do...
Is there a way in which we can find out what happened and who did this what command they have executed...
Thanks..i appreciate your help..
Mitchell
Hello I have the following query set up and I am getting the errors of: Any help on this would be appreciated.
Thanks
Stuck !
Server: Msg 107, Level 16, State 3, Line 2
The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 2
The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 10
The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 10
The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
Select REQUEST,BUSINESS_REQ_ID,TEST_CASE_SOURCE as SOURCE from TEAM3B_PULL_TOTAL_TST
if TEAM3B_PULL_TOTAL_TST.REQUEST<>BUS_REQ_DESCRIPTION_TST.REQUEST
begin
Insert into TEST_REPORT.dbo.BUS_REQ_DESCRIPTION_TST(request,bu siness_req_id,source)
select request,business_req_id,test_case_source as source
from TEAM3B_PULL_TOTAL_TST
end
Else
begin
if TEAM3B_PULL_TOTAL_TST.REQUEST=BUS_REQ_DESCRIPTION_ TST.REQUEST
begin
Insert into TEST_REPORT.dbo.RDD_UPDATE_TST(request,business_re q_id,test_case_id,test_case_descr)
select request,business_req_id,test_case_id,test_case_des cr from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST
order by TEAM3B_PULL_TOTAL_TST.REQUEST,TEAM3B_PULL_TOTAL_TS T.BUSINESS_REQ_ID,TEAM3B_PULL_TOTAL_TST.TEST_CASE_ ID
end
end
Hello,
When I try to run the following query:
if (select REQUEST from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST) Not In(select REQUEST from TEST_REPORT.dbo.REQUEST_BUS_REQ_TST)
begin
Insert into TEST_REPORT.dbo.REQUEST_BUS_REQ_TST (b.request,b.business_req_id,b.bus_test,b.test_cas e_id,b.test_case_source,b.test_case_descr)
select a.request,a.business_req_id,a.bus_test,a.test_case _id,a.test_case_source,a.test_case as test_case_description
from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST AS A INNER JOIN TEST_REPORT.dbo.REQUEST_BUS_REQ_TST AS B ON A.REQUEST = B.REQUEST
Order by REQUEST,BUSINESS_REQ_ID,TEST_CASE_ID
end
I am getting the error messages of:
Ambiguous column name 'REQUEST'.
Ambiguous column name 'BUSINESS_REQ_ID'.
Ambiguous column name 'TEST_CASE_ID'.
What is wrong in the above statement?
Thank you,
I am given to install ODBC drivers in two servers and main thing is they are clustered . SO do i have to install in both servers or CLuster will configure that. Urgent help please . Thanks
View 8 Replies View RelatedI'm having a problem with the XML Source data flow component not transferring the length attributes from an XML Schema to the column attributes of the output table.
An example schema that I have is:
<?xml version='1.0' encoding='UTF-8'?><data xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'><xsd:schema> <xsd:simpleType name='NameType'> <xsd:restriction base='xsd:string'> <xsd:minLength value='0'/> <xsd:maxLength value='50'/> </xsd:restriction> </xsd:simpleType> <xsd:element name='Name' type='NameType' nillable='true'/> <xsd:simpleType name='FamilyType'> <xsd:restriction base='xsd:string'> <xsd:minLength value='0'/> <xsd:maxLength value='50'/> </xsd:restriction> </xsd:simpleType> <xsd:element name='Family' type='FamilyType' nillable='true'/> <xsd:element name='row'> <xsd:complexType> <xsd:sequence> <xsd:element ref='Name'/> <xsd:element ref='Family'/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name='data'> <xsd:complexType> <xsd:sequence> <xsd:element ref='row' maxOccurs='unbounded'/> </xsd:sequence> </xsd:complexType> </xsd:element></xsd:schema> <!-- data follows --> <row><Name>Fred</Name><Family>Jones</Family></row></data>
When I reference file in the XML Source data control, it correctly infers that there are two columns, but the length of the strings in the columns are set as 255.
This behaviour appears to be at odds with the SSIS documentation (SQL Server Integration Services/Integration Services Object and Concepts/Data Flow Elements/Integration Services Sources/XML Source), which states (highlighting mine):
When the data is extracted from the XML data file, it is converted to an Integration Services data type. The XSD or inline schema may specify the data type for elements, but if it does not, the XML Source Editor dialog box assigns the Unicode string data type (DT_WSTR) to the column in the output that contains the element, and sets the column length to 255 characters. If the schema specifies the maximum length of an element, the length of output column is set to this value. If the maximum length is greater than the length supported by the Integration Services data type to which the element is converted, then the data is truncated to the maximum length of the data type. For example, if a string has a length of 5000, it is truncated to 4000 characters because the maximum length of the DT_WSTR data type is 4000 characters; likewise, byte data is truncated to 8000 characters, the maximum length of the DT_BYTES data type. If the schema specifies no maximum length, the default length of columns with either data type is set to 255. Data truncation in the XML source is handled the same way as truncation in other data flow components. For more information, see Handling Errors in Data.
Has anyone had any luck in getting string lengths automatically extracted from an XML document? If so, where I am going wrong?
Regards,
Michael
hi,
I am recently upgraded to sql 7.0, my clients are having 6.5 and 7.0 versions means we are still having some 65 servers.
When they try to connect to new 70 server it is saying ''login failed''.
I think it is trying to connect to old sql 65 version, what i have to do to connect to sql70 for clients..
They are having both 7.0 and 6.5 servers.
Can anyone pls assist me regarding this.
Thank u very much
--Ramu
Dear friends,
After installing visual interdev, on a webserver (nt4.0 ent server),
whenever I was trying to configure the DSN on the ODBC settings, It gives
" The ODBC resource DLL (C:WINNTSYSTEM32odbcint.dll)is a different
vaersion than the ODBC setup dll(c:winntsystem32odbccp32.dll)
you need to reinstall the ODBC components to ensure proper operation." error msg.
I thought of removing all the ODBC drivers and reinstlling the odbc drivers came with NT SERVER. I don't know how to do it. If anyone knows how to do it, can you please post it. Thanks a lot.
I tried SQL mirroring in beta 1 , then it was gone, until SP1.
Now I can not setup mirror, it is fine if it is just hard to setup, but it seems it is full of bug! The mirroring has to be stable, since I am trying to mirror product db, what a diaster if something goes wrong.
I am trying two servers, both has 9.0.3042. First I tried to setup on my home machine, I VPN to my network, After I config security, I see two connection strings:
TCP://sql8.mydomain.netsql2005:5022
TCP://sql5.mydomain.netsql2005:5022
and I click start mirroring, then I got error - Alter failed due to invalid connection string. Hard to figure it out, right?
Then I tried the same thing on a server in the network, this time I get
TCP://sql8.mydomain.net:5022
TCP://sql5.mydomain.net:5022
and it doesn't show that error anymore, I am not sure why the connection should be like the latter format, but in anyway, how come SMO can not make it right?
then I get another error, SQL server doesn't exist or can not access, I search on the Internet, it seems that error could mean anything, include that the mirror db is not in restore mode.
But I did set the mirror db in restore mode and both sql5 and sql8 are under same domain, pysically close.
So what else I can check?
Any suggestion?
thanks
A collegue from me used the MySQL database before (I haven't done this before). He asked me, if it is possible to store a MD5 hash in a cell.
He telled me that MySQL has got a special function wich computes the hash value. Can someone help me?
Thanks for help
Our SSIS package suddenly stopped loading. We have 64 bit server on which we run SSIS packages. We had problem "script task failed to load" so we started to use the 32-bit version of dtexec to run the packages. Package used to run fine.
Today we upgraded our server to Sp1 and 2153 hot fix (x64) and now the package have stopped to load.
we confirmed that the issue is not as inthe KB below:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918038
We are still using the 32-bit version of DTExec(as in SQLx86). With 64 bit we get the error "script faield to load". we are going to fix the script failed to load error but, we need help to get going right now.
help would be greatly appreciated
Message:-
Executed as user: PHX\_IDSS-OPS. ... Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:13:48 AM Error: 2006-07-28 01:14:50.11 Code: 0xC0010018 Source: Description: Error loading value "<DTS:LogProvider xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="ConfigString">AdCenterExtractionLog</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">SSIS log provider for Text f" from node "DTS:LogProvider". End Error Could not load package "D:adcenterDWApplicationBINACDWExtraction.dtsx" because of error 0xC0010014. Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. Source: . The step failed.
This is related to an earlier post, but I found out that I was able to see SQL Server counters in Performance monitor before applying the patch, but the counters were not present afterwards....
do I need to edit the registry ?
Dear Friends,
I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases.
each virtual server should access a unique database on the sqlserver.
How can we configure this setup on both servers?
Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only.
Please help me on this issue?
Thank you all and Happy holidays!!!!!
Dear Friends,
I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases.
each virtual server should access a unique database on the sqlserver.
How can we configure this setup on both servers?
Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only.
Please help me on this issue?
Thank you all and Happy holidays!!!!!
I am having a problem getting into SQL 2005.
My connection string is as follows:
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(@"Provider=SqlOleDb;Data Source=Orange;Initial Catalog=Test;");
//tried with taking out comma after Test as well.
I have tried a lot of different permutations here and I cannot get this to work.
Hi, I'm configuring a maintenance plan for my SQL Server 2005. Is the order of things important here? I can't seem to find any best practices for this anywhere.
Obscurr