B.NET(bdotnet.in)

Hi, The code is updating the four tables in read uncommitted transaction . It is taking 10 mins to update to the tables. When it is updating , the select statement is not retrieving the data from one of the table. .As it is read uncommitted transaction , the select statement should return the tables...

This is a clear connectivity issue from RS. What authentication are you using? Is it SQL or windows based? What is the setting on your Data Source on RS project? Is it a shared conneciton? What are its properties ???

Hello Kiran .. Its a tough task to estimate a hardware for your SQL Server (for that matter any application) empirically before you have it loaded to its full traffic. Here are some tips and hope it helps. - Purchase a medium configuration server ( unless your database is going to take 1000 Trans per...

I just uploaded a new article over my site on Data Archiving . Feel free to pass your comments :) ...

I'd created an application which does this. Joe, if you have time, then create an application which does this. It would be interesting. Select * from Sysobjects where Xtype = 'p' gives you list of procedures in the current database. Get this and iterate through each one. Issue sp_helptext...

Hi Jayant, Thank you so much for ur quick response on the issue....jayant i have done d same but as it is a set of a backup files so it is giving an error that too many backup devices are specified ...only 64 are allowed for king ur information i m using a SQL Express edition ..our company having a our...

I have a Backup set which includes two backup files in it ...when i mtrying to restore it, it is showing an error then too mank backup devices are specified ...only 64 are allowed ...please help me regarding this issue

Dear sir, Fist of all Thanks quick response, But that link was not downloading properly...

Hi everyone, 1)Is there any tool is present which is useful for running all .sql script file(tables) in to a batch file in other database ?eg. Suppose, I maintain each objects(Tables) script in .sql format ,but I want to run it in a single batch processing , so, how i will do it? I am using sqlserver2005...