Lets Put Some Numbers on The Tables

I will recomend that if you have more than 5 Users at the Same time for the Data base Use SQL Server

Large Data Sets...

This Eror Was Solve By Reinstalling to OS

NT Hebrew Anbled with No MDAC

The Hebrew MDAC Has returned an Un Kown Answer to the Sql server

I could not un istalled it...

quote:

---

Have you checked that the db is not in use when the job runs? If there is any user in the db,...

I have Found an article about it

http://www.sqlservercntral.com/columnists/bknight/renameserver.asp

OK Problem Solved

If the SQL Server Is performing a Remote table Scan than "I will make the table local"

By writing a stored procedure that gets some paramters with the new...

use tempdb

if exists (select name from sysobjects where name='sp_list_schema' and xtype='P')

drop procedure sp_list_schema

GO

create procedure sp_list_schema(@db_nameX sysname , @db_Server sysname)

as

declare @SQLString as nvarchar (4000)

declare @db_name as sysname

declare @db_NameY as...

Tanks but a middle tier is out of the question due to security risk

I am using the link server method to by path decleration on the company fierwall

if i open...

Supplamental

I have checked the query plan and found out that when I am updateing or deleteing a remote table scan is preformed

I have tiried to use thw "with (index(0))"

but the...

Supplamental

Insert with the same prefrences works fast

Delete Works Very Slow

In SQL Server Client Network Utility You Should Set an Alias to the server IP Address

With TCP Library , Hoping that there are no routing problems Or Fire wall Filtring...

Thanks I had Checked Again and seems that i had made the mistake