Hello Everybody, I am looking for the steps and precautions which are need to be taken while changing the default language and dateformat of SQL Server from...
Nice to know about this honest and great feeling; welcome to the band...Srimath First things first decide your role as DBA 1. Project/ Production DBA...
Hi veer, Thank you very much for giving me such valuable response,at present wat i need to do.. shall i prepare for the certification in sql server 2000 or sql...
Hi Group, We have a Parent table and child table Join these two we get multiple records for the single parent How to write an sql function to get all the...
Hi, Welcome to DBA World. Invest money and time to be a good dba. There are so many good website you can find a lot of free stuff. See CBTS and AppDev ...
Hi, Try this ....... SELECT TOP 1 @EmpNameID=EmpNameI D FROM dbo.EmployeeNames WHERE (EmpFirstName = @EmpFirstName OR @EmpFirstName IS NULL) AND (EmpLastName =...
To Become a great Database Adminstrator open book online. and read Sql server artitecture fully.Try to understand every beat. After complete the artitecture...
Hi, CREATE FUNCTION dbo.ChildData (@ParentID ...) Returns VarChar(8000) AS Begin Declare @strChildData As VarChar(8000) Set @strChildData = '' Select...
sp_configure 'default language','12' then use "reconfigure" to activate the new configuration. The language id can be obtained from : select langid,alias from...
Ashish
world.ashish@...
Sep 2, 2006 1:03 am
4204
Hi Virender, Here is how it is possible :) better late thasn never :) ... create table #t( eid INT, NAMES varchar(10))--creating a temp table with the same...
Hi Team, Had a small doubt on Backup Topic. I have a native backup(.BAK) for a userdatabase saved in some location. Is there any method or commnads through...
RESTORE HEADERONLY Retrieves all the backup header information for all backup sets on a particular backup device. The result from executing RESTORE HEADERONLY...
Regards, Venkatesan Moderator for : Venkat_IndianIT_JobsCareer@yahoogroups.com jobs_mania@yahoogroups.com ... Talk is cheap. Use Yahoo! Messenger to make...
Dear all, Can any one help me in converting the unicode values to normal text when we do a query in QA. please guide me with any stored procedure or function....
Hi , I have a new box at my place with windows 2003 enterprise Edt (64 bit ) with sp1 installed and it has 17 GB of Memory . I have installed Sql 2000 ( 32...
Can any one tell me the exact steps which are need to be followed to change the sql server language from English (MDY) to CZECH (DMY). Thanks in advance ...
hi, As already posted.... http://groups.yahoo.com/group/sqlcon/message/4203 am i wrong somewhere? What version of SQL Server u r on? sql2000 or sql2005? And...
Ashish
world.ashish@...
Sep 5, 2006 7:21 am
4212
Absolutely right. Thanks a lot Ashish. Regards Virender Jain Ashish <world.ashish@...> wrote: hi, As already posted.... ...
Thanks Ramesh Karnati, This is exactly what I was looking for. Kudos to you. Thanks, Techie. Ramesh Karnati <karnati_in@...> wrote: Hi, Try this ....... ...
Hi, I need a logic to write this query. Can this be done with select in SQL. /**************************/ create table generationlevel (Father varchar(20), ...
are yuo sure that you want the schema to be the same? you are putting the siblings also, which may fall in the same level in the tree structure, into the...
You can do something like: Set nocount on declare @Child varchar(20) set @Child='KareenaKapoor' declare @parent varchar(20) declare @towrite varchar(100) ...
Yes, you have to enable AWE on SQL Server 2000 (32 bit) as it works in WOW (Windows over Windows) mode on a 64 bit OS. There is no need of PAE switch for OS as...
Nitin, You can check Microsoft free E-learning courses on various sections of SQL Server 2005. Please visit https://www.microsoftelearning.com/sqlserver2005/. ...
Yeah, SQL ELearning courses are the another best way for getting knowledge on MS SQL Server 2005 Admin skills. http://www.sqlknowledge.com/index.php? ...
Primary responsibilities include providing technical and creative solutions for service delivery by visiting customer problems sites, while ensuring customer...