I think that the null value refers to the reosurce database....

http://www.sql-server-performance.com/articles/per/Query_Execution_Statistics_p1.aspx

statistics are updated when the index are rebuild...

balbirsinghsodhi (2/28/2009)

---

All of a sudden all the processes are failing on SQL Server because of the timeout error. It was running fine before but not lot of processes are giving...

If you want to remove one or more files with in a file...

here is the definition of script function

Function Script([ByVal ScriptType As SQLDMO_SCRIPT_TYPE = SQLDMOScript_PrimaryObject], [ByVal ScriptFilePath], [ByVal Script2Type As...

cshekhar (2/20/2009)

---

Example:

USERID: 'rex.arnold' must be changed to 'rexarnold' in multiple tables, in multiple columns.

wherever it looks as 'rex.arnold' must be updated to'rexarnold'

Sample Query : ...

Md Yaqoob (2/19/2009)

---

Hi ,

I have a Sql Server 2000 and .net platform...

The result in my front application is the result from the view directly.

The view gives me the...

MANU (2/19/2009)

---

Hi,

I need to script out database and application roles for databases on one of my server. Can someone provide any such script or tell me whish field stores the...

deba_20032004 (2/19/2009)

---

Dear Sir

I am in a big problem while i am trying to connect sqlserver 2000. It giving a proble which is below :

An error 3 -(the system cannot find...

klnsuddu (2/18/2009)

---

Hi,

Could you give some simple Restore script. I found some on this forum, but I need some to understand.

1.to restore full backups to different drives

2.to restore diff backups

3.to restore...

pobeda (2/19/2009)

---

how to script sql 2000 jobs at once as individual files?

Can anyone help save me some time? I need to script all jobs on the server as separate files.

Thanks...

peace2007 (2/17/2009)

---

Hi,

I've moved tempdb files to another drive 2 hours ago (suppose D:\tempdb\..). and when I run exec sp_helpfile, it says that the tempdb files are in the new...

rmaggio (2/13/2009)

---

I have a 2005 environment, where we have some legacy systems moved that require they be set at compatibility 80 (which I believe is sql server 2000 mode). The...

you can use this

http://www.apexsql.com/sql_tools_log.asp"> http://www.apexsql.com/sql_tools_log.asp

you can schedule a job for monthly backup..there are lots of scripts on this site