Can't see all the data in a field on my machine but can on another machine

Question

Can't see all the data in a field on my machine but can on another machine

lcarrethers

SSCommitted

Points: 1917
More actions
September 29, 2010 at 12:57 pm

#387896

When i run this select statement or open the table and look at the tdofilebinary column i see only 1 record on my machineanother mahcine
SELECT tdofilebinary,* FROM GpIntegrationHistoryDashboard
When i run the same statement on the server i have 7 records.
What could be the problem?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

could it be that one machine is connecting to , say, the PRODUCTION database and the other connecting to a older copy of that same DB, but hosted on a DEVELOPER server instead?

i'd say that is the most likely issue...different databases..even though they might be the same name...maybe even on different servers.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

lcarrethers SSCommitted Points: 1917 More actions · Answer 2

No the going to the same database, same table side by side and i'm not getting all the data on my machine.

I have double checked an i am pulling from the same database and same table

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

What do you mean by not all the data? Do you mean the rowcount is different or the content of fields is different when using SSMS?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

lcarrethers SSCommitted Points: 1917 More actions · Answer 4

The row count is the same but in one field there is only one record in it. It should be 6 records.

This is only happening on 2 machines, all the rest are show all 6 records

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

lcarrethers (9/29/2010)
The row count is the same but in one field there is only one record in it. It should be 6 records.
This is only happening on 2 machines, all the rest are show all 6 records

In one field there is only one record? I don't think I understand. If you are talking about the number of rows changing from one machine to another I would have to agree with Lowell that it can't be the same instance.

select @@SERVERNAME

If the results of the above are different on the 2 offending machines that is the problem.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/