t.walker (2/23/2009)

---

Its free...

http://technet.microsoft.com/en-us/sysinternals/bb897428.aspx

There is also a tool called DiskView.exe which visualises the fragmentation.

I just did a smallish test defragmenting a 5GB MDF in a dozen pieces on a highly fragmented...

Check your settings again.

On whichever server you have LSALERT__ job that's the monitor server.

Are you log shipping all db's from 0 server to 1 server or are you also log shipping from 1 to 0?

Can you list the LS jobs from server 0...

If this is a critical production system.

You can use sqlmobile from Idera.

http://www.idera.com/Products/SQLmobile/Default.aspx

for DDL.

from SSMS right click on db and select schema history changes report.

Certificates are used to encrypt your data just like in IE.

Here is the tutorial on certificates:

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-managing-certificates.html

You have to create a certificate in the master db first.

I used a self signed cert example:

USE MASTER;

CREATE CERTIFICATE testlogincert

ENCRYPTION BY PASSWORD = 'pounlmdsf'

WITH SUBJECT = 'your login',

EXPIRY_DATE = '12/31/2012';

GO

And...

Do you get any values when you run

exec Report.CustomerBasicReport 998,'-1', null, null, 'H'

are you on SP2?

You can...

Was this database backed up/restored from another server?

In the 2005 Server run this:

create table AgentStatus (

job_id uniqueidentifier NOT NULL,

last_run_date int NOT...

r.pe (11/18/2008)

---

Though the server could still be "pinged" users were starting to complain about connectivity problems over the weekend. Most of the calls are from an IIS machine that handles...

That's a .NET Framework error.

Do a clean uninstall and run windows updates to download the latest updates and try reinstalling again.

Sandy (10/29/2008)

---

Chris, It is a very nice query but when i am trying to executed in SQL 2005 its working fine except the DB which is restored from SQL 2000...