Thank you

Thank you

I just ran

Maximum server memory

DECLARE @a CHAR(1) = CHAR(10)

SELECT @a, ASCII(@a), REPLACE(@a,CHAR(10),' '), ASCII(REPLACE(@a,CHAR(10),' '))

This is working

Thank you so much

Yes,it is not working, when I click on the data goes away,when I go to another record comes back

no stiil getting it

They don't like big numbers and but I am wondering if this bases on each time interface runs generates unique number

i AM TRYING NOT TO get a duplicate key IN the record. I need to make follow a format of yymmddrrrrr where yymmdd is year-month-day and rrrrr...

Sorry,here is my code:

declare @Number char(20);

set @Number = convert(nvarchar(50),rand())

set @Number = '1' + substring(@Number,3,4)

set @Number = convert(int,@Number)

DECLARE @dd VARCHAR(20)

SET @dd = CONVERT(VARCHAR(20), GETDATE(), 20)

PRINT '

current date:'...

An insufficient number of arguments were supplied for the procedure or function fn_trace_gettable.

This what I got:

traceidpropertyvalue

112

12C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_255.trc

1320

14NULL

151

211

22NULL

23NULL

24NULL

251

Thank you,but I still get the same error when I do this

case when

[section] = 'C'

then

@Number

when [section] = 'A' then @Number + 1

...

2. when server goes down does it switching automatically (it is share point databases)

If you have a witness server - yes.

What is witness server?

3.When server comes back does mirror server...

But