Search results for query: *

Also, server instances are in VM sessions, not a production environment at this time. I am just testing the concept for implementation in the field next week.

insert into [CR_IT_A].[Production].dbo.Table1 (rotation_num,status) values('2001',1) allowed me to write to the linked server. I am still trying other things. Any thoughts are greatly appreciated!

Yes, CR_IT_A is a linked server. I meant the equality to be a non-equality. I know that your code was untested. I have been playing with it without success. select * FROM [CR_IT_A].[Production].dbo.Table1 ProdTable This code worked. I have gotten the following message with your code...

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

Thanks Denny, The prodedures are sp_dropserver and sp_addserver by the way. When I arrived on site it took just 30 minutes to make the change.

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

If it is in the database, how do I go about locating it? What subtree is it under? I see Server Objects under the main tree but it is not there in my SQL Server instance.

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

Thank BlueHorizon. I learn something new every day!

Thanks all for the quick replies! Let me try these out on actual data sets and I will let you know.

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

Thanks for the quick reply. I went under Options and set the signature for new messages to <none>. When I tried the above commands, my signatures did not appear in any list. What did I miss?

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

So what you are saying is that there is no reason to define a default value in the parameter definition for an OUTPUT since it is overridden. I have my procedure working correctly but just wanted some insight to why my initial attempt did not work. Thanks for the explanation George. Have a star!

So adding the SELECT makes it work. My question is why did you have to? What is the purpose of defining a default value if it is not used implicitly?

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

Application just looked i little too specific to be just an alias. I have used aliases before but thought that 2005 may have had something different as it showed up in BLUE. Thanks for the quick response.

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?