I cannot figure what you intend to do in the Visual Basic program. 

@@dbts gets incremented when a table that has timestamp column is updated or inserted and not deleted...

you could try

isnull(rtrim(records.amphetamine), ' ')

 I think this should work.

regards

Shaji

you cannot use Getdate() in a udf, Look for deterministic functions in bol.

I think there are 2 error here.  Looks like the dll that calls your SP does not have correct error handling.  The dll is  running as a service, but the...

To me looks like delete and copying is safe, so you can always be sure the databases are in sync.  I am not sure if there is any other way,...

I am sure there are several ways to do this. 

How about create a new table with the excel file that you created, and then update the image filename columns...

In the data columns to display, select BinaryData and you should see this.

Regards

Shaji

I have'nt seen this error.

I am sure you would have checked out these, but if you haven't -- here are some links

http://www.winnetmag.com/SQLServer/Article/ArticleID/14136/SQLServer_14136.html

http://support.microsoft.com/default.aspx?scid=kb;EN-US;309093

http://support.microsoft.com/default.aspx?scid=kb;EN-US;310834

I think you are looking for this gropby query.

select GroupId, count(*) as [Count] from Customerdtl

group by GroupId

since you have already created sql server users, did you try Trusted_connection = yes in the connection string or the one mentioned below.  I have not tried this,...

EM does that because it is using windows authentication to connect to the database.  One way I can think of is to pass the userid from the client to the...

When you use an aggregate function, the null values in the columns are ignored.

eg: Avg(Price), if Price column has a null, it is ignored