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

    Keeping tables updated

    The concept: I have two separate SQL 2K databases: DBA & DBB. A current VB app updates a column in table1 in DBA via a SP. I need to write a SP that will update the same column in table1 in DBB. The SP will be triggered on a timed basis by an external piece of hardware and will look for...
  2. tbode2006

    MultiLanguage Calendar Control

    Hey all, Does anyone know of a good calendar control that automatically adjusts to regional settings, i.e. language and date/time format, or if not automatically, can be done via property settings? This will be used in a low volume, commercially distributed package, so paying for it is not a...
  3. tbode2006

    Changed name of Server

    Hi all, We purchased a Windows 2003 Server from CDW in March 2007 with Backup Exec preinstalled and no service contract. The software was never tested in house prior to shipping the system to the field. In April 2008, the client requested that the computer name be changed to match new corporate...
  4. tbode2006

    Need to rename SQL 2K computer

    My client wants me to rename the process SQL server computer name to match a new company standard. The server instance currently is the same as the current computer name. I have found the following script: [code] DECLARE @machinename sysname, @servername sysname, @instancename sysname...
  5. tbode2006

    Explanation as to how this function works

    set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[fsAction_d] @ActionIdentifier int AS /******************************************************************/ /* Delete procedure returns: */ /* a) -999 if an error occurred...
  6. tbode2006

    Trouble with a SELECT with DISTINCT requirement

    Given the following sample table: col_A col_B col_C 123 RED 4 234 BLUE 2 123 RED 7 345 GREEN 1 123 BLUE 5 456 RED 6 234 BLUE 3 I would like to generate the code to return: col_A col_B col_C col_D 345 GREEN 1 1 234 BLUE...
  7. tbode2006

    Changing signatures in Outlook 2003

    Hello all, I have two companies and have created a signature for each in Outlook. Is there an easy way to designate what signature to use when I click on New Message. Right now I need to go to Email options and change the processing order to put the correct account at the top. There has to be a...
  8. tbode2006

    Default value not returned

    ALTER PROCEDURE [dbo].[ap_myTest] ( @my_in int ,@my_out int = 10 output ) AS BEGIN IF @my_in = 5 BEGIN SET @my_out = 7 END END exec ap_myTest 5 @my_out = 7 exec ap_myTest 6 @my_out = null exec ap_myTest 5,12 @my_out = 7 exec ap_myTest 6,12 @my_out =...
  9. tbode2006

    Application variable declaration

    Can someone explain how the following is used? SELECT C.[description] AS Application FROM tbl_PMS_CLR C Typical values for "description" are Wheel, Frame, Bumper What is the Application type?
  10. tbode2006

    Restoring a database in SQL2005

    I have SQL2005 express running in a VM session. My client has sent me a backup of his database. I copy the backup to a local directory c:\databases. Right-clicking on the +Databases branch brings up the Restore Database dialog UI. I specify the source of the backup as FROM DEVICE, navigate to by...
  11. tbode2006

    Linked server issue

    Architecture: Computer 1 (C1) Computer 2 (C2) Windows Server 2003 R2 Windows Server 2003 Standard Edition Small Business Server SQL Server 2000 SQL Server 2000 No Firewall implemented No Firewall implemented Problem: Trying to link to a database...
  12. tbode2006

    Need a trigger?

    CREATE PROCEDURE [dbo].[spUpdatePrimeTime] ( @pt SMALLINT, --new pump prime time @fc SMALLINT, --{FILTER} filter code [1-4] @cc SMALLINT, --{FILTER} clean cycle code [1-4] @fa...
  13. tbode2006

    Configuring a linked server

    Hi all, I have two computers running SQL 2000. names: SQL_ST_A and S_IT_A I am trying to configure the instance on S_IT_A as a linked server in SQL_IT_A. I have chosen the provider: Microsoft OLE DB Provider for SQL Server. The dialog box wants the PRODUCT NAME, DATA SOURCE, and PROVIDER STRING...
  14. tbode2006

    Timesyncing workstations when server is not a PDC

    Hi all, I have a blade server rack with one Windows 2003 server and 9 Win XP workstations. The client is not using the server as a PDC. I need to time sync all of the computers. What method is available to me in this configuration?
  15. tbode2006

    Server 2003 and SQL2K installation issues.

    Hi all, I have a Windows Server 2003 that I just installed SQL Server 2000 and Service Pack 4. The server manager is running. I can ping the server box by name and IP, but when I go into ODBC administration on my desktop, the server instance does not show up. The firewall on my desktop system...
  16. tbode2006

    Exclusive records between tables

    Given two tables. The first is a list of 100 words. The second contains up to 20 words, constantly changing. At any time I would like to know what words exist in the second table that are NOT in the first table. I have been playing with the different type of Joins but without success in getting...
  17. tbode2006

    INSERTS across databases

    Hi all, Database A Database B Table 1 Table 1 Column Column A A B B C C D D E First: I...
  18. tbode2006

    Accessing a RETURN code from SP

    Dim Status_Parm As Parameter cmd.CommandText = "spAddQuantity" cmd.CommandType = adCmdStoredProc Set Status_Parm = cmd.CreateParameter("", adInteger, adParamReturnValue) cmd.Parameters.Append Status_Parm cmd.Execute Given the above code fragment, how do I get a RETURN code that was set...
  19. tbode2006

    Accessing New INSERTED data

    In my stored procedure I INSERT a record into table 1. Column C is defined as UNIQUEIDENTIFIER with default set as (newid()). I now want to use the new Column C value and INSERT 20 new records into table 2 with table 2 column A being table 1 column C value and table 2 column B be the values...
  20. tbode2006

    Using sp_execute issue

    Given the following in Query Analyzer: DECLARE @f datetime, @t datetime, @c int, @a int SET @f = '19980801' SET @t = '19980901' EXEC Batch_Stuff @f, @t, @c OUTPUT, @a OUTPUT Calling the following Stored Procedure: CREATE PROCEDURE [dbo].[Batch_Stuff] @fromdate datetime, @todate...

Part and Inventory Search

Back
Top