Search the web
Sign In
New User? Sign Up
sqlcon
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 1708 - 1737 of 6519   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
1708
hi evrybody, I have a collection of images(.tif files) near about 4,00,000 (four lac). I have a dedicated server to store these Images (sql server) (I know...
Madhu K Nair
madhuotp
Offline Send Email
Nov 2, 2005
8:33 am
1709
upload script for BOM ,interface to Oracle apps 11i immediatedly required pls help mail to manoj_s77@... Best Regards. S.Manoj (Manoj Shrivastava) ...
Manoj Shrivastava
manoj_s77
Offline Send Email
Nov 2, 2005
8:45 am
1710
Hi, I have a lot of Developers constantly creating DB without informing me. Does anyone have a quick and easy method for the Server to send me an E-Mail when...
Harsh Kumar
harshism
Offline Send Email
Nov 2, 2005
1:24 pm
1711
Hi Harsh, As of in 2000 we dont have any inbuilt tools. Third party solutions such as log explorer can send you mails. The recommended solution is to remove...
Santhosh
san_spy
Offline Send Email
Nov 2, 2005
1:33 pm
1712
hi harsh, create login for user which has the permission to access the database only, avoid the permission to create the object, no one create...
muthu narayanan
avm_narayanan
Offline Send Email
Nov 2, 2005
2:58 pm
1713
Hi Harsh, I too recommend resolving this issue by managing permissions. However, If you still look for another solution, You can create an INSERT trigger in...
Senthil Kumar
trsenthilkumar
Offline Send Email
Nov 3, 2005
5:17 am
1714
Senthil wrote ... You cannot create a trigger on system tables or views referencing system tables in SQL server 2000 Regards Roji. P. Thomas ...
Roji. P. Thomas
roji_pt
Offline Send Email
Nov 3, 2005
5:53 am
1715
OOps...My Bad.. Thanks Roji Cheers, Senthil T R "Roji. P. Thomas" <thomasroji@...> wrote: Senthil wrote ... You cannot create a trigger on system...
Senthil Kumar
trsenthilkumar
Offline Send Email
Nov 3, 2005
6:04 am
1716
Hi Group i have data in table depttable id name dept 10 x 1 20 y 1 30 z 1 if select depttable i need out put...
dilip kumar
dilipkumar_a...
Offline Send Email
Nov 3, 2005
12:36 pm
1717
Hi Dilip You can use this query for your particular format. SELECT (SELECT COUNT(*) FROM depttable d2 WHERE d2.name<=d.name) AS sno,id,name,dept FROM depttable...
Phani
alvphaneendra
Offline Send Email
Nov 3, 2005
1:01 pm
1718
Dilip, Try this. SELECT (SELECT COUNT(*) FROM Dept D WHERE D.id <=O.id) as Sno, id, name,dept FROM Dept O ORDER By id Regards Roji. P. Thomas ...
Roji. P. Thomas
roji_pt
Offline Send Email
Nov 3, 2005
1:02 pm
1719
Hi, I am using SQL Mails for my applications. I have configured the outlook MAPI profile in SQL Server and the mails are firing from SQL Server. After the...
sujoy kumar das
sujoykrdas
Offline Send Email
Nov 3, 2005
2:51 pm
1720
If you are having id duplictes you can try this. create table #a (SNo INT IDENTITY(1,1), Column names...............) insert into #a (Column...
Raghava Naraharasetti...
meetrag
Offline Send Email
Nov 3, 2005
8:44 pm
1721
Thanks to all for givining very good Solutions to my problem "Raghava Naraharasetti (Wipro Ltd.)" <v-ragnar@...> wrote: v\:*...
dilip kumar
dilipkumar_a...
Offline Send Email
Nov 4, 2005
4:26 am
1722
Dear All - I wanted to take a moment to let you know that I am leaving my position at ANZ IT. I will be starting a new position soon this month in Hyderabad. I...
Surajit Singha
surajits
Offline Send Email
Nov 4, 2005
5:38 am
1723
The original question was ... Regards Roji. P. Thomas ... From: Raghava Naraharasetti (Wipro Ltd.) To: sqlcon@yahoogroups.com Sent: Friday, November 04, 2005...
Roji. P. Thomas
roji_pt
Offline Send Email
Nov 4, 2005
5:59 am
1724
Phani, This query is not guaranteed to give the SNo in the ascending order without an ORDER BY clause in the outer query. Regards Roji. P. Thomas ...
Roji. P. Thomas
roji_pt
Offline Send Email
Nov 4, 2005
6:00 am
1725
I am trying to send mail using database mail in yukon. but when i am send mail then it's display message in queue. but mail not received............ so ,...
ved_17in
Offline Send Email
Nov 4, 2005
6:59 am
1726
Hi Sanjay, If you configure the OUTLOOK profiler with MAPI, then you cant open the outlook becoz same time sql mail use your PST(out look mail) file. If you...
harsh kumar
harshism
Offline Send Email
Nov 4, 2005
9:27 am
1727
Hi Sujoy am not too sure about using MAPI i allways found it difficult .have you given a try to smtp. http://www.sqldev.net/xp/xpsmtp.htm this is nicely...
VISHNAT
Offline Send Email
Nov 4, 2005
11:19 am
1728
CONTENTS: ** EVENTS ** EUROPE ** ** BOOKS ** ** EVENTS ** USA ** ** CALL FOR SPEAKERS ** EUROPE ** CALL FOR SPEAKERS ** USA ** HUMOUR ** ** OTHER INFORMATION -...
newswire_4_developers
newswire_4_d...
Offline Send Email
Nov 4, 2005
1:31 pm
1729
Hi Harsh, In my mail I stated that the same setting is available in another system and there I am able to open the mailbox. Your replied saying that the...
sujoy kumar das
sujoykrdas
Offline Send Email
Nov 4, 2005
3:37 pm
1730
Hi Sujoy, Can you pls let me know wht is version of outlook on both the servers. The problem u were facing is I am guessing is with Outlook 2002 or 2003 bec...
Ranjan Bhattacharjee
ranjanjoyin
Offline Send Email
Nov 5, 2005
7:18 am
1731
Hi Ranjan, You might be right. On the new server we have Outlook 2003 installed in it. So, you mean to say because of the security reasons I cannot open the...
sujoykrdas
Offline Send Email
Nov 5, 2005
12:51 pm
1732
Hi Sujoy, My best bet for SQL mail is always Outlook 2000 with sp3 on it. Thats the solution I recomend for problem free application otherwise there are lot of...
Ranjan Bhattacharjee
ranjanjoyin
Offline Send Email
Nov 7, 2005
2:31 am
1733
Hi All! but this is very easy in oracle is there any facility like this in sql server??? select rownum sno,id,name,dept from depttable; Shyam Koti ... From:...
shyam koti
shyam_k25
Offline Send Email
Nov 7, 2005
5:56 am
1734
You can do that in SQL Server 2005 in the same way. However, SQL server 2000 doesn't have the functionality. shyam koti <shyam.koti@...> wrote: Hi...
Preethiviraj Kulasing...
preethi_kula...
Offline Send Email
Nov 7, 2005
6:55 am
1735
we do have the IDENTITY function to generate the ids in a select statement but that can be used only with INTO clause in SELECT stmt. -mei Preethiviraj...
Meiyalagan.B
softalagan
Offline Send Email
Nov 7, 2005
7:37 am
1736
Agreed. However, IDENTITY cannot be used to retreive data. It is part of Insert. (either in INSERT or SELECT .. INTO statements) Oracle in SQL Server 2005 has...
Preethiviraj Kulasing...
preethi_kula...
Offline Send Email
Nov 7, 2005
7:47 am
1737
Hi , Can one one please provide me the FAQ on SQL and DB2 Thanks, neeta ... Yahoo! FareChase - Search multiple travel sites in one click....
Neeta Hegde
hi_mamatah@...
Send Email
Nov 7, 2005
8:01 am
Messages 1708 - 1737 of 6519   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help