i think he said it should increment to the size of the database. but still u can answer on my meterics like onece in day or twoice in a day...

• This reply was modified 4 months, 3 weeks ago by  rajemessage 14195.
• This reply was modified 4 months, 3 weeks ago by  rajemessage 14195.

artical does not say any thing about critaria , like the increment of datafile or log file should be once in a day or twoice in day?

like if i know...

• This reply was modified 5 months ago by  rajemessage 14195.

my second query is. the place i am looking is correct  place for (10 to 15 ms)  or it is telling diffrent  story?

• This reply was modified 5 months ago by  rajemessage 14195.

one more thing  my log file of database (this is not tempdb this is reular db) is increasing like this , should i increase then auto increment?

file is attached.

• This reply was modified 5 months ago by  rajemessage 14195.

second question is unanswered.

1. yes it is pk id pool, we pick up from this table and insert into our OLTP table's PK.

2) sequence i can not use , becasue the id is...

like inlinable scalar udfs requiremnts , is there any link which can tell me requiremnts of UDF like this one

do u want to say that we should not use begin end in inlined scalar functions?

do u want to say that we should not use begin end in inlined scalar functions?

• This reply was modified 8 months, 2 weeks ago by  rajemessage 14195.

the case is one bat file runs at a time. kindly answer in this light.

regarding q1) are u saying sqlcmd when completes, it closes the connection or it keeps the...

this is how i am calling

xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng.

sqlcmd -S abc -U rr -P xyz -Q "use db EXEC usppp @strSourcedb...

• This reply was modified 1 year ago by  rajemessage 14195.
• This reply was modified 1 year ago by  rajemessage 14195.
• This reply was modified 1 year ago by  rajemessage 14195.
• This reply was modified 1 year ago by  rajemessage 14195.
• This reply was modified 1 year ago by  rajemessage 14195.

With one exception, you can switch from one isolation level to another at any time during a transaction. The exception occurs when changing from any isolation level to SNAPSHOT isolation....

• This reply was modified 1 year, 5 months ago by  rajemessage 14195.

thanks, quite clear, can I get some MSDN links where I can read related to this topic, in detail.

• This reply was modified 1 year, 5 months ago by  rajemessage 14195.

My question was something else, kindly help here.

I know about committing and rollback.

yours sincerley

• This reply was modified 1 year, 5 months ago by  rajemessage 14195.

we do  not want to use xml. so pls tell me with out it?