SQL Server 2000 Interview Questions 


 

SQL Server 2000 Interview Questions

Specifically, what should the Carters cover in their new employee induction program and how should
they covey this information?
 

how i will get small small t-sql quaris  with answer any site or book can u refer me.

If I run any CDO tasks on one system, I get errors that I cannot connect to the outgoing SMTP server. But if I run the exact same command on another system, the task executes flawlessly. I recently re-installed SQL Enterprise Manager, but no luck. Is there something with my authentication or could it be an old DLL file somewhere? The exact error is:
Error Desc: Error Code: 0
Error Source: CDO.Message.1
Error Desc: The Transport Failed to connect to the server.
Error on line 1
I am 9 years experienced Systems admin also managing databases for different client/server based applications. Recently I've done MCDBA and my company needs more proficient in MS SQL 2000. Though I am already doing DBA job but want to be specific in Database Admintration and want to switch or promote to Datbase Adminitrator Designation instead of Systems Admin. Can you please help me what exactly should I concentrate more to have my goal achieve which let me have my goal achieved in job prospect and I could also be more relieable person for my company. I would expect answer most likely in which kind of duties and what type responsibilite I need to take care.
Experts/Expereinced opinion will be great for career choice...Thanks A lot..
Complete setup is 2 servers one running 2003 one running 2000 & sql/iis plus three desktops and one laptop all wireless, I'd rather have a client on the workstations rather than put everything through one of the servers
Can I get IT work form foreign Company?
What steps must I follow to reach there?


I am Software Engineering from India.
I have 3 years of Experience.
I have experience of VB, VBS, SQL Server 2000 and MS.NET.
I own 40 Windows 2000 User CALs. I want to upgrade to 2003 SBS and want to know if I can bring up existing CALs with me. I'm having the hardest time determining if my existing CALs will work or if there is a path that I can upgrade them to SBS CALs. I have read that SBS CALs are different because SBS includes not only Windows 2003 Server, but also Exchange, SQL and ISA Server.

Thanks for the help!
how will i know what server for an OS am i in like microsoft SQL 2000 or microsoft server 2003. also can i use any server for vista. sorry for being a noob. help pls.
I developed a website with asp.net 2 and SQL Server 2005 (express edition).
now , I want upload my website on the my server.
my server support asp.net 2 and sqlserver 2000
I want know is there any problem to working my website on the server
I'm trying to learn English :-)
i want a coding of jsp to play a songs using data base sql 2000 server
can somebody explain to me how to get a database dump from a database server (MS SQL 2000 server). Primarily i wanna get an existing database file from this server and put it down in my workstation. clear instruction please
I wana download the microsoft press Sql server 2000 ebook free
I'm using VB6 and ASP 3 with SQL Server 2000 - trying to get xml but when I run code I'm getting "The Load Method for the DOM Failed" I checked all my database connections are correct all refrences seems ok my code is following


Dim objXMLDoc As MSXML2.DOMDocument40
Set objXMLDoc = New MSXML2.DOMDocument40
objXMLDoc.async = False

'Load the location of the template
objXMLDoc.Load (m_sXMLPath &
XslTmpltUsgSprocNstd)


Thanks
Raza Shah
iam making a college project using asp.net & vb.net & sql server 2000 as database....
pls tell me in detail how to create a sessions for each user that exists in database...
i have created a regsitration form & its working where a user can register himself on the website...
now i want this user to enter his/her uers id & password & when he/she click on the LOGIN the session begins until he cliks on the LOG OFF button & also time out for these users if they exceeds the time...
pls tell in detail & more easily to grab it easily....
thank you...
which course should i go for specialization in database. i have just completed my MCA and working on Sql server 2000 ..
1234528Showing 1 to 15 of 410