add an index. (if its not there)

USE [YourDataBaseName]

GO

CREATE NONCLUSTERED INDEX [IX_Deleted_Ind ] ON [dbo].[Table1]

(

[Deleted_Ind] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF,...

is your Informix driver certified for Windows x64?

i submitted my solution;

create table #mytable (Items varchar(8000))

declare @mystring nvarchar(250)

declare db_crsr cursor for

select Content from TC41

open db_crsr

fetch next from db_crsr into @mystring

while @@fetch_status = 0

begin

declare @lookforspace char(1)

set @lookforspace = '...

no. the example also shows "and" and "is" also. It is not always "to"

Windows Support for Logical Units Larger than 2 TB

With Windows Server 2003 Service Pack 1 (SP1) and Windows XP 64-bit Edition (x64), these limits have changed.

Microsoft added support for 64-bit...

Its good info. Gives me some new ideas on how to handle text files....

I have always used a User Defined Function to get text files into a table.

--------------------------------------------------

-- USAGE...

what is the service you are talking about? maybe the company / dev that wrote the service would have the answer you are looking for.....

every app / service acts differently...

not to sure how to get around NOT passing the year. Have never seen that before.

declare @mydate datetime

set @mydate = 'May 05 10'

select convert(nvarchar(24),@mydate,101)

maybe you should change the ownership back to dbo.

EXEC sp_changeobjectowner 'TableName', 'dbo'

unless you have chosen to use SMTP authentication, it can be anything you want.

so , if you authenticate, it has to be a real email address on the email server.

if...

that your email server is allowing this particular SQL Server to relay.

That the user account that is the 'sender' from SQL server is a good address. (if it is authenticating)

can you show us your stored procedure you are calling?

you can do this;

;

WITH

cteFindMax AS

(

SELECT ROW_NUMBER() OVER (PARTITION BY DetailsID, FollowupID ORDER BY FollowupID DESC) AS Occurance,

*

FROM [the name of your table]

)

SELECT *

FROM cteFindMax

WHERE Occurance =...

hello,

change your SQL Agent job step test 2 to this;

EXEC master..xp_CMDShell '"C:\test3\test1.bat"'

also change the job type from Operating System (CmdExec) to (T-SQL)

make sure the SQL Server Browser service is running.