Well, thanks for the mail, Veer. The things are well missed. I have attended sessions of Tech-Ed 2005, when releases were in Beta. I had a session of SQL high...
for the given month i need all dates of sunday. e.g if this Nov 2005 Then I need a result set 11/05/2005 11/12/2005 11/19/2005 11/26/2005 Thanks in advance ved...
Dear Friends, I had developed a client-server application (VB-SQL 2000). Every month user is giving some new requirements and I have to add new features to the...
SET NOCOUNT ON DECLARE @Cnt INT SELECT @Cnt = 1 WHILE ( @cnt <=31 ) BEGIN IF ( DATENAME (dw, DATEADD(dd,@Cnt, GETDATE()) ) = 'Sunday' AND DATENAME (mm,...
dear friend u can do one thing with the help of sql user u create a user and evry time u check whether it exists or not. keep it secret so no body will come...
Hi Ved, I don't know is there any direct Method to get the solution u need.. Here is one way that I found the solution, Hope this will Helpful to u.. DECLARE...
Hi, Has anyone every installed 32-bit SQL 2000 on 64-bit Windows Server 2003? Does it give any performance benefits by doing so? If yes then do we need to use...
Ravi Singh
rsinghj@...
Jun 2, 2006 8:23 am
3575
Hi Rizwan, Thanks for u'r answer. ya I got my required soln.. Thanks and Regards, Radha. mohd rizwan <mo2riz@...> wrote: Hi Radha, Go with this...... ...
Hope that they are covered in TBD :) list goes long but we need to
understand that DPEs and many MVPS are trying their level best to
accommodate all...
Hi Shyam, This is a different question altogether. I thought you have not designed your database yet. Anyway, If the database is designed so, then i have to ...
Hi Arindam! Thanks. am not designed the database. just am given the example. FYI am using sql server 2000 only. can you help me what are the modifications i...
Hi Arindam! Thanks for the quick reply.. see the sample ER model. ie : if one ageny have 50 "agency specific fields". then for fetching the agency data we need...
Hi All. I need to design a database for a portal, which does service for the families. Earlier there used to be only one agency that used to do this service,...
hi, can anyone help me??? i want to check weather the installed version is sql server2000(64-bit) or sql server 2000(32-bit) ??????????????????????????? plz...
Hi Shyam, If I correctly understand your problem, then it will not be of too much work. The common intake form and HIPAA form will be the same for each agency....
Pankaj, go to the sql server logs and you will find an entry e Microsoft SQL Server 2005 - 9.00.2047.00 (X64) -- the x64 indicates that it is a 64 bit version...
Dear, There is some opening at No.1 IT Company for Hardware Engineers. The nature of work will be hardware maintenance and networking maintenance. 2 years exp....
Hi Arindam. You mean to say maintain agency specific data in a separate table. when ever we create a agency need to create a table based on the selection of...
Hi Shyam, What I was saying is in this way: 1. Agencies may be in different domain, but they will require some common data about the customers. Say for, Each...
Hi All, If you you have some queries about TechEd India 2006 you can visit the TechEd foums @ http://forums.techedindia.com And if you want to know the details...
Hi All, If you you have some queries about TechEd India 2006 you can visit the TechEd foums @ http://forums.techedindia.com And if you want to know the details...
On a more simpler note, run the following query in QA: select @@version ... -- Thanks, Arindam. MCSD.NET [Non-text portions of this message have been removed]...
Sql server 2005 (64-bit) i know... but i am asking aboyut sql server 2000 (64-bit) ... http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/m7folB/TM ... Send...
Hi All, Ask your questions and queries directly from Microsoft SQL Server MVP's on http://forum.sqlknowledge.com 1 Step Free registration, attachements with...
Pankaj, It will the same case in the 2000 too. you will find the x64 in the error log. ... http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/m7folB/TM ... With...
Pankaj, you can use this in SQL server2000 also....or simply use SELECT @@VERSION also.. I think you are not clear in your question..can you explain one more...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
