Hi,

Please make sure that you don't have any empty spaces.

Did you check the database compatibility. Hope it is 80.

If the database compatibility is 60,65,70 then probably you have some...

Hi,

The following should work

ALTER TABLE Test_tbl ALTER COLUMN Name

            varchar(50) COLLATE Latin1_General_CI_AS NOT NULL

Use set sp_dboption @dbname ='db',@optname ='offline',@optvalue =true

To manually start right click database in enterprise manager and bring it back to online or use sp_dboption

You may also use ALTER DATABASE command.

But...

How do u want to create a stored procedure programmatically- using any front end application. Use of inline statemtements is preferred. Use front end validation so that they do not include...

Hi,

What is your requirement.. If I understand clearly whenever u want to insert data into customers table, you will want to insert data into CustomerNames table as well. Or you...

Hi,

In addition to what Kramer has said I would also suggest to look for any blocking or locking issues. You may set a trace flag to see if there are any...

Hi,

Creating traces on production server will degrade performance. It is better if you create server side traces

Hi,

See if this works

select id, owner1,owner2, vin from ta left join

(select min(id), min(owner) as Owner1 from ta group by...

Hi,

You can do it. copy the syslogin table to any one table. Use cursors to call sp_addlogin. For converting passwords if it is SQL server login there is a stored...

Hi,

Try this

select column1, substring(columnn1,charindex(columnn1,'(')+1,charindex(columnn1,')') as Column2

from tbl

Hi

When SET ANSI_WARNINGS is OFF you may not get any warning messages. Check the lenth of each column in the Table defintion. It may be that the value that you...

Hi,

You have to increase the job history log.  Please see below

How to resize the job history log (Enterprise Manager). This is due to insufficient log space(i assume). See the lines...

Hi,

Using Dynamic SQL to Create a Valid bcp Call

If it is important to have the date the file is created in its name. Dynamic SQL is used to accomplish this....

Hi,

Here goes a sample code

RESTORE DATABASE Train_test

FROM Training_1 -- From Device file

WITH  NORECOVERY

GO

-- Transaction log is backed up on a single device file Train_test_log

RESTORE LOG Train_test

   FROM Train_test_log

   WITH FILE...

Hi,

Could try this as welll if column width is not fixed

update TA

set reference =b.ContId, principal =b.principal,Book =b.Book, Strategy=b.Strategy

from TA a, TB b

where replace(a.trad_type,'-A','')=b.reference