Hi All, Any idea how to know when (date and time) your database was last updated(means the last entry populated - when and by whome etc.) in sql 2000 and...
Hi All, Please let me know how to start the sql server without tempdb.. any start up options?? Best Regards Shyam Sunder .K Database Administrator. 98851...
Shyam, What do you mean by starting SQL Server with out temp db? tempdb normally is recreated every time. If you mean that you dont want tempdb in a sql...
Hi Shyam, It is not possible to start the sql services without tempdb. If you want you can follow below steps which will help if you have a problem for...
That is for the right candidate JJJ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of Viswanath Subramanian Sent: Wednesday, July 09,...
//That is for the right candidate JJJ // Not for the left candidate ;) I will tell prakash karat then lol  With :))s Santhosh Kumar S.J - MCTS ReadMe @...
Hi Veer, It is very nice.I would like to be part of your work because you subject is itself explaining everything. ... -- Thanks & Regards Shashi Kumar Singh ...
Hi All I got some different kind of problem today. The problem is peaking for stack dump and restarting the SQL service on its own. I tired lot of things but...
NOTE: - You Will Never regret after using this International Phone call service Login into the https://www.stanacard.com to make International Phone...
Hi, I am getting IP as a tel no to my SP. I need to check whether input Tel No follows pattern ^(?:(\([2-9]\d{2}\) ?|[2-9]\d{2}[-]))?[2-9]\d{2}[-]?\d{4}$ If it...
hi i have a job that is sheduled at night 12 pm. it is running fine it will take two hours but after run a maintenance plan which contain cerate reindex...
Check for any kind of blocking. Run the job and run sp_who or who2 Madhu http://madhuottapalam.blogspot.com/ http://experiencing-sql-server-2008.blogspot.com/ ...
Hi All, we have implemeted some security policies and all and we are starting the sql server / agent service with other accounts who don't have local admin...
Hi everyone, Hope this is ok to post here... You can see a list of my groups on Grouply at the link below. Maybe you'll find some you want to join. k Here's...
Hi, I want to know how to return only the upper case of a given string. For a string say, 'This is A Ball' I should get the output as 'TAB' i.e., only the...
Hi DECLARE @inStr VARCHAR(MAX) DECLARE @outStr VARCHAR(MAX) DECLARE @cmpstr CHAR(1) DECLARE @cnt INT SET @cnt = 1 SET @inStr = 'This is A Ball' SET @outStr =...
Kamalakannan.M
kannan.m@...
Jul 29, 2008 1:46 pm
6156
In my company TESCO, a UK based retail gaint in bangalore. We have a couple of openings for SQL Server DBAs both in the senior and junior level (experience in...
I just saw a select query which returns 20 output column and at the end of the query there was an order by clause (ORDER BY 1,2). In the where condition...
ORDER BY 1,2 denotes the first columns in the SELECT list. The result is sorted based on first column first and then on second column. ... From: Techie...
Hi, This denote that order by clause will be applied on selected list from the sequence in which order it is written. For Example:- SELECT Col1,Col2,Col3 FROM...
Dear Tech, You can replace the column name with column number..(ie ORDER BY 1,2 is ORDER BY column1, column) Best Regards Sunil John ... From: Techie...
Dear All, I hv installed SQL 2005 express edition and its working fine. I have little problem in login I can log on with sa and with NT authentication by...
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.
