Yes i had used Database context

Hi Igor Micev,

I had run the script, it does not give any output

AlertsSize Bytes Per Row

dbo.IRST6553.6

dbo.Ulog5461.33333

dbo.VAE8192

dbo.IRR8192

dbo.Rdata8192

dbo.InfoData81920

dbo.IRTrans49152

dbo.IRC16384

dbo.Transactions65536

dbo.ARPin16384

dbo.IRRPT32768

Total Bytes298734.9333

Above is the details size in bytes for per transactions which and total size comes approx - 300 KB, Yes Every table has clustered and Index...

It doesn't give option to run, it only say's search online solution and close, and if I click on close, setup get exited.

Thanks sharky,

Hi Jeff, I am creating an application which creates the database using script and application gets installed in program files, which contains application install log file, I want to...

Hi Gianluca,

It is updating all the records which are repeadted i wont need all the records to be updated. i need any one record to updated from the repeated...

Hi Gianluca,

Thx but the union will work if i am having only limited records but what if i am having 1 lakh records or more than that. i mean to...

I had got a project in which there is a phyical hardware to which the ip wil be assigned and it will communicating with server where sql in installed and...

Thx,

But its not hardcoded its an value which is stored in variable which is having a datatype as datetime. and after going through certain select and execution stored procedure.And i...

Thx Lutz,

I will explain the complete scenario i am having table A with the

columns called Complaint No,call,Description, Contact no where

complaint no is auto generate

Call is user input column...

Its a simple insert statement Its not possible for me to insert inverted commas for each statement, you can go through the sample data

common understanding is i am having data...

I had provided the sample data only

yeah i agree that this is sql2k5 forum

but thought can get some clue for sql2k but didnt fine even after puttin parenthises

hi Adi,

when i run your code

select * from test where charindex(char(13)+char(10), vc) = 0

it gives me only one record in output but wherein it should be three and

When...

Hi Vladan,

When i run this code is sql 2000 i get an error of

Server: Msg 195, Level 15, State 10, Line 27

'ROW_NUMBER' is not a recognized function name. but it...