Ok, Check this SET @ErrorNum = @@ERROR

IF @ErrorNum <>0

BEGIN

 ROLLBACK TRANSACTION

END

You need to delete your existing SQL Server registration and Register afresh using the actual name of the system/instance of SQL Server.

Hi Chris,

You check for the Error count after every Insert or update statement and do a rollback on each check if the count is greater than zero also check the...

What is that you are trying to do.

You can use the basic syntax

SELECT DISTINCT <ColumnName>

FROM

<TableName>

ORDER BY

<ColumnName> <SortOrder>

What is the Front end tool that you are using for this application for invoking the process.

I agree with Sugesh, its something to do with your SQL Server configuration settings. Please follow the instructions from the below link and I hope you will be able to...

I completely agree with what David has suggested.

For restoring a database by overwriting the existing database, you need exclusive locking until the restore process is completed. So run a sp_who...

There are several articles that could help you in accomplishing your job. I am posting URLs of couple of articles that may help you.

http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp

http://vyaskn.tripod.com/moving_sql_server.htm

You can aswell use a DTS Script or Import/Export wizard from your SQL Server to accomplish your data transfer from SQL Sever DB to Access DB unless you are looking...

If you have definite set of options its always better to use CASE in order by clause and define the conditions and coming to Sort Order, I don't see a...

Can you please post your table structure and the query. Your question makes sense as it should not really take so much time.

As posted by Sergiy, Your DISTINCT clause would implement a GROUP BY implicitly and does a scan of the results, so in the query analyzer if you look at the...

Are you talking about the result displayed in your query analyzer? Check if you have Maximum Characters Per Column value under Tools-Options- Results tab.

You are trying to return mutliple columns inside your CASE, it is not supported, as per your requirements it is better to use IF ELSE Blocks. You can nest multiple...

SELECT CAST(GETUTCDATE() AS SMALLDATETIME)

SELECT CONVERT(VARCHAR(16),GETUTCDATE(),20)