Hi Team, Wish you all a very happy and propsporous new year. warm wishes Ranga Das. ... __________________________________ Do you Yahoo!? Meet the all-new My...
Thanks & Same to you Srini syam kiran <syamkiran_d@...> wrote: Best Wishes For Happy & Prosperous New Year 2005 Wishing You 1 Year of Happiness 12 Months...
Dear All , We need a DBA for MS-SQL Server 2000 with minimum 2 to 3 year experience in Database Designing and Administration. Location : Chennai Contact :...
Hi anybody has a solution to this problem? I have a table say X with two columns a and b where a is indentity and b is varchar(30). When I insert the first row...
Thanx and Happy new year 2005 to u and all team members ... Thanx and Happy new year 2005 to u and all team members...
sanat kumar mishra
sanatkumar_mishra@...
Jan 5, 2005 11:33 am
698
I am trying to build a rules database for the legacy code we have in my organization. Is there any tool or utility that could parse a SQL proc into SQL...
Hi Biswajit, How are you doing? Happy New year. Identity value is stored in memory. There is a thumb rule in SQL that gyou canft update an identity ...
Hi All, Happy New Year to All, I am having a problem in creating the System DSN. System DSN is created but it is not shown in the List. When i search the DSN...
A CASE STUDY :- Issue a CHECKPOINT Change the REcovery mode to Simple Take a Back up and check its integrity .to be on Safe side... Get the Size of DB T log it...
Hi Mohan, Nice to get your mail.A very happy new year to you too.I was in UK for some time.Now I am back inhyderabad.Thanks for the answer. Regards Biswajit ...
DBCC CHECKDB and Parallelism Recently I was told about a recurring problem some folks are having when they are using DBCC CHECKDB. It seems that they have...
CLR and its relationship to MemToLeave I hear about and see first hand on a regular basis how people are faced with a constant problem of trying to make sense...
Dear - I had a question, Had some one worked in Stripped Backup for SQL Server2K? Could some one focus in-depth into that and let me know how to achieve &...
Adding to Veer's alternate method. Don't delete your transaction log file until you attach your DB back. Next, test whether DB is fully functioning or not. To...
Adding to Veer's alternate method. & Kuldeeps method . 1. Check the path of the Transactional log , from the enterprose manger . 2.Stop the Sql server 3.Open...
Hi Biswajit, I agree with Jagan's points, adding to his inputs. You can also reseed your identity column values. For example in your case as you said that next...
Pals - Have some one figure out my issue ?? Had some one worked in Stripped Backup for SQL Server2K? Could some one focus in-depth into that and let me know...
Ia m forwarding your Query some Experts ...Hope to get a reply ASAP... Regards Veer ... From: Surajit Singha To: sqlcon@yahoogroups.com Sent: 1/7/2005 12:16...
Hi all, I am a new member of this group. I am quite adept at designing the database. But I am an amateur in SQL Server administration. Could you please tell me...
Hi Veer - I have found out excellent way to take Stripped Backup & Restored the Stripped Backup in SQL Server2k. This can be achieved by creating user defined...
VistaDB 2.0 Product Alert January 2005 2004 was a busy year with the initial release of VistaDB 2.0. And as our growing number of users have witnessed first...
VistaDB Alerts
alerts@...
Jan 10, 2005 10:33 am
715
Would be great if you can give a Demo in the Next User GRoup Meet... It would be really a great presentation as we see very few people go through this way of...
Please load again the msdb libery form any software. its a problem of that registry can not retrait out the name of the dsn thanks biswajit Raja Sekhar...
You can operate identity column by this commnad SET IDENTITY_INSERT products ON SET IDENTITY_INSERT products off thanks Biswajit Nanda <telljeet@...>...
Hi Biswajit Das By this you ask the system to stop the calculation of the Identity value . But actually if we can find out how this value is calculated we can...
The main thing it is a case of transaction so you can change the mode like this <Place the record into a temp table> commit when commit phase then transfer...
Yes yuou are right but the question is why the enteries are not getting rolledback ?? Biswajit Das <radhye@...> wrote: The main thing it is a case of...