Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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 =...

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?

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...

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...

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...

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...

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?

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...

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...

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

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...

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...

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...