Hi,

I think this cannot be done within a single sql query. If you are using a derived table that is possible. (Select any key column instead of ID)

SELECT...

Hai,

If you drop a table it is faster. But with all its side effects like You need to recreate the table from scratch. (Have the table definition script). . You...

Thanks a lot. This worked well. A silly mistake

Just to test how to apply scalar function to table

Hi James,

What I meant was try connecting from command prompt with the mentioned trace flag

Hai,

Are you trying to use multiple threads from any front end application.

Hai,

Both the statements have a syntax error. Please use the forum for useful purpose

Hai,

When recovery occurs SQL has to scan through the log looking for these updates as well as committing new updates that might be occurring on other databases.

Additonally to check on...

Hai,

Use this

select substring('sub001-001',charindex('-','sub001-001')+1,len('sub001-001'))

If it is a column then use this

select substring(materialcod,charindex('-',materialcod)+1,len(materialcod))

Take care of  boot.ini switches /3 GB

/3gb. Lets user-mode applications access 3GB of memory instead of the usual 2GB that NT allocates...

Hai,

Try this

Create table Qty

(REcordType int null,

 Quantity_Ord int null)

Insert into Qty values (20,100)

Insert into Qty values (21,100)

select RecordType, Quantity_Ord = case when REcordType <> 20...

Hai Phill,

That worked great

Thanks a lot

Hai,

Simply modify the above query

select  name as column_name , collation collation_name ,id from syscolumns where id in (select id from sysobjects where name ='thetable') and collation is not null

Hai,

Did you try quering the sysprocesses table or looking into registry for all instrance. There is a system stored proc master..xp_regread  to read

Hai,

By default, SQL Server 7.0 and 2000 are set to use "Use All Available CPUs" on a server. If this is not your current setting, then this has...