Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ptpenry
  • Content: Threads
  • Order by date
  1. ptpenry

    How to create/drop indexes on linked servers ?

    I am writing a stored proc on our financial data warehouse, during which I need to repopulate a table in a system server. Both servers are SQL Server 2000. My plan for this part was to: 1. populate a local temp table 2. TRUNCATE the live system table, "CDRSOS" 3. DROP INDEX on the live system...
  2. ptpenry

    Importing from Excel returns NULL values when it shouldn't

    I need to import an Excel 97 spreadsheet into SQL 2000. Most columns import correctly. However, one column which has a combination of text, numeric entries and NULLS refuses to import the numerics - they just show as NULL. I have set up the destination table to be "Varchar(30) NULL&quot...
  3. ptpenry

    SQL Server money fields not displayed on Windows 2000 ?

    We have some Access 97 reporting databases which use pass-through queries to access some SQL Server 2000 databases. The databases have historically been accessed through Win 95 or 98. We have been upgrading some servers to Win 2000 which is when the problem started. We have come across a...
  4. ptpenry

    CR licensing - which version is most cost-effective ?

    Hi I work for a European firm with over 15 offices. Having effectively worked as separate businesses in the past, we are trying to standardise our software packages, one of which is Crystal Reports. In our various offices we have versions 6, 7, 8, 8.5 and 9 although the most used is 8. We have...

Part and Inventory Search

Back
Top