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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by puterkrazy

  1. puterkrazy

    help with spawn

    yeah, that's what i meant, that doesn't work...
  2. puterkrazy

    help - spawn

    how do you spawn a dqy file? _spawnlp(P_NOWAIT, "dqyfile.dqy", "dqyfile.dqy", NULL) gives an error -1. Thanks in advance.
  3. puterkrazy

    help with spawn

    help with spawning a dqy file? _spawnlp(P_NOWAIT, "dqyfile.dqy", "dqyfile.dqy", NULL) gives an error -1. Thanks in advance.
  4. puterkrazy

    spawn

    Can someone help with spawning a dqy file? _spawnlp(P_NOWAIT, "dqyfile.dqy", "dqyfile.dqy", NULL) gives an error -1. Thanks in advance.
  5. puterkrazy

    SQL - transferring data to another database

    Arles thank you, that was a good idea. Unfortunately the SQL code creates the create table without the server specified! Ugh! The databases are on different servers...
  6. puterkrazy

    SQL - transferring data to another database

    I am still getting the following error: Server: Msg 117, Level 15, State 1, Line 3 The object name 'server.db.dbo.' contains more than the maximum number of prefixes. The maximum is 2. help please!
  7. puterkrazy

    Create Table help

    nope, i got an incorrect sytax near '\' any other ideas?
  8. puterkrazy

    Create Table help

    I need to do this programmatically.............
  9. puterkrazy

    Create Table help

    Well I am able to create a table on a database on a linked server by using that without the server specified. The problem occurs when there is a database on each server with the same name and it uses the database on the current server instead of the linked. So it is possible to create a table...
  10. puterkrazy

    Create Table help

    I need to create a table on a database on a linked server... I get the following error when specifying the server: create table server.db.dbo.test_table ( col_test char(10) ) Server: Msg 117, Level 15, State 1, Line 2 The object name 'server.db.dbo.' contains more than the maximum number of...
  11. puterkrazy

    SQL - transferring data to another database

    help please!?
  12. puterkrazy

    SQL - transferring data to another database

    how can i create a table on another server?
  13. puterkrazy

    Creating table in different db

    please help!
  14. puterkrazy

    Creating table in different db

    I am trying to create a table in another database, why am i getting this error and how can I avoid it? Thanks! create table dbsrv.db.dbo.table_name ( col_test char(10) ) The object name 'dbsrv.db.dbo.table_name.' contains more than the maximum number of prefixes. The maximum is 2.
  15. puterkrazy

    single_user/multi_user question

    Ok it seems that adding 'WITH ROLLBACK IMMEDIATE' gets it to work correctly? So I have another question.... this statement will only work with SQL 2000, what to use for SQL 7? sp_dboption will not kill current users and you cannot use it if more than one user is in the system at that time...
See more

Part and Inventory Search

Back
Top