when I insert to table by opening table in server management studio, I got error "This row was successfully commited to the database, however a problem occurred when attempting to retrieve the data after the commit. Because of this the displayed data in this row is read-only. To fix this prob...more >>

Is there a method for a non-sa user to use TRUNCATE TABLE rather the slower DELETE FROM? Any run-as-user kind of thing in SQL 2000? -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10...more >>

HI, Is there a way to create a linked server to dbase files. I need to be able to import data from dbase files on a regular basis, once the data has been imported it then needs to go through a verification and transformation, then finally imported to the correct table. I thought of using DTS,...more >>

I would like to pass a number parameter and I would like to build number of columns that match this number or less. I tried using a CASE Statement but I could not get it to work in the SELECT. @NumberColumns = 2 SELECT id, SUM((ISNULL(rate,0))*(1-ABS(SIGN(DatePart(dd,log_date)-1)))) AS '...more >>

Hi everyone, I have a server and several clients. I plan to make a mirror from server's database. Can you all please help me how to do it step by step? Thanks, Nassa ...more >>

I have a table whose defintion is scripted as (Sql 2005) USE [rmtTel] GO /****** Object: Table [dbo].[licStats] Script Date: 01/20/2007 13:47:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[licStats]( [licStatsId] [int] IDENTITY(1,1) NOT NUL...more >>

Hi This is a dumb question as I know it's fairly easy but I cant seem to find an example after two hours of searching. In a stored procedure I'm trying to build up a string eg, (the following is in a loop) IF @xcount > 0 BEGIN Set @list = @list + @title + ': ' + @xcount END Probl...more >>

Hi I am a newbie, particularly in relation to databases, and am working on an asp.net app. I need to edit a database table directly. Any help at all is highly appreciated. MR ...more >>

Hi All, I'm trying to create a diagram to my 2000 sql server sp4 from my laptop connection without luck. I have "Invalid Class String" Error. Any ideas why? How can I fix this error? Tks JFB ...more >>

Because of a lock issue I have found that the operators “<>” and “NOT column =” do not execute the query in the same way, and also the Execution Plan for the <> operator could be different in different tables. I used the northwind database to run this example. Run the following qu...more >>

I have a table TEST. Use the insert statment: insert into TEST(REFNR,REFNRMAIN,FIELDNAME,FIELDVALUE,RESERVE1) values(1,1,'No info',No info','No info') I want to insert 5000 equal lines into the table. Can anybody help ? \Titten ...more >>

Hi, Anyone know why the "included column" option in the index design view in SSMS is always grayed out? I would like to add some columns into the "included column" but can't It can only be added by using T-SQL? Thanks Ed...more >>

I want to insert all the records existing in a SQL Server DB table named, say, 'Table1' in another table named, say, 'Table2'. Moreover I am not aware of the number of columns as well as the column names that 'Table1' contains. This is how I am trying it: INSERT INTO Table2 (SELECT * FROM Tabl...more >>

Hi All How Can I run File .sql From Sql.DMO To Create Table Like CREATE TABLE [Categories] ( [CategoryID] [int] IDENTITY (1, 1) NOT NULL , [CategoryName] [nvarchar] (15) COLLATE Arabic_CI_AS NOT NULL , [Description] [ntext] COLLATE Arabic_CI_AS NULL , [Picture] [image] NULL , CONSTRAI...more >>