URGENT! Rows Disappearing

Jul 4, 2006

Hello together,

strange things going on:

1. The table statistic shows for example 67 rows in a table, select count(*) only returns 63 rows.
2. Table statistic shows 50 rows, select count(*) returns 55 rows.

In both cases if you do an insert the newly inserted row sometimes can be retrieved by a select statement sometimes not. Row statistics sometimes is updated correctly, sometimes not.

Integrity check for these databases says everything is fine. DBCC CHECKDB, DBREINDEX, UPDATESTATISTICS, ... does not help or says everything is fine.

Already opened a case at HP's Microsoft support and they involved Microsoft itself but all are a little bit clueless at the moment.

As this is our main DB cluster and several databases are affected we had to stop most of our applications since last Thursday and now we are getting a little bit in trouble so any hint is very welcome.

Thanks in advance

PS: Restore is not an option - as all tools say everything is fine all of our backups from the last months include the error. Don't ask why nobody recognized the lost data earlier, seems they were stored but not required for some time.

View 4 Replies

Rows Disappearing In View

Jul 15, 2007

I have two tables that have a column called "subscriberid". I imported rows into the main table, and it's sister table.

There are 90,000 rows in the main table and 94,021 in the other table.

It appears that roughly 4,000 rows have disappeared in the main table, but not in the other table, and I don't understand why?

I'm new to SQL Server 2005 Express and I'd appreciate any help you can give me.

Thanks,

Bill

View 4 Replies View Related

Urgent - Duplicate Rows...

Apr 6, 2001

hi,

I want to delete duplicate rows in a table, can any one write a sql for doing that...

please help me in this...

urs
Vj

View 2 Replies View Related

Urgent - Deleting Duplicate Rows

Apr 5, 2001

Hi folks,

I need to delete the duplicate rows from a table. How to do that in SQL server 7.0 ? If possible write an example, so that it will be much useful for me..

Thanks for ur help..

rgds,
vJ

View 1 Replies View Related

Urgent Help!-how To Format After Getting Rows? For Newline

Oct 8, 2004

while(@@FETCH_STATUS=0)
begin
print 'inside while'

set @BodyContents = @BodyContents+@gotclientName+@gotproductName
set @Body= @Body + @BodyContents + ','

fetch next from resultcursor into @gotclientName,@gotproductName

print 'going outside of while'
end --while end

Client Name Product Name
aaa test1
bbb test4

how to format row like above. currently i am getting
aaa,test1,bbb,test4

View 1 Replies View Related

ELIMINATING DUPLICATE ROWS URGENT

Jul 20, 2007

Hi i have a table value which contains
value
-----
a
a
a
b
b
b
c
c
c

Now i need to have the results as

a 1

b 1

c 1

I tried using distinct.But OLEDB returns error that invalid syntax.It doesn't support distinct keyword.Actually i read these table from a file thru OLEDB.Not from a database.Any idea ? Thanks in Advance

View 8 Replies View Related

Convert Columns To Rows - Urgent

Jan 13, 2008

Hi,
I have a table with 5 columns, from that I need only 3 columns , but the columns should be rows in the output
Ex Table 1
col1 col2 col3

Now I want col1 as one row n col2 as 2nd row and col3 as 3rd row

What query should I write to get this?

Will union work

Thank You

View 1 Replies View Related

How To Group 2 Table Rows (urgent)

Jun 13, 2007

Hi

How do i group 2 table rows?

I have a report with a table and it has 58 rows, in some of the rows i am displaying the data like this

Roth contribution (Heading)

data for the roth contribution.

So depending on the options checked sometimes the heading Roth contribution is at the end of the page and the data is the next page. so how can i group 2 table rows together.

I have tried clicking on the 2 rows and grouping it, but nothing seems to appear in the report..

any help will be appreciated.

Regards,

Karen

View 3 Replies View Related

How Can I Split The Rows In 2 Textboxes - Urgent

Feb 20, 2007

Hi,

I have a report and its been populating from a sproc. and i have 2 text boxes called both of them are poplulated by Fields!Investment Names, but right i can display the data left to right but i want to display the Data starting top to bottom and then towards the right.

I tried grouping the data in this way for one text box = CountRows()/2 > 10 . and this shows all the records one below the other, so is there a way that i can display half the records in one text box and the other half in the other text box.

I am going kinda nuts over this. Can someone please help me.

Regards

Karen

View 15 Replies View Related

Missing 1 Million Rows During BCP PROCESS!! Urgent Help

Mar 12, 1999

Hi, I used the /e in my bcp code. yet did not get all the rows from the main frame into the sql talbes... here is the case I have 11 million rows in an ftp server I use this code to bcp into sql server can anyonecheck if this code is good for the process, I am missing one million row in the bcp process and do not know why??? I put the /e to see if there is any error but could not see any error file in my hard drive?
Please check it out and let me know

regards
Ali

Exec master..xp_cmdshell "bcp dbname..tablename in c:ftprootNbtorder.txt /fd:ftprootformatfileablename.fmt /Servername /Usa /Password /b250000 /a8000 /eerrfileORD"

View 2 Replies View Related

(URGENT) Getting The Number Of Rows From List Control

Oct 16, 2007

Ok here is what I have

Department:A

Line 1 Name: George
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10
125254 Test 10

Total: 80% 40

Name: Mik
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10

Total: 70% 30

Name: Jonathan
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10

Total: 70% 30
Line 10

Line 15 Total for this division: 33% ((100 )/3) 100

Department:B
��..
Here is what I did I have a list control that is grouped by department. this will get me the info from Line 1 to Line 10 then this list control is actually under another list control that is grouped by department to get the info from Line 15. I used this example for simplicity and what I am doing is fairly similar to this situation. My problem is, I need to find away to know how many totals I have to count the total for the entire department. In other words : from the example above how can I know I have to divide by 3 to get 33%. I can get the 100 without any problem but I can��t tell what number I need to divided by. I tried to use Count(Name.Field) I was hoping this will give me 3 which indicates the divided number. But I was getting 7 for some reason.
How can I get the number of times the list control was implemented for one department which is in this case 3?

thanks

View 2 Replies View Related

Urgent Help: Regarding Assigning Mulitple Rows Of A Given Column To Variable

Aug 13, 2007

How to assign multiple values to emp1 variable separated by comma
Ex: If ajay karthik vijay are employee names in emp table
then emp1= ajay,karthik, vijay
set emp1= (select employeename from emp) returns error
error: subquery returns morethan one value

View 4 Replies View Related

URGENT Plz ! Pivot Rows To Columns In SQL Server 2000

May 16, 2007

Hi,

I have the following data in a table called "Products" :

Product Qty LHinging RHinging
-------- ----- -------- --------
Panel_1 1 R
Panel_1 1 L
Panel_1 1 R
Panel_1 1 R
Panel_2 1
Panel_2 1 L

I need to group this data like this :

Product Qty LHinging RHinging
-------- ----- -------- --------
Panel_1 3 L R
Panel_2 1
Panel_2 1 L

How can I do that ???

Thanks !

View 3 Replies View Related

Most Recent 3 Episodes Per Blog (was [URGENT] Pulling Certain Rows From Table)

Mar 29, 2006

Code:

create table Channels (ChannelID int(5), other varchar(255));

create table Blogs (BlogID int(5), BlogXMLPath varchar(255));

create table BlogAssociations (BlogID int(5), ShowID int(5), ChannelID int (5));

create table Episodes (EpisodeID int(6), BlogID int(5), ShowID int(5), ChannelID int(5), Other varchar(30));

insert into Channels values (1, 'Channel 1');
insert into Channels values (2, 'Channel 2');
insert into Channels values (3, 'Channel 3');
insert into Channels values (4, 'Channel 4');

insert into Blogs values ('1', 'blah');
insert into Blogs values ('3', 'blah');
insert into Blogs values ('4', 'blah');
insert into Blogs values ('12', 'blah');
insert into Blogs values ('34', 'blah');
insert into Blogs values ('35', 'blah');
insert into Blogs values ('67', 'blah');

insert into Episodes values (1, 3, '', '', 'Episode 1, blog 3');
insert into Episodes values (2, 3, '', '', 'Episode 2, blog 3');
insert into Episodes values (3, 3, '', '', 'Episode 3, blog 3');
insert into Episodes values (4, 3, '', '', 'Episode 4, blog 3');
insert into Episodes values (5, 1, '', '', 'Episode 5, blog 1');
insert into Episodes values (6, 1, '', '', 'Episode 6, blog 1');
insert into Episodes values (7, 1, '', '', 'Episode 7, blog 1');
insert into Episodes values (8, 4, '', '', 'Episode 8, blog 4');
insert into Episodes values (9, 4, '', '', 'Episode 9, blog 4');
insert into Episodes values (10, 4, '', '', 'Episode 10, blog 4');
insert into Episodes values (11, 4, '', '', 'Episode 11, blog 4');
insert into Episodes values (12, 4, '', '', 'Episode 12, blog 4');
insert into Episodes values (13, 12, '', '', 'Episode 13, blog 12');
insert into Episodes values (14, 12, '', '', 'Episode 14, blog 12');
insert into Episodes values (15, 12, '', '', 'Episode 15, blog 12');
insert into Episodes values (16, 12, '', '', 'Episode 16, blog 12');
insert into Episodes values (17, 12, '', '', 'Episode 17, blog 12');
insert into Episodes values (18, 34, '', '', 'Episode 18, blog 34');
insert into Episodes values (19, 34, '', '', 'Episode 19, blog 34');
insert into Episodes values (20, 34, '', '', 'Episode 20, blog 34');
insert into Episodes values (21, 34, '', '', 'Episode 21, blog 34');
insert into Episodes values (22, 35, '', '', 'Episode 22, blog 35');
insert into Episodes values (23, 35, '', '', 'Episode 23, blog 35');
insert into Episodes values (24, 35, '', '', 'Episode 24, blog 35');
insert into Episodes values (25, 35, '', '', 'Episode 25, blog 35');
insert into Episodes values (26, 67, '', '', 'Episode 26, blog 67');
insert into Episodes values (27, 67, '', '', 'Episode 27, blog 67');
insert into Episodes values (28, 67, '', '', 'Episode 28, blog 67');
insert into Episodes values (29, 67, '', '', 'Episode 29, blog 67');
insert into Episodes values (30, 67, '', '', 'Episode 30, blog 67');

insert into BlogAssociations values (3,'',1);
insert into BlogAssociations values (12,'',1);

There is my above sql script, i'm currently using mysql at home to test things but will convert to work in mssql.
I need to get associated BlogID for Certain ChannelID from the BlogAssociations table.
Then using those BlogID's that it finds for let just say ChannelID "1" list off the 3 most recent EpisodeID's from the Episodes Table per each BlogID.
So if ChannelID "1" has four BlogID's associated with it then in the Episodes table list off the recent 3 EpisodeIDs for BlogID "3", then the 3 most recent EpisodeIDs for BlogID "5" and so on and so on.

I have this which kind of does what I want:

Code:

select
e.BlogID, e.EpisodeID, e.other
FROM
episodes e, BlogAssociations ba
WHERE
e.BlogID = ba.BlogID and ba.ChannelID = '1'
ORDER BY
e.EpisodeID DESC;

It returns:

Code:

+--------+-----------+---------------------+
| BlogID | EpisodeID | other |
+--------+-----------+---------------------+
| 12 | 17 | Episode 17, blog 12 |
| 12 | 16 | Episode 16, blog 12 |
| 12 | 15 | Episode 15, blog 12 |
| 12 | 14 | Episode 14, blog 12 |
| 12 | 13 | Episode 13, blog 12 |
| 3 | 4 | Episode 4, blog 3 |
| 3 | 3 | Episode 3, blog 3 |
| 3 | 2 | Episode 2, blog 3 |
| 3 | 1 | Episode 1, blog 3 |
+--------+-----------+---------------------+

But as you can see it lists off 5 of the Episodes for BlogID "12", I only want the most recent 3 as previously stated. It also lists off more than 3 Episodes for BlogID "3". How in the world do I go about doing this?
I'm making this a stored procedure so I can't use php otherwise I wouldn't even be posting

Thanks so much!

View 6 Replies View Related

URGENT Merge Replication: Missing Rows At Publisher And Subscriber: No Conflicts

Jun 9, 2006

We have SQL Server 2000 with merge replication at a Publisher and subscriber.

We have some records getting deleted at Publisher and Subscriber and no conflicts are logged.

We have tried the compensate_for_errors setting and this has had no effect.

This is causing serious data corruption and has now become an URGENT issue. Out tech team are almost out of ideas.

Has anyone experienced this or have any ideas as to what to check next?

View 3 Replies View Related

DTS And Disappearing Index

Jan 12, 2001

I have a similar problem to the one indicated by David Van Diest. I could not find any answers to his query.
Could anyone help!

Thanks

Mon, 8 Feb 1999 16:24:55 -0600
From: David Van Diest
[sql7] DTS and disappearing indexes

I have noticed that if I use the Microsoft ODBC driver for SQL Server when I
transfer data from one database to another my indexes disappear. If I pick
other odbc source and then fill in the data source my indexs do not go away.

Anyone else see this behavior? I don`t think it should be working this way.

Thanks,

Dave

View 1 Replies View Related

SQL Commands Disappearing!?!?!?!

Nov 7, 2001

I am experiencing a situation where I issue a lengthy SQL command to MS SQL Server 7.0 through MTS and it "disappears" - no errors or recordsets are returned. The command is "SELECT * FROM CUSTOMERS WHERE LASTNAME LIKE 'SMITH%'". When I issue this command from SQL Query Analyzer it takes 27 seconds to return 87 rows. When I issue this exact same command through MTS it does not return at all.

I've used the SQL Profiler to analyze the requests. It shows the commands from MTS starting but they never stop (or at least the profiler never reports them as stopping). The same commands coming from Query Analyzer are reported as starting and stopping without fail.

Here's a twist: I can issue less demanding commands (ie, one that doesn't take so long to process) through MTS and they come back fine. For example, when a user logs into my application, I use an SQL statement to verify the user name and password and status the user as logged in. This is routed through MTS and it comes back fine in less than a second. Same application, same PC, same MTS and SQL server, same SQL database. The only difference is that the CUSTOMERS table has over 800,000 records and the USERS table has only 5 records.

PLEASE HELP!

View 1 Replies View Related

HELP!!!! Data Disappearing

Oct 25, 2001

HELP!!!

I have three servers replicating. One is a publisher and two subscribers. If I put data in the publisher, some of it will disappear after replicating. When data is entered in one of the subscribers, the same thing happens.

Anyone have any ideas??? I am doing a merge replication and all servers are running SQL Server 2000.

Kameron

View 3 Replies View Related

Databases Disappearing!!

Jun 16, 2004

Ok, I'm new here and I REALLY need some help here.

In my organisation, we have a Server with MSSQL 7 running with some databases. Some of the databases are published for replication.

Now, since Monday, we've been losing databases that are in use! :confused:

The files are disappearing and being marked as suspect in SQL. The physical file has been deleted from the machine even when SQL is running and on some databases are replicating. In one instance, we were making permission changes on a user and it just said that the file is no longer there. And when we checked, the msdb system database had disappeared as well. So now the server is showing up as having no databases. We were able to recover some of them through backups and a handy recovery tool. But now we are helpless as to WHY this is happening. We suspect Virus but we have Norton CorporateEdition running and Liveupdate updating every day.

I've searched the web for any one that had the same problem, but nothing came up. Only some stuff saying that space was an issue, but not on a drive with 21GB remaining and the biggest database is 3GB...

Any help, insight or resolution will be greatly appreciated.

View 1 Replies View Related

Disappearing Records

Jan 17, 2007

I am running an Access 2000 MDB against a SQL 7 back end, using ODBC linkedtables over a LAN and a WAN. The system has been operational for years withrelatively few problems.Recently, WAN users have been reporting several hundred records disappearingat a time. The records are all sequential, and they're in a table thatcontains about 60,000 records. This all started last week at about the sametime (not sure if before or after) that the WAN went down for a couple ofhours for an unknown reason. Since then, every once in a while, a WAN userwill report that several hundred records in a block are just "missing."Then, an hour or two later, they reappear.Any ideas as to what's going on or what can be done to rectify this?Thanks!Neil

View 8 Replies View Related

Disappearing Data

Dec 18, 2006

I am not sure where to put this but correct me if i'm in the wrong forum.

I've been working on this database for some time now. It's an Access 2003 database with a SQL backend. Everything was going well until one of the users noticed her data was disappearing after she send an email. The database has a memo field that gets pasted in the body of an email when it is created. Sometimes, when the user sends an email and goes back into the record, the memo field is blank. I know the field has data in it at the time of the email because it will give you an error if the field is null and you won't be able to send it. And, it goes into a history table with everything the user does with each record. I've checked this history table and it shows that all records in question, an email was sent. I have no idea why the data would disappear in this field. It does not happen all the time. I've performed the same steps and I can't duplicate the problem. There's no code associated with the memo field that deletes it after sending the email. Can anyone think of anything that would cause this?

View 4 Replies View Related

Disappearing Data In SQL Server

Apr 5, 2005

The problem i am facing here is disappearing data in sql server 2000. I
not sure what is the problem, but it is getting worse and worse. Anyone
can point me to a right direction whether this is a security
vulnerability which i need to download the patch, or is it my computer
is infected with virus., or is it a bug in sql server?

I remember having read somewhere about this problem also, but not sure
in which website already. Anyone, please help!!! Because we are going
to deploy to production server soon, and this is a problem that need to
be solve ASAP..

Thanks in advance...

View 13 Replies View Related

TempDB Users Disappearing

Nov 7, 2001

I am supporting a system that needs to allow users to have access to Temp DB. I set these users up using the GUI, but whenever the server is restarted, these users are wiped out. Is there anyway to keep these users when the server is rebooted?

Thanks for any help.

View 2 Replies View Related

Disappearing Stored Procedure

Oct 15, 1998

A user created stored procedure is dropped from system tables where no known drop procedure command is executed.

From ISQL the procedure runs properly after creation but, at sometime during execution the procudure dropped from the system tables.

Any help would be appreciated.

Environment:
SQL Server 6.5 sp4, windows NT 4 sp3, db-library, visual C++

View 1 Replies View Related

Fields In My Tables Are Disappearing!

Feb 24, 2006

I am using a hosted MSSQL 2000 database that powers the backend of mywebsite. Website visitors interact with it via ASP pages I havedeveloped. I also have an internal FileMaker 7 database thatperiodically synchs with it via Filemaker's ODBC functionality.Several times now, I have come in one day to discover that my ASP pagesdon't work. When I look into it, one of my MSSQL tables will be missinga few fields. There is nothing in any of my code that sends an ALTERTABLE command or any other command that affects table structure. Thesedeletions of fields is totally random.The most recent example was with a table called FreeTeacherSubs. I justdiscovered today that three fields went missing:HowDidYouHearAboutYES TEXTFollowUpCallOrEmail TEXTHowMaterialsFit TEXTSuffice to say I am baffled! Has anyone ever experienced fieldsdisappearing from their tables?Kevin

View 2 Replies View Related

Records Appearing And Then Disappearing

Jul 20, 2005

Hi,We have a SQL server db backend for our ERP system. I have written aCrystal Report to extract data from one particular table calleditemspecbomw (c.30000 records) which contains amongst other thingsBill of Materials costings. When I run the report I know that somerows are missing as when I look at values through the ERP systemitself, the values are different.What I have found is that when I run the equivalent ERP system report,the Crystal Report I have written shows extra rows. SQL Query Analyserbehaves exactly the same as the report I have written even when usinga "select * from". I have tested opening up a bigger tables (c. 700000records) which appears without a problem. If anyone knows why thismystery is happening, I woould be grateful for your help.Many thanks,Tony.

View 2 Replies View Related

Disappearing Data -- SQL 2000

Jul 20, 2005

I'm using an Access front end to a SQL 2000 database.I have a form from which I enter data. Everything seems fine, I check thetables and my records are being inserted.When I close Access and reopen it, data from three of my tables is gone.SQL Profiler turns up nothing. If I try to access a problem table fromEnterprise manager while Access is open I get an ODBC error. If I try toaccess it after I close Access, the records are gone.Where do I start looking to figure out where the problem is? I'm at a lost.TIA for help.--Jake

View 4 Replies View Related

Disappearing Precedence Constraints

Jan 25, 2007

Has anyone seen precedence constraints disappear in a package after closing and opening again? In this case, it's not package-wide. Only constraints inside one Foreach Loop container disappeared. Any idea what causes this to happen?

p.s: Yes, I did Save All. Most of these contraints were saved in the package for more than a week anyway.

View 14 Replies View Related

Stored Procedure Disappearing Act

Apr 11, 2008

I created a simple stored procedure shown below. It works wonderfully. The only problem is that it likes to disappear on me. I am accessing it through a VB.Net program. The system will work fine throughout the day and suddenly it will be gone. I can exit Sql Server Management Studio and come back in and it will still be there so that is not causing it. The database stays connected all the time.

Any suggestions?

Code Snippet
IF EXISTS(
SELECT *
FROM sys.procedures
WHERE name = N'VerifyPart'
)
DROP procedure VerifyPart;
--create a procedure for the part code tab verify part function
go
create procedure VerifyPart
(
@PartNumber varchar(50) = null,
@LastUpdated varchar(30) = null
)
as
--Update Part Number
update Parts
set LastUpdated = @LastUpdated
where PartNumber = @PartNumber

View 8 Replies View Related

Maintenance Plans Are Disappearing...

May 25, 2007

I'm not even sure where to post this, but has anyone had a problem with maintenance plans disappearing?

I mean the SSIS package and the job just disappearing....?

I have four servers. Two dev and two prod. I created a pretty simple maintenance plan to backup databases. There are four tasks in the plan. One for each of four databases. Backing each up to a separate file, all in the same folder.

The plan gets associated with a job that has it run daily, every six hours, with no end date.

The plan runs just fine. Then this morning, on one of the servers, the plan and its job are just gone.

This is the second time this has happened. And it's not the same server that it happened on the first time.

Why would a maintenance plan just disappear?

Anyone?

J

View 1 Replies View Related

Data Disappearing During Run Time

Jan 5, 2007

When I enter data into a SQL database and save it, the data that I have just added disapears, but when I close the applicaiton and re-open it, it's still there - is there any reason for this and any way to get it to stay?

Any ideas?

View 7 Replies View Related

ODBC Connections Disappearing

Mar 12, 2008

I have set up 80 connections to the SQL Server - mostly through code. People have been successfully using the database, but then when they come in to use their computer and the database the next day, their connection is completely gone! What is that all about? So far this has happened to 2 or 3 different users. Any idea why?
Thanks.

View 1 Replies View Related

SQL Server Database Disappearing!

Jun 26, 2007

Hi,

We have a number of databases on our SQL Server 2005. One of them, AddressPoint, keeps disappearing completely every few days. I should qualify that - the database name still exists and is visible in Management Studio, but there is no + icon to expand to see the object types.

I can manually restore the database. But we are unable to identify any process that might be deleting the database.

So where do I even start in trying to track down the process that is deleting it? I have not been able to pinpoint a specific time when the deletion might have occurred, as I am not using the database regularly, and neither are our users, yet. The latest deletion definitely occurred within the last 24 hours, but that's as specific as I can be.

Thanks,

Keith.

View 2 Replies View Related