Hi guys, Is there anyway to change the default recode locking type (Table Locking) to row locking !! ? Thanks in help -Sniper ...more >>

hi all microsoft offers new updatable version of MSDTC not by the windows service pack or sql server service pack -- cjpar ----------------------------------------------------------------------- cjpark's Profile: http://www.msusenet.com/member.php?userid=54 View this thread: http://www....more >>

I currently have a comment column with hundreds of rows. For example, the comment column states message 3 has a issue with programming datasets. I would like to change the word programming only to developing to. What is simplest way of doing this using the update command? currently messag...more >>

I have a Contracts table that has a contractNumber and ContractCode which is the first 4 digits of the ContractNumber. I have a serviceRates table that lists the billable components based on the ContractCode which identifies the contract year. There are multiple contracts using the ContractCod...more >>

Hello, is there a way to make a sql statement that checks disk space and returns a value if it is below x%?...more >>

Hi! I have 2 field in my table that needs to store time only (it's a field that stores the timing a user can logon to the system). Is there any datatype that stores time only, as to what I understand, Datetime and Smalldatetime stores both date and time. I don't want date, I just want time. If...more >>

Guys, I have a identity flag set on a column. When i am testing the system, inserting records the identity goes all the way to 60 and so on. I need to put the table in production system now. However i need to reset the identity field to start from 1. How can i clear the identity field and m...more >>

sql2k sp3 I assumed this would work as easily as the Insert and Update Triggers I wrote did: create trigger DelAuthors on authors for delete as begin set nocount on delete tmp_authors where tmp_authors.au_id = deleted.au_id end Server: Msg 107, Level 16, State 2, Procedure DelAu...more >>

Hi I Have a Ticket field in my DB and store tickets numbers : There are two formats to store the ticket: 00001 00002 00003 S0001 00004 S0002 I want to retrieve the last number without "S" format (e.g 00004) What is the best way to write the Where? Select Max(Ticket) From Sales...more >>

Hi all, I'm working on creating a ms-sql database that will work with an existing third-party application. As such, I have full control over the DB schema, but no control over the third-party source. The application is using ODBC to talk to my DB. I have everything working fine, up to wh...more >>

How can I use an IF statement in a WHERE clause in T-SQL? I only want to include that part of the WHERE clause if a variable that has been passed to the sproc has a certain value. Example: SELECT * FROM Reservations WHERE (DTBooked = getdate()) if @vBookedBy_UserId <> -99 and @vBookedBy_...more >>

to the MSDN forum monitors, Is there a way to permanently block ALL posts from indviduals (such as the person whose signature is 'unknown') who have demostrated a predilection for, or have a history of, proselytizing, or posting religious, political, commercial (or any other completely i...more >>

Good day. I have a form with approx 90 related components. All 90 components are associated with an App_ID. An App_ID can occur more than once but with different data from the 90 fields. I simply cannot decide whether to store the data from each component in it's own column or as a separ...more >>

Hi, I am currently working on a project where we have approx. 10 developers working on the same database creating & editing functions, triggers, stored procedures and such... However, at the moment this causes a lot of problems because two developers can work on the same procedure at the sa...more >>

Hi all, I have a table below, with approx 2 million rows. I have a clustered index on CLI, and a foreign key constraint on FileID and CarrierID. None of the columns allow nulls. ID int FileID int CarrierID tinyint CLI varchar(11) Extension varchar(4) Start datetime Duration int Cost...more >>

Hi, I have tables like these CREATE TABLE Companies ( Id INT PRIMARY KEY, ParentId INT NULL REFERENCES Companies(Id), Name VARCHAR(100) NOT NULL, Deleted BIT DEFAULT 0 ) GO CREATE TABLE People ( Id INT PRIMARY KEY, CompanyId INT NULL REFERENCES Companies(Id...more >>

Not gonna talk about my love life, but rather this simple sql problem, but not sure how to solve it. Imagine CREATE TABLE Relations ( INT PersonId1, INT PersonId2 ) Now I define these relations: INSERT INTO Relations VALUES(1,2) INSERT INTO Relations VALUES(2,1)* INSERT INTO Rel...more >>

Hi, I would like to generate an XML query using the 'for xml' clause and assign that to a text variable for further manipulation. for e.g., I would like to do some thing like this. declare @test text Set @test = Select * from test_table for xml auto But this gives my the syntax error. Ca...more >>

Hi, I have a small DB, about 200MB, but my transaction log files grows regulary over 900MB. The only way I have been able to manage the log file is to detach the database, delete the log file and reattach the DB. Is there any better way to manage growing log files? Thanks in advance Chris...more >>

I have atable where i store visitor data (from a website). In table i have a column LanguageData Typical entries are: no en-us no,en-us en; en-us; no ..... So i am trying to do a select where i remove every thing after the ,. Like this: LEFT(LanguageData, CHARINDEX(',', ...more >>