What about writing the masked figure into a VARCHAR(11) variable then REPLACE the decimal in the variable and append that to the string you are writing.

DECLARE @Var VARCHAR(11)

SET     @Var =...

Why not have an NT group built PER Role for the application...  This way again you are not in charge of Suzy cant do this, or Bill can do this. ...

I would start with what Andy mentioned too.  The reason for TCP/IP running better vs. Named Pipes depends on your network set-up.  IF you are in a LAN then TCP/IP...

I have ran into this debate as well.  In my experience (as well as David's) the only way to get to which is better is to build it and see.

Table...

Why not create something like the following:

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SELECT DateLastTouched, Device, COUNT(Device)

  FROM tblListOfStuff

WHERE DateLastTouched BETWEEN @StartDate AND @EndDate

GROUP BY DateLastTouched, Device

ORDER BY DateLastTouched, Device

I know that this...

I think you are wanting to use SQL Server/Windows security...

You sound like you want to define a single SQL userid that connects to your application and then manage a list...

Jonathan,

The DTS package will run locally from wherever it is called.  Instead of having a DTS package from Server2 call the package on Server1 why cant you just move...

Here is information from the BOL glossary:

declarative referential integrity (DRI)

Correct,  The order of all the fields for a UNION have to be same same.  If they are different you will wind up with the problem you just had

Have you been able to connect to the other DOMAIN any computer??

Sounds like you may be having firewall and/or trust issues between the domains based on what you are showing...

CREATE PROCEDURE sp_Test

@Var1 VARCHAR(100)

@Var2 DATETIME = NULL

AS

will work for what you want.  Just make sure that you build in code traps to handle the NULL casing

Remi,

Does the Query that is causing the problem on the new server run ok on the old? 

Regional settings, Locale and Collation (try checking the indiv. database(s)) as well.

Good...

1.  Check to ensure that the Windows UserID that you are using wasn't deleted from the Server Users/Groups and/or removed from SQL user/groups

2.  Check the server (right-click on the server...

Joe,

When you are using xp_cmdshell is the user that invokes that command the same as you?  i.e are you using trusted connection i.e. YourDomain\Joseph when you log in to...

Try coverting the text field to (N)VARCHAR (8000) this way the text field will be able to go into the variable

DECLARE @VAR1 AS VARCHAR(n)

SET @VAR1 = (SELECT CAST(Textfield AS VARCHAR(n))...