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 bkrike 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: ccuster
  • Content: Threads
  • Order by date
  1. ccuster

    Using the full name server.database.owner.table...

    I have been using linked servers for over a year on this particular stored procedure that generates a temporary table from a select as such: select * into #temp from server.database.owner.table I get an error message: Server: Msg 7353, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB'...
  2. ccuster

    Dfs and W2K

    I loaded a Dfs Root and added shares in this root. I gave both Share rights Full Control to everyone, and NTFS rights of Full Control to everyone in both the root folder I made for the Dfs and for the subfolders. I can see the folders by all PC's 98 and 2000 pro alike, but I cannot write or...
  3. ccuster

    Trying to speed up very large updates to tables

    I have two tables one 17 million records, and the other 10 million records. I am updating fields in the 17 million record db. no matter what kinds of locks or how I break the data down I can only get around 200,000 updates an hour. I have created indexes on the lookup fields. Does anyone...

Part and Inventory Search

Back
Top