if your users don't need to connect to the sql server directly then you have both options open.

if you store the password in a table you may need to consider...

Thanks Adam,

This works perfectly. I think that should be the final answer.

Adam, following code part is from one of your previuos posts in the discussion.

declare @var varchar(10)

--set @var = char(226)

set @var = 'a#%^;'

print char(226)

if (@var LIKE '%[0123456789abcdefghijklmnopqrstuvwxyz]%')

print 'yes'

else

print 'no'

This is...

Thanks Guys for all your comments. I think the perfect answer for this one based all yours comments would be then....

declare @var varchar(100)

set @var = 'aA12312dfsd;1fs'

--set @var = char(226)

print @var...

did you try

Execute sp_resetstatus?

if not check the BOL for more details.

Resetting the Suspect Status

Microsoft® SQL Server™ 2000 returns error 1105 and sets the status column of sysdatabases...

you can try creating temp column ,update that column with current identity column data then drop the current identity column and re create it with new increment value and then...

It's simple. Assign the new GUI ID into a variable first and use it in both inserts.

declare @Gui as uniqueidentifier

set @Gui = newid()

insert into table1 (

This is what is happening

when you have

DECLARE

@BirthDate datetime,

@t_date varchar(10)

set @BirthDate = getdate()+5

set @t_date = getdate()+5

Since you have declared @t_date  as varchar(10) sql server automatically converts the Getdate()+5 date...

Do you have, the SQL server related to this problem , on your machine or any other machine?

If the SQL server is on another machine when you run it Manually...

It's little tricky... but not impossible...

1. Find a downtime for the system

2. Copy the data of the column you want to change into somewhere else, with the primary key

3. Drop...

If you use SQL Server 2000 why don't you try with sp_repladdcolumn to add your columns. Check the BOL for more information and exceptions.

You have to run this on the...

SET TRANSACTION ISOLATION LEVEL READ COMMITTED (Default setting)

begin transaction

select columns from the mytable (nolock)

update mytable

set ....

commit transction

This will prevent the other user executing the same batch to be blocked if he/she...

Thanks for all your comments everybody.

I checked the SQL Log and i found that the Restore has been completed at the correct time as we expected but QA doesn't report...

Do you store different language data (inclusing russian) in the same column or do you have difrerent columns for each language data?

have you already changed your data types to unicode...

You may need proper indexing of the tables, and possibly defragmenting existing indexes because you have abuot 1000 transactions changing the database every day.

http://www.sql-server-performance.com/rd_index_fragmentation.asp

When you say your application...