Hi

One major difference between temp tables and table variables is that you can index your temp tables.

Generally when you have a large dataset you would use temp tables and...

Whihc is the OS you are using.

Hi

Backups will not help in your case. What abt importing data.

You can use queries where you can take only the required data and import it. You can also use SSIS.

If you dont get the error message then its confirmation that the deletion worked properly.

Hi

1 - Order should not affect the performance. Order does not affect the execution plans made by SQL Server. It then uses these plans when u execute the queries/procs.

2 -...

Add error handling

CREATE PROCEDURE sales.up_EmpDelete

@SSN char(9)

AS

BEGIN

DELETE FROM employee WHERE ssn = @ssn;

IF @@Error <> 0

BEGIN

RAISERROR 50001 ' Error while deleting from employee'

END

END

Nice article and easy to understand.

Hi

Are you having the same problem if you are querying a minimum no: of rows say around 50.

did u change the protocols and check.

Is there any Firewall ....

From BOL

The Local Service account is a special, built-in account that is similar to an authenticated user account. The Local Service account has the same level of access to...

Hi

I think you can easily create a small table and try out the sql statements. If you can use a table with the same or similar structure as that of...

You will need a domain account for this.

Yes, If you have jobs that need to access the network then your SQL Server Agent must be configured with a domain account. For ex:- if u have log...

Yes use the UpdateLock (UPDLOCK ) .

Hi

Assuming you have a identity column

take the max value of the identity column for those records where the "flag is set".

Then query the next 100 records whose identity value...

Hi

Was the column name changed ? was some other column renamed to the column used in the view ?