Server Configuration

SQL Server 2005 on CM 07 server gives error 2401
Hi! Receives maintenance error on SQL Server 2005 on CM 07 server. See below: === ConfigMgr 2007 Status: Database Notification Monitor failed to execute a Site Maintenance task. A new monitored SMS status message on machine SACHS from component SMS_DATABASE_NOTIFICATION_MONITOR with message ID 2401 was found ... 18 Sep 2009 07:46

SQL 2008 FK Issues while Inserting
I am importing data into a table and I have worked through all of the conversions and "no nulls" etc. but now I am getting the following error; I am populating that field so I am not sure why the error is generating the MSDN site error reference wasnt too helpful. Any insite would be great. Copying to [dbo]... 12 Sep 2009 06:27

[sys.dm_db_index_usage_stats].[user_lookups]
Hello Tibor, I was searching for information on [sys.dm_db_index_usage_stats] and came across this thread. A table which exists in our db has 1 Clustered and 1 non-clustered index. The clustered index has: scans:0 seeks:66 lookups:3848. The non-clustered index has: scans:0 seeks:5328 lookups:0.... 11 Sep 2009 06:15

Unix Timestamp Conversion
Given the following timestamp in MySQL Unix Time: 1259294400 If I run the following in MySQL I get the date/time below (which is correct): SELECT from_unixtime(sessdate), id FROM mdl_attendance_sessions; 2009-11-26 23:00:00 If I run the following in SQL, I get the date/time below (which is incorrect): sele... 9 Sep 2009 18:47

Login Failed Reason: Token-based access failed
I have a SQL Server 2008 database server that I receive the following login error. Please help me resolve this issue. Thank You, Error: Login failed for user 'HJKPK\FSDD3018'. Reason: Token-based server access validation failed with an infrastructure error. ... 14 Sep 2009 19:51

[sqsrvres] CheckServiceAlive: Service is dead (Event ID: 19019)
Hi all I am using SQL 2005 SP2 64bit on Windows Cluster. Since some days I have about once a day the following problem: SQL Service stopps without any message ... The first message in the EventLog is: "[sqsrvres] CheckServiceAlive: Service is dead" After this, there are some more Error messages like: "[sqs... 29 Jan 2009 09:00

Script to stop running traces
Hey All, Hope this comes in handy to someone: /* The system is alway running the default trace with traceid = 1 to support DMVs */ /* Make sure no other trace is running, if so stop it */ DECLARE @maxTraceid INT; DECLARE @killTraceID INT; DECLARE @counter INT; SET @maxTraceid = (SELECT MAX(id) FROM SYS... 28 Jan 2009 16:36

Unable to shrink trans log due to log_reuse_wait_desc=REPLICATION
I have just found a server (out of 1800 I monitor) were the transaction log has grown to over 90 gigs (db is only 8 gigs) and I am unable to shrink it and the disk drive has only 5 gigs of free space left (I had to delete files to free up that much space). The database is set to Simple recovery. I have tried ev... 26 Jan 2009 12:02

How connect to a remote sql server behind vpn
I'd guess this is doable but that I just have not found the right config to make it work. I vpn into a remote corporate network (cisco vpn software) and via RD use an installation of sql server 2005 mamagement studio on that box to work with both a sql server instance installed on that box, and the production d... 28 Jan 2009 07:06

SP3 Install instructions
I have to install sp3 on one of my 2005 test sql servers. I have been able to download the executable but the setup and readme file on the Microsoft site comes up not found. Does anyone know where I can track down the install notes? SP3 Download link http://www.microsoft.com/downloads/details.aspx?FamilyID=... 22 Jan 2009 09:44