Sorry, I can't help you with your problem applying the patch, but personally I wouldn't do it that way anyway. Restoring a master database to antoher server is always tricky...

I...

There...

Like Adi already said, we don't really know what your question is. But since you start about a placing an index I notices at least one problem. Indexed views have...

Could it be that your backup device contains more than one backup?

I see you're using the option WITH FILE =1, which will restore the first backup which has been...

About the job notification for failed jobs, did you configure the SQL Agent to use the profile? Also very important, after any change to the profile you need to restart...

sudhakara (5/29/2009)

---

In Sql server 2005 clustering , Sql server clinet is not able to connect since the virtual server is not available in the network . is there...

That's totally normal. During installation of SQL 2005 you cannot choose a separate drive for logfiles, so the system databases always have datafiles and logfiles in the same directory. You...

Colin Hamilton (5/28/2009)

---

Hi

I'm onsite with a customer today and it’s the first time I've been able to look at their DB. They are a small organisation with no more than...

ming_dong (5/15/2009)

---

We never had this issue if client only has publisher and subscribers. This issue only occurred after distributors were added. Another strange thing is that this issue...

This query is a bit simpler:

SELECT OBJECT_NAME(Id) AS [TableName],

rows as [RowCount] FROM sysindexes

WHERE indid 0

ORDER BY [TableName]

Did you try Books Online?

http://msdn.microsoft.com/en-us/library/aa337552(SQL.90).aspx

In case you ever need such a...

Joe Doherty (5/27/2009)

---

Hi,

I had 4gb of ram in my database server. Windows 2003 enterprise 32 bit. Task manager showed I was using 2.7gb. I was also using /3gb.

I installed another...

Generally speaking, security is a lot tighter in SQL 2005. Also xp_fileexist is an undocumented procedure and MS won't...