ramyours2003 (12/28/2009)

---

as w e r experiencing space crunch we need to move on the database files in to the another drive on the same server to ensure the...

--From BOL

Important:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and...

s,u r correct.

/3GB & PAE only applicable for 32-bit

Mohan Kumar VS (12/28/2009)

---

Thanks. Yes, we are using Sql Server Developer Edition 32bit. AWE is already enabled & I've gone through the link provided by you. The...

FreeHansje (12/24/2009)

---

Hi there,

I receive this error 'Cannot alter the user dbo' when wishing to change acces for a specific SQL Login. I can find lots of hits when Googling for...

iqtedar (12/21/2009)

---

This forum has helped me solving so many issues, i am back with another strange issue and i request suggestions..i have a job which is scheduled....the job didnt run...

I often schedule a job to run sp_updatestats on each non-system database on a daily basis.

This procedure was greatly improved with SQL 2005 to only do updates when they...

Search-->please give a query to find out the last date on which statistics updated-->Go

From SSC

Jpotucek (12/23/2009)

---

Select @@Version

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT...

Jpotucek (12/23/2009)

---

These two errors are filling up my sql server and Server level application even log??

Cannot add or update Activity record because Account Owner does not exist.

Error: 250071, Severity: 16,...

Also check the server name

Are u able to connect via ip

select @@servername

select serverproperty('servername')

Hi,

Check the following links this may be help

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=357656%5B/url%5D

http://blogs.msdn.com/sql_protocols/archive/2008/05/03/understanding-the-error-message-login-failed-for-user-the-user-is-not-associated-with-a-trusted-sql-server-connection.aspx%5B/url%5D

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

If I understood...

Hi,

Read and use the De-fragmentation script added in my signature.

gmamata7 (12/21/2009)

---

Hi,

We have SQL server 2005 and I want to know whether DBAs use 'Update Statistics' maintenance plan task or not? As Auto update statistics feature is enabled by default,...