Check the Registry value on the server in this hive:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment

This is where environment variables related to this sequence are located. Are the values you need in this key?

...

You can download it if you know where to look. Try:

ftp://207.46.133.140/bussys/sql/public/fixes/usa/SQL65/Sp3/

Select your processor (Alpha or Intel) and continue drilling down.

Assuming an Intel processor, your full download path...

I haven't seen it before, but, based on the MS article, I would try this:

SET @command = N'SELECT * INTO GRD_RESTORE_INFO..MenuItem ...

The only way that I can think of to do this is to pass the values in a working table. To do this most certainly, I would probably generate...

Remember that environment variables are specific to a login, and that a scheduled task is not run with the same login as when you run it from the Console.

Question: ...

You will be better off by checking for the existence of the key in the destination table. In fact, looking at your logic, you will be better off coding...

Database locks are not part of the "by-the-textbook" lock hierarchy that is used by tables (object - page - row). A database lock just means someone is connected to...

Well, I just saw this, and there is a way. Try:

CREATE PROCEDURE dbo.spRef_GetCertifications

(

@activesOnly bit

)

AS

SELECT ID, Name, IsActive, SubmittedOnGMT FROM Certification WHERE IsActive >= @activesOnly ORDER BY Name ASC

Actually, there is an easier way:

Select Coalesce(a.year,b.year,c.year) as [Year], a.value as 'ValueOfSubID1',

b.value as 'ValueOfSubID2', c.value as 'ValueOfSubID3'

FROM

(Select * From MyTable WHERE ID = 1 and SubID = 2)...

If I understand what you want... just keep expanding the query:

Select Coalesce(a.year,b.year,c.year) as [Year], a.value as 'ValueOfSubID1',

b.value as 'ValueOfSubID2', c.value as 'ValueOfSubID3'

FROM

(Select * From MyTable WHERE...

This query should return what you need:

Select Coalesce(a.year,b.year) as [Year], a.value as 'ValueOfSubID1', b.value as 'ValueOfSubID2' from

(Select * From MyTable WHERE ID = 1 and SubID = 1) a

FULL...

This particular error indicates that the DTS process cannot see the target table. If this is the case:

(1) Are the ODBC connection strings the same in DTS and Access?

(2)...

No it will not. You need a script for this. Fortunately, there is one here on this site. See:

http://www.sqlservercentral.com/scripts/contributions/139.asp

Check your authentication methods. Open up Enterprise Manager, expand your SQL Server group, and Right-Click on the server. Select Properties from the drop-down menu, and select the Security...

There is no 'elegant' way to do this, but there are a couple of different ways that this can be done.

The most certain one that I can code uses a...