ParseName() will not work with more than 4 parts.

Look here for SQL Server 2000 and SQL Server 2005:

http://www.microsoft.com/industry/government/section508.mspx

The document for Server Server 2000 doesn't discuss RS, but the 2005 document does.

Actually, the problem is the both QA and EM will automatically reconnect a killed connection. For example, if you kill a QA connection using EM, then refresh the Current Actvity,...

I hope you can change the application, because otherwise I don't think it's possible. You didn't state whether or not rows with existing PKs should be updated, or if they...

I've have been a SQL Server DBA since 1992. I am not Microsoft certified. If I was, then I would explicitly put that on my resume (i.e. MCDBA). In your...

Of course, any of those methods depends on the fact that you have previously defined foreign keys among your tables.

Rudy is correct, the errorlevel is not set by that informational message. Unfortunately, I don't know of any way to suppress it. The error will occur when a stored...

I just tried the sp_update_jobschedule suggestion, and it works.

I created a job that executes one step called 'Step1':

INSERT JobTest (message) VALUES ('Job was run')

I created a schedule called 'Schedule1'. ...

Actaully, the error message originally posted surrounded the date with two single quotes on each end, not a one double-quote. Maybe ASP or the driver (ADO?) is adding them for...

Ray is correct, we need more information. However, I quickly threw this together:

CREATE TABLE #Charges

(

  id int IDENTITY(1,1) PRIMARY KEY

, Chg_code varchar(6)

, Chg_amount decimal(8,2)

)

INSERT #Charges (Chg_code,...

Actually, the final INNER JOIN follows the WHERE clause, which is a syntax error.

Move:

INNER JOIN

(

SELECT TOP 1 AcctNo

FROM QueueOrderBatch

ORDER BY RiskId

) Z

ON A.AcctNo = Z.AcctNo

before the WHERE clause.

Assuming bit columns in SQL Server 2000, you could try either a stored procedure or a user-defined function, something along these lines:

CREATE PROCEDURE uspGetMenu

(

  @userid int

, @q varchar(8000) OUTPUT

)

AS

From a command prompt, I executed osql on my TEST database, using your code stored in a file called osql_test.sql. Two GOs were missing from your posted example - they...

Just to be clear regarding SET DATEFORMAT:

If the dates are received as '09/30/2006' then use SET DATEFORMAT MDY

If the dates are received as '30/09/2006' then use SET DATEFORMAT DMY

You have two options:

1. Try adding this line of code before converting to smalldatetime:

SET DATEFORMAT DMY

2. the YYYYMMDD format works with all regional settings. It is the best...