samsql (12/4/2009)

---

hi all,

i m having an issue we have a mirrioring(automatic failover) impletmented on ur server

wen 1 server fails the other server goes up but there is a login...

How to post data/code By Jeff Moden[/url]

Hi,

Check the job owner and try to run the job manually.

Check the MS link

http://support.microsoft.com/kb/914779

Edit:Post the correct link

MAK

Post the result

select @@version

MAK-1128556 (12/4/2009)

---

I am in 2005 shop and running the backup through Maintenance plans but tonight I got this error

Executing query "BACKUP DATABASE [crs5_oltp] TO DISK = N'\\de1clcr".: 100%...

Hi,

As per gail suggest,I remove the Deprecated objects in my script .I think this ll post with in two days.(After posted u can change it)

FYI,

http://www.sqlservercentral.com/Forums/Topic827173-146-2.aspx#bm828000

Raghavender ,

...

webrunner (12/3/2009)

---

Hello,

I just got this error (See below) from a maintenance plan at the part where it does a full backup of the two user databases on the server.

Does anyone...

GilaMonster (12/2/2009)

---

Why does your script use deprecated objects (that will be removed in future versions) and global temp tables?

Also,...

Hi,

Gail already point out pages are small

If the table is "Heap" fragmentation ll not remove

But I am not able to understand why the rebuild index task is not able to defrag the columns with int data type. Is it something set wrong at the...

m.John (12/2/2009)

---

I'm not looking for locking pages for sql server. Because other process requesting memory would be SQL related only (.ie., analysis services, SSIS etc..). I dont want to hamper...

Hi,

Click the link

Already Discussed

m.John (12/2/2009)

---

Hi,

Its a 64 bit server.

MAX memory in OS = 16 GB. MAX mem value for SQL Server is 6 GB. Mem is divided among SQL server, SSIS, SSAS.

No AWE...