The db needed to designed after knowing all the business requirements...

Anywayz,If you need a lookup then build a lookup table based on the existing data.... and add the new or...

just build your update statement string dynamically and execute the string using exec or sp_executesql...

select T2.employid, jobtitle,payrate

from employee T1 inner join pay T2

on (T1.employeid=T2.employid)

where T1.jobtile='030' and T2.paycode=1135

Consists of a single contiguous region of addresses within the SQL Server process space that is set aside at startup. This area is static (the size cannot change) and is...

From BOL:

Maximum Amount of Physical Memory Supported by the Editions of SQL Server 2000

This table shows the maximum amount of physical memory, or RAM, that the database engine in each...

Is SQL Server running using the System Account or a domian account?

If it is running under system account then it cannot acces the network resource.. If not then go the...

simple windows first..

kewl

try running  DBCC FREEPROCCACHE and see that helps..

what does the dbcc memorystatus report w.r.t to MemtoLeave..

does it happen after restarting the service too?

wat is the sql server build version?

EXEC sp_Msforeachdb "SELECT name FROM ?..sysobjects WHERE  type ='P' AND name not like 'dt_%'"

hope this helps.....

declare @site varchar(3)

set @site='2'

select Calldate,Project,

totalhours=

case

when (right(project,1)) = '5' then sum(site1hours)+sum(site2hours)

when @site=2  then sum(site2hours)

when @site=1  then sum(site1hours)

end

from

(

select Calldate,Project,

site1hours= case when site=1 then sum(hours) else 0 end ,

site2hours= case...

check for the existence of the server and the db from from the application and if succesfull exec the proc...

create function dbo.GetProjectvalue(@projectid int)

returns int

as

begin

declare @projectvalue int

SELECT @projectvalue=SUM(Value)

FROM

( SELECT  Value FROM Value1 where <A href="mailtorojectid=@projectid">Projectid=@projectid

UNION ALL

   SELECT  Value FROM Value2 where...

create a trigger.........

check the permissions for the SQL Server service account on the shared folder..