Server Configuration

Clustered SQL server 2005 x64 ENT- jobs keep failing after upgradeto SP3 with CU5
Hi all, I am in need of your help. One month ago I have upgraded my 2 node SQL 2005 x64 ENT cluster from SP2 CU1 to SP3 CU5. After this change I have noticed that my SQL server jobs that take more than 60 minutes keep failing on me (not even internal jobs such as update statistics, work). Moreover, the clust... 22 Dec 2009 12:37

deleting backup history
Hello: In SQL 2000, how do yoou delete backup history? I need to reduce the size of our msdb database, and my research is showing that in order to do so I need to delete backup history. Thanks! SQL Programmer (it's just a name) ... 20 Dec 2009 02:49

will shrinkfile with emptyfile cause fragmentation
I understand shrinkfile will cause fragmentation but I have read mixed psots about using the "emptyfile option". My understanding is that it reads from the front of the file and not the back like a normal shrink. Is someone aware if this is bad, the reason for me using this option is because we have a 24by 7 D... 19 Dec 2009 10:31

SQL 2005 Query Response Time
I am sure that at some point people in this forum had to compare response times between variations of the same query. That is, considering there is a lot going on the server, to be able to find 'even ground' and compare apples to apples rather than apple to orages. Could someone tell me how to me how would ... 18 Dec 2009 18:22

SQL statement - 'chop' phrase
hi guys how do i do this SQL statements when a user typed in search text field in my ASP.net webpage? How do I 'chop' the typed-in phrases? examples: 1. typed in phrase: marketing assistant jobs the resulting SQL statement should be: SELECT field1,field2 FROM myTable WHERE CONTAINS(*, 'marketing AND assi... 28 Dec 2009 10:46

Joines Ralated
Can you tell me the Diff Between Left And Right join i know this diff but not this one some more core diff we can used Left join and changeing order of the table we can achived the right join result. why we requred to join ........? LEFT JOIN: Return all rows from the left table, even if there are no matches in the r... 17 Dec 2009 02:47

Audit login
I need to audit user login events from VB.NET. I solved using WMI events on SQL 2K5 and SQL2K8, but I cannot find a solution for SQL2K. It seems that its WMI provider doesn't reports any useful events, but just functions to access configurations and so on. Is this right? Is there any way I can create a program t... 7 Jan 2010 10:11

The provided statistics stream is corrupt
Our users are getting this message when updating one particular table at the moment. Due to some hardware issues we have had to move our live database to another server. I am not sure how this was done. What would I need to look into, or query the tect support with. Thanks so much. From http://www.google.com/custom?... 16 Dec 2009 10:09

past comprehension - Timeout expired. SQL server 2008, ADO NET, IIS
Hello, I have full SQL 2008 server on Windows 2008 server and try to connect via ADO NET, ASP NET application on IIS7 protected void Application_BeginRequest(Object sender, EventArgs e) { .. .. .. try { string ent = SPUZ.classes.Globals.ent(); conStri... 21 Dec 2009 03:44

Clear connection history Answer
C:\Documents and Settings\[Username]\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM change [Username] by your username of system This help is only for XP OS. here you will find a mru.dat. Delete that file. When SMSS start next time it will create new file. MohitKGupt wrote: Do you... 16 Dec 2009 16:52