Check this http://support.microsoft.com/?id=321822

It may be helpful.

You can define a linked sever to the text file. Read the content into a temp table and pivot the rows into columns into another temp table, then insert it...

According BOL, FREETEXTATBLE supports wildcard (*) for columns, like the syntax in your SP.

I don't know what you mean it does not allowed.

I don't know what exact problems your programer meant. If the applicaiton is proper coded, there should be no prblem.

For a distributed tran, MSDTC uses two phase commits. If all involved servers are...

osql can return an integer value by EXIT() fucntion. But you cannot get it in a UDF. You can do it in a SP.

CREATE TABLE #ReturnValue(Rtn nvarchar(255) NULL)

INSERT #ReturnValue EXEC...

Do you have a full back up some time before the problem? Do you have full transaction log backup upto the current transaction log?

If you have, you can back up the transaction...

What's the purpose to start notepad in a sql job? SASIK, SQL agent job system CAN NOT start any app with UI.

You must have enabled security audit.

Go to server property-->Security, see what security audit level you are. Change to None or Failure based on your reuqirement.

It's security issue.

What login are you using to run the SP? Is it a member of sysadmin?

If it is, under what account that SQL server service is running?...

Use trusted connection (-T).

Can you try to change the default folder to the file folder before call xcopy?

I.e.:

cd /d c:\Inetpub\ftproot\adam\MisBack\Bais\

xcopy /Q "%1.AIS" "c:\Inetpub\ftproot\adam\Mission"

cd /d c:\Inetpub\ftproot\adam\MisBack\Bcps\

xcopy /Q "%1.CPS" "c:\Inetpub\ftproot\adam\Mission"

If you use binary comparation, it works. Depends on your collation:

Change the line

IF (ISNUMERIC (SUBSTRING (@ID, 1, 5)) = 1) AND (SUBSTRING (@I

D, 6, 7) LIKE @CharPattern)

to the following...

Sounds to me it related to the collation your are using in the database. Can you try to use unique code like following?

DECLARE @ID NCHAR(12)

DECLARE @CharPattern NCHAR (70)

SELECT @ID...

No new posts notification recently. Just know lot of new posts on this topic.

Yes, neoID is right a sql job is not re-entrant. However it does not affect the solution...

From your example, I didn't figure out why you need to enforce the order. But if you really need it, you can try (SELECT TOP 100 PERCENT * FROM authors...