Similar to 'set nocount on' within a stored procedure, I believe there may be a constant you can pass to a recordset or command object that tells it to 'not...

check out the article here: there are some discussons and examples of how this can be done.

http://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp

Does the database file modified date change when auto grow occurs?

I specifically need the 'in' syntax.

One rumor I have heard is that all DBMS's do not implement primary keys in the same fashion and because of that, if you wanted to create a cross platform,...

If you want to simply execute a query outside of an application, you can use Query Analyzer. To execute a query within an application ADO is probably the best...

Try something similar to this function: (ignore the comment marks)

'Function ExecuteSqlForXMLCommandWithParamsReturnXML(sCnStr, sSqlCommand, ParamAry)

'Dim Cmd

'Dim J

'Dim objCn

'Dim Str

'Dim sXML

'Dim L

'Dim U

'Set objCn = OpenConnection(sCnStr, True)

'Set Str = CreateObject("ADODB.Stream")

'Str.Type = adTypeText

'Str.Open

'Set Cmd...

I think also if you use the ADO stream object, you wont have the CR/LF problem. I believe it will allow strings longer than 2033 characters.

Do the CR/LF's effect the xml in any other way besides visually? They shouldn't effect the parsing of the xml?

Check out my article at:

http://www.sqlservercentral.com/columnists/jwiner/dts.asp

It is another way using all TSQL to run your DTS package.

You need to declare your function at the top. At the bottom you are setting function Main = DTSTaskExecResult_Success, but there is no function header

If I understand you correctly, there is a much easier way to do it:

Column Gender has values 'M' and 'F'

SELECT Gender , COUNT(Gender ) AS 'COUNT' FROM

ClientGender

GROUP BY Gender...

Not sure I understand exactly why it is happening either.

Maybe try deleting the full text catalog and rebuilding it. Maybe something is corrupt. Just a guess....

A couple of things you might want to look at for your full text querying approach.

I believe you may only search for suffixes, no prefix searches are allowed. ...

Can you post the code for the insert trigger you are trying to get working? Is the only diffence the 'For Insert' part of the script?

When you're doing the...