Server Configuration

Converting UniqueIdentifier to Int data type
Hi, We have three fields in a table with primary and foreign key relationship. Field1 data type 'nvarchar' Field2 data type 'Int' and Field3 data type is 'Int' Now I am trying to move a field from different table where the data type for that field is UniqueIdentifier. I am not able to do this. Please help how... 25 May 2010 13:33

Locking Diagnostics
Would anyone have the source to sp_blockinfo stored procedure? Thanks in advance ... 25 May 2010 12:26

Migrate changes made on a dev SQL server to the production server?
My SQL database is called Clinic. All developments are carried out in my local SQL server. Once the development is done, Clinic will be pushed to the production SQL server. Client's data are stored in the production SQL server. Now, the same client needs enhancement features, which also use the same database C... 25 May 2010 06:57

temp_MS_AgentSigningCertificate_database
Hi, I have to change my database files to another storage. I have a C7B64FBD-9450-4DA7-9F09-1BAA4D69FA35.cer file that i don't know what it is. I think it is related to temp_MS_AgentSigningCertificate_database that i don't know either its porpose. Can anyone Help? I have all the files moved to the new locat... 25 May 2010 06:57

Convert Null to Blanks
How do i convert "null" values to just show blanks? I'm using the following which returns a "0" value: Isnull (C.DaysInactive, '') as DaysInactive ... 24 May 2010 11:15

SQL Server 2005 Failure - Logical consistency-based I/O error with
Hi Experts Few days back we faced an issue with Microsoft SQL Server 2005. The error message which I retrieved from Eventviewer at the time of SQL server failure is as follows – SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:932354; actual 22624:1041497854). It occurr... 24 May 2010 23:27

For SQL experts: manage automatically updates using a frequencyvalue
Dan Guzman ha scritto: There is a thread in microsoft.public.sqlserver.programming from "Sarah" with this exact same question. I suggest you follow the thread there. Yes, now I'm using another PC (I'm not at work today) I still have this problem but I can't find a solution... :-(((( ... 23 May 2010 19:04

For SQL experts: manage automatically updates using a frequency value
Hi! I would like to create a SP for automatically manage "course updates" on "Courses" table I've a table with a list of Courses CREATE TABLE [dbo].[Courses]( [ID] [int] IDENTITY(1,1) NOT NULL, [Description] [varchar](200) NULL, [IDCourse] [int] NULL, [Update] [bit] NULL, [Required... 24 May 2010 17:57

Setting a condition for MORE THAN ONE attribute to list ANOTHER di
I have a charter table containing : charter_nbr (numeric-pk), ... a charter_leg table containing : charter_nbr(numeric), cl_leg_nbr(nemeric-pk), cl_etd(date), cl_atd(date),... each charter flight may have more than one leg. and each leg has ETD(estimated date+time departure) and a ATD (actual date+time depart... 25 May 2010 09:07

How do I determine default instance vs. named instance install?
I need to determine the status of a server built by another Admin before he left the company. One of my tasks is to determine if the SQL 2005 workgroup SQL was installed as a default instance or a named instance. Can someone either tell me how or direct me to a document please. Thank you. ... 24 May 2010 11:15