sqlcon : Messages : 1708-1737 of 6711

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

1708		Madhu K Nair madhuotp	Nov 2, 2005 8:33 am
	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...
1709		Manoj Shrivastava manoj_s77	Nov 2, 2005 8:45 am
	upload script for BOM ,interface to Oracle apps 11i immediatedly required pls help mail to manoj_s77@... Best Regards. S.Manoj (Manoj Shrivastava) ...
1710		Harsh Kumar harshism	Nov 2, 2005 1:24 pm
	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...
1711		Santhosh san_spy	Nov 2, 2005 1:33 pm
	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...
1712		muthu narayanan avm_narayanan	Nov 2, 2005 2:58 pm
	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...
1713		Senthil Kumar trsenthilkumar	Nov 3, 2005 5:17 am
	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...
1714		Roji. P. Thomas roji_pt	Nov 3, 2005 5:53 am
	Senthil wrote ... You cannot create a trigger on system tables or views referencing system tables in SQL server 2000 Regards Roji. P. Thomas ...
1715		Senthil Kumar trsenthilkumar	Nov 3, 2005 6:04 am
	OOps...My Bad.. Thanks Roji Cheers, Senthil T R "Roji. P. Thomas" <thomasroji@...> wrote: Senthil wrote ... You cannot create a trigger on system...
1716		dilip kumar dilipkumar_a...	Nov 3, 2005 12:36 pm
	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...
1717		Phani alvphaneendra	Nov 3, 2005 1:01 pm
	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...
1718		Roji. P. Thomas roji_pt	Nov 3, 2005 1:02 pm
	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 ...
1719		sujoy kumar das sujoykrdas	Nov 3, 2005 2:51 pm
	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...
1720		Raghava Naraharasetti... meetrag	Nov 3, 2005 8:44 pm
	If you are having id duplictes you can try this. create table #a (SNo INT IDENTITY(1,1), Column names...............) insert into #a (Column...
1721		dilip kumar dilipkumar_a...	Nov 4, 2005 4:26 am
	Thanks to all for givining very good Solutions to my problem "Raghava Naraharasetti (Wipro Ltd.)" <v-ragnar@...> wrote: v\:*...
1722		Surajit Singha surajits	Nov 4, 2005 5:38 am
	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...
1723		Roji. P. Thomas roji_pt	Nov 4, 2005 5:59 am
	The original question was ... Regards Roji. P. Thomas ... From: Raghava Naraharasetti (Wipro Ltd.) To: sqlcon@yahoogroups.com Sent: Friday, November 04, 2005...
1724		Roji. P. Thomas roji_pt	Nov 4, 2005 6:00 am
	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 ...
1725		ved_17in	Nov 4, 2005 6:59 am
	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 ,...
1726		harsh kumar harshism	Nov 4, 2005 9:27 am
	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...
1727		VISHNAT	Nov 4, 2005 11:19 am
	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...
1728		newswire_4_developers newswire_4_d...	Nov 4, 2005 1:31 pm
	CONTENTS: EVENTS EUROPE BOOKS EVENTS USA CALL FOR SPEAKERS EUROPE CALL FOR SPEAKERS USA HUMOUR ** OTHER INFORMATION -...
1729		sujoy kumar das sujoykrdas	Nov 4, 2005 3:37 pm
	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...
1730		Ranjan Bhattacharjee ranjanjoyin	Nov 5, 2005 7:18 am
	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...
1731		sujoykrdas	Nov 5, 2005 12:51 pm
	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...
1732		Ranjan Bhattacharjee ranjanjoyin	Nov 7, 2005 2:31 am
	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...
1733		shyam koti shyam_k25	Nov 7, 2005 5:56 am
	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:...
1734		Preethiviraj Kulasing... preethi_kula...	Nov 7, 2005 6:55 am
	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...
1735		Meiyalagan.B softalagan	Nov 7, 2005 7:37 am
	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...
1736		Preethiviraj Kulasing... preethi_kula...	Nov 7, 2005 7:47 am
	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...
1737		Neeta Hegde hi_mamatah@...	Nov 7, 2005 8:01 am
	Hi , Can one one please provide me the FAQ on SQL and DB2 Thanks, neeta ... Yahoo! FareChase - Search multiple travel sites in one click....

Yahoo! Groups

Group Information

Yahoo! Groups Tips

Did you know...

Messages