open the sql server. go in the database properties and close all the connections connected to the database.

system configuration?

dhaval_dsa (5/14/2010)

---

CREATE PROCEDURE USP_UPDATESAL

@DPID INT

AS

BEGIN

DECLARE

@DPTID INT,

@SAL1 MONEY

SET @DPTID=(SELECT deptid FROM Humans WHERE deptid=@DPID)

SET @SAL1=

CASE @DPTID

...

Joy Smith San (4/22/2010)

---

Hello Experts,

I have a job running at night everyday.

It pulls 2.5 million data from an oracle linked server and insert into tables in SQL Server 2005 datbase.

My...

Arjun Sivadasan (4/22/2010)

---

I am not sure if I should post this question in the TSQL forum.

Scenario: There are five databases - db1, db2, db3, db4, db5

In a query i need...

sachinrshetty (4/20/2010)

---

Thank u Lowell for your answer but i have to pass a date value to this stored procedure from front end.

So in which shall i pass either in mm/dd/yyy...

in LINQ or iin SQL??

select * from <TABLE> where <cOLUMN> not in (nVALUES)

create a job in that sql server and set its schedule type to "Start automatically when SQL server agent starts" and set the notification to Email / Page or net...

you want data caching at database level or at the application level????

if there is no other option than Truncate, then change the model from "Full" to "Simple" so that the database could contain the active portion of the log, then take...

raju.tanneeru (2/1/2010)

---

Hi Every one, good morning.

currently my projects is in SQL 2005 and the project is moving to SQL 2008. when i am working on redesigning the data base i...

Yes adding RAM will help but that will also depend on the cache it will provide.

RAM has its own limitations.

Better you improve the application model

check the query execution plan and based on that you will come to know the reason probably.

sanketahir1985 (1/5/2010)

---

as Shawn Melton said

1. check for free space on drive where tempdb is stored

&

2. Try to truncate log of tempdb only if no users are using tempdb database.

3....