You may also want to read about isolation levels. Search BOL for SET TRANSACTION ISOLATION LEVEL

Sorry, I don't use VB 6. I was unable to locate any information on runtime error 3004, so I have no idea what that error means.  You didn't provide any context...

What versions of Windows and SQL Server are you using on your server? Generally, PC-Cillian is for desktops. You should use ServerProtect for servers.

See if this helps:

cmd.Parameters.Append cmd.CreateParameter ("@newsText", adBSTR, adParamInput, Len(newsText), newsText)

Also, as I mentioned in your other post, if you are calling a stored procedure that uses WRITETEXT, the length of...

Try the following (change is bold text).  Also, be aware that WRITETEXT is limited to about 120Kb - refer to BOL. So if your @newsText variable is longer than that,...

In your asp.net code, loop through your array and call the stored procedure for each row.

My company will pay up to 5000 USD per year for education/training, but we have to use annual leave if time off from work is required. So, the all-day-one-week training such...

Someone may have changed the Regional Settings in Control Panel.

This can be overriden using SET DATEFORMAT, but check the server setting in Control Panel.

print 'Format is M-D-Y'

set dateformat mdy

select convert(datetime,'2005-17-12')

go

print...

Without having access to the hash function used by SQL Server, I don't see how you could convert it.

The resource for PAG (page lock) type is supposed to a combination...

Your CREATE TABLE statement defines the fifth column as entityid, but in your XML it is named entryid.  Since entityid is NOT NULL, the insert failed.  After changing the...

Are you sure you've got the direction set properly? It seems as if the XML you are sending to the stored procedure should be defined as an input parameter (the...

Here's a quick shot at the entire function:

-- SELECT dbo.fnCalculateNewDate('10/10/2005', -4, 'Sunday')

GO

DROP FUNCTION dbo.fnCalculateNewDate

GO

CREATE FUNCTION dbo.fnCalculateNewDate

(

  @startDate datetime

, @Increment int

, @DayOfTheWeek varchar(9)

)

RETURNS datetime

AS

BEGIN

  DECLARE @pos int

        , @oldDayNumber...

You could use the UDF shown below to convert the day-of-week name into a number, or, if you can validate @DayOfTheWeek, just use the expression:

(CharIndex( Left(@DayOfTheWeek,3) , 'SunMonTueWedThuFriSat' ) / 3)...

That's the confusing thing about application roles - they aren't use to connect to SQL Server. You first connect with some other valid login, then once connected, you activate the...

You would need to execute DTSRUN.EXE using the xp_cmdshell extended stored procedure:

exec master.dbo.xp_cmdshell 'dtsrun.exe...'

However, running xp_cmdshell from a trigger is not recommended. If xp_cmdshell or the DTS package gets hung...