I am sure that you have already checked this too but,

Is the SQL Server in the same domain as your PC?  If not are the domains trusted to each...

try using the following:

mmc.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC"

If that doesn't work navigate to the location and right-click on it and use the Run As feature (If you...

Pbaldy,

Another way of doing this is:

DATEDIFF(mi,

  '01/01/1900 ' + CAST(@StartTime AS VARCHAR(5),

  '01/01/1900 ' + CAST(@EndTime AS VARCHAR(5))

You will need to check BOL for the DateDiff variants...

DK,

Please refer the following information from SQLServerCentral

http://sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=145

John,

Have you tried the following:??

SELECT * FROM databasename.owner.t_srf_rqst???

The xp_sendmail runs from master and your table probably isn't in master.  I think that once you tell it where to look...

I like what Grasshopper did but, you need to carry this further.

If all you want to do is open the Excel file for READ-ONLY view why use a DTS package???

Sure it can be done by writing an ActiveX script inside the...

Frank,

I know it is possible however, it isn't as easy as EXPORT Database to database.txt.

You will have to EXPORT each table and/or view to it's own flat file.  AFAIK...

UPDATE table SET c = c + a 

Helder,

Try creating a table with a single column VARCHAR(2000) and build the FTP command into a string and then INSERT that string into the table you just created.

You can...

I think the problem is that when you run the DTS package you are running as yourself (Not a scheduled DTS package which should fail in this case)

Please check the...

Can you post your query here??  Are you discounting NULL values from the count?

Are you doing any GROUP BY or DISTINCT when pulling the data across?

Thanks,

AJ

No offense taken Gary .

Thanks for the corrections

Kelsey,

How are you scripting the procs??  How were the procs created??  Are you scripting using ANSI or UNICODE

It looks like the developer probably modified the code in a text...

SET @test1 = (SELECT CASE WHEN @a = 0 THEN 'XYZ')

SET @test2 = (SELECT CASE WHEN @a = 1 THEN 'ABC')

SET @test3 = (SELECT CASE WHEN @a = 2 THEN 'LMN')

This is...