And You had added the Sqlserver.exe and the PORT under Exception in your firewall..

Thanks,

-Nirmal

SQL Server DBA/Oracle DBA/Six Sigma Certified Professional

Would like to share my experience with you...Not sure if you are having similar situation

SQL server has the problem......

While making a RPC call to SQL server, even you can insert...

Try to Shncrhonized the threads...right click on DTS designer while opening the package and check

NUmber of threads->1

Execute package on main thread->ON

and then run with appropriate dependencies of COMPLETION of...

http://support.microsoft.com/kb/246133/

Hope, You have set the application level trigger to NFR(not for replication)

Thanks,

-Nirmal.

USE the CAST function

select

 SQLServerName = substring(a.Name,1,20)

,' date' = CAST ( a.createdate as varchar(11))

From  dbo.table1 a

     ,dbo.table2 s

where s.Name = a.Name

group by substring(a.Name,1,20),CAST ( a.createdt as varchar(11))

Thanks,

-Nirmal

SQL Server DBA...