sqlcon : Messages : 1708-1737 of 6519

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	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	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	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	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	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	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	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	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...	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	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	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	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	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...	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	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	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	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	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	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	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...	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	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	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	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	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	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...	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	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...	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@...	Nov 7, 2005 8:01 am

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages