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!

Search results for query: *

  • Users: puterkrazy
  • Content: Threads
  • Order by date
  1. 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.
  2. 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.
  3. 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.
  4. 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...
  5. 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.
  6. puterkrazy

    single_user/multi_user question

    The following should kill all SQL users and allow only a single user: ALTER DATABASE db SET SINGLE_USER For some reason this runs forever and ever and does not seem to stop and I have no idea why. ALTER DATABASE db SET MULTI_USER only takes a second to run. I need this to work on SQL7 and...
  7. puterkrazy

    Kill user connections

    How can you programatically kill all SQL user connections using SQL?
  8. puterkrazy

    Tables in SQL

    How can you programmatically check for the existance of tables and columns (and data type, length, etc) in that table on a database using SQL?
  9. puterkrazy

    SQL - transferring data to another database

    I need to transfer data to another database, what are SQL commands to do this and what is the best way?

Part and Inventory Search

Back
Top