Your Server

SQL server? I am working on two SQL servers at work... testing them out. One is SQL 2005 standard and the other being 2005 SQL express. I am trying to use import/export utility on the standard edition to move a database to the express addition. I was getting errors at first but then researched and troubleshooted to find that on the express server tcp/ip and pipe naming was disabled. I stopped and restarted the service. Now when i try the import/export on the standard server it does not list the express server to choose as it did before. It is no longer on the list of servers....any suggestions???

SQL Server? Hi i am doing insert statement in ui for updating the values in SQL Server. But most of them are not doing like this, they are using stored procedures y they are using Stored procedures for inserting datas.

sql server? what is a sql server what does it do

How to connect sql server 2005 by using windows authentication from a client computer to a server? I am a beginner of sql. I try to connect from my labtop (XP home) to my office server (server 2003) to access the database in the sql express. I am using Server Management Studio Express in my laptop, and using windows authentication, and connect to another computer (server) and access the server's sql server. (by the way, where to put username and password?) But it always failed and said i have no premission to access... why?

SQL Server: How do I determine the security group through which a user is granted permission? In SQL Server, a user in my domain is able to access a database because they are a member of a particular security group. How can I determine the security group that this user is a member of and therefore is gaining access?

How do I set up SQL Server so I can access it from another computer over a network? I want to be able to access my SQL Server on my computer from another computer on the network. Both computers have SQL Server installed now I just need to know how to configure the Host system and what ports I need to open on the firewall for example. Thanks.

What is the difference between SQL Server and MySQL? I understand that MySQL is used to manage your website database can SQL Server do the same thing, if so why are companies such as Yahoo and Google using MySQL. What is Microsoft SQL Server's and MySQL's main purpose

Is there any hands on training for SQL Server? I am planning to learn SQL Server. I was wondering if there is any website or school (in Northern California) for learning SQL Server. By the way, I already know the basic of SQL using MySQL, but I find it difficult to install SQL Server(the free version).So, I am thinking to take one of those classes that you do not need to install anything.

How to copy a database from one SQL Server to Another? Hi all, I need to copy the existing database from one SQL Server (System1) to another SQL Server in System 2. How do i do it??? Any howto guide would be preferred. Thanks for your help. Please provide a Step by step guide or a link to the same.

How can visual basic application connect to SQL server 2005 database over the internet? Hi Experts, I'm developing a visual basic application that uses a SQL server as it's database. I know that the vb application can connect to the SQL server over (LAN)local area network, is there a way for the app to connect to the SQL server over WAN(internet) Thanks a lot

Is there a migration guide for separating the SQL Server from a Microsoft Sharepoint 2007 server? We have a Microsoft Sharepoint 2007 Standard Server installed together with the Microsoft SQL Server 2005 on the same machine. Right now, we already outgrow the server and need to move the SQL Server out to a separate machine, is there a best practices and/or migration guide that someone has written that illustrates the detailed steps to go about doing so. For example, can the configuration database and the content database move together? Or do we need to have the configuration database still in the same server as Sharepoint 2007?

What is the advantage of installing SQL Server Express on a Virtual Machine? I'm in a SQL class where we're using SQL Server Express 2005. In our classroom it's installed on a "virtual machine". I was considering installing SQL on my home system for homework projects, but am concerned about it consuming system memory. Is this why some people run only on the virtual machine?

Is it slower to close and open a SQL Server connection instead of keeping it open? Hi! I'm developing an application with VB.NET which will be connecting to a SQL Server database, no other application will be connected to the database so I've got the following question: How will it be faster: closing and opening a connection when needed or keeping the connection open? I know that when many users connect the first option is better but since It will be only one user, which option is the best one? Thanks and blessings since now!

How to configure Microsoft sql server 2000 remote connection? I have 2 computer both installed with Microsoft sql server.How can I configure the remote connection?so that I can retrieve the data from 1 computer to other.

How do I add a user to SQL Server 2005 so they can connect over LAN? How do I add my laptop to connect to my sql server on my desktop? Both machines have the same version of SQL Server and they are already networked up for file sharing, RDP etc. Do I need to edit anything within the network configuration in the configuration manager? I have tried to search for my desktop pc name when trying to add a user but nothing comes up. Thanks.

Sql Server............? Any body knows any good place to learn Sql erver admin and development, (T-SQL,Monitering,Performance).Any institue in Nj,NY will be great.I prefer go for classes instead of Online. :)

How important is it to know oracle and MS SQL Server? I'm a Information System major and want to know if it's important to know Oracle and MS SQL Server ? If so, why and what books can u suggest? Are they easy to learn?

Whats the difference between Server and SQL Server? Theres server 2003 and 2008 And Theres sql server 2005 and 2008 Whats the difference between sql and just server? Are they completely different? or business can choose to use either one of them?

How can I configure SQL Server 2008 Express so it only accepts local connections? i just installed SQL Server 2008 Express Edition. I want to configure it so that only my local computer can connect to it. I already deselected "Allow remote connections to this server" but is there anything else I need to do? Also, there are about 9 different logins set up on it. Can I remove any of these and only keep my local account login? ThankS!

How do I get SQL Server 2005 to save output as ASCII text not Unicode? I am running a standard SQL Script, but when I save the results set, it is in Unicode which is breaking our import software. It doesn't like the Hex characters. How do you set SQL Server to save as plain text???

How can I let other computers to access my SQL SERVER 2000 through internet? How can I let other computers to access my SQL SERVER 2000 through internet? I have already a StaticIP. Please let me know if there is any setting for that, in SQL-Server 2000? Thanks

How to upload video files to sql server 2005 using vb? Can any one help me? How to upload video files to sql server 2005 using vb? Can any one help me?

How do I work out what SQL server phpBB 3 is running on? Hey all, This may be a silly question with an obvious answer but I can't work it out. How do I find out what server my phpbb3 forum is running on, all my sql servers show that there is a forum assigned to them but doesn't say which one! Is there anything in the admin panel that will tell me the exact server it on? Hope you can help! Tom. :)

What are the features not available in SQL server 2005 express edition compared to its Professional edition ? What are the features not available in SQL server 2005 express edition compared to its Professional edition ? can i use Express edition in a LAN environment ?

How do you create a presentation that gets data from a SQL server? I would like to create a presentation that gets data such as news or team scores from an sql server, but I have no clue how I would do this, any ideas?

How to ship sql server db file along with software product? How to ship sql server db file along with software product? Or i have to give the link of server connection in the software product?

Connecting a SQL server to a webserver and internet using 2 cards? Hi, I need to do the following Webserver Card1 - Internet connection and local network (domain services) Card2 - Direct to SQL server SQL server Card1 - Internet connection and local network Card 2 - Direct to Web server Basically all DB traffic between web and SQL server should be using Card 2 on both boxes and all Web traffic should use Card1.

How to pass array to SQL Server Stored procedure as a parameter? I want to pass array as a parameter to stored procedure in SQL server 2005

What is the difference between a Report and a View in MS SQL Server? Aside from the obvious configuration/design, what is really the difference between a Report and a View in SQL Server. I understand that a Report is useful when presenting information outside the the database (business). I also understand that a View is useful for reference within the database (business). But, what is the primary difference... content? Thanks.

What are advantages and disadvantages of using the Microsoft SQL server? Please help me with this, I need to know the advantages and disadvantages of using the Microsoft SQL server with comparison with other available database managing systems. Thanks!

How to Connect Sql Database without Installing Sql Server? We are using Sql Server database as our project back end and VB 2008 as Front End. Now we want to deploy this project to client side. But we dont want to install Sql server at client side. So how can we access Sql Server database without Installing Sql Server ( Like MS ACCESS MDB ). We are using Visual basic 2008 for Our Project.

How can I tell if the SQL server on my computer is patched or unpatched? I have a windows xp media center edition 2002 with a service pack 2 on a HP pavilion, I was wondering how can you tell if the sql server is patched or not? Any help would be appreciated.

What should it cost to set up an SQL server (apart from the hardware costs of the server itself)? I've heard something about Microsoft giving SQL server licenses away free now. This doesn't sound like Bill Gates. If I have a server, and want to set up an SQL server running a database of less than 5000 records, how much would it cost?

What is the difference between MySQL or SQL Server? when people refer to MySQL or SQL Server, i assume they are talking about the same thing!! But I guess they are two different things! How do they differ from each other? No joke answers please.

I get a compatiblity issue on installing sql server dev edition on i3 process with win 7? I was trying to install SQL Server 2005 developer edition on i3 processor with windows 7 os. In the middle of the installation process the following error will come."the current processor is not compatible to install SQL Server". What may be the solution for this problem? Thanks!

How do I install a database to a SQL server? I have a baseball database I downloaded and would like to install it to my SQL server using PHP. What is the code to accomplish this?

How to create a Data Management tool using SQL Server? How and where can i download SQL Server free? I Need to create a Database for maintaining some datas and to easy access of Reports?

How can we trace the sql communication between an applications and Oracle server? (Same as SQL Server Profiler) Any suggestion would be highly appreciated.

What is the best book for studying MCTS SQL Server? Hi, Just wondered if there was a definitive 'best' book for MCTS SQL Server. I remember when I did some comptia certifications, the Mike Myers books were generally accepted to be the best books to get. Any opinons?

How do you populate a Combo Box in excel 2010 with the results of a SQL Server Query using vba? How do you populate a Combo Box in excel 2010 with the results of a SQL Server Query using vba?

Does MS SQL Server need to be running on my XP home computer ? I see a MS SQL Server icon in my toolbar at the lower right of my monitor screen. I'm thinking all the icons there represent programs that were opened when I started the computer, and are currently running. What is MS SQL Server doing for the computer, if anything, and does it need to be running all the time ? Running under Win XP on a Dell computer.

How can I convert an existing MS Access database to an existing SQL Server Compact Edition database? I created an application powered by MS Access with two tables and about 30 rows of records. I eventually re-worked the C# application to run off SQL Server CE for more record space and security. How can I migrate that data to the new database?

How to connect to a microsoft sql server if you are using asp? I am teaching myself asp programming. I now want to ask the codes man can incorporate into his asp codes so that his sql server can be seen on the net. thank you.

How to fix sql server 2008 cluster failed problem on vista? I'm trying to install SQL Server Express Advanced 2008 single Node for first time on VISTA 64 bit, it fails because of Cluster failed. Help me to fix it.

How does Visual Basic work with SQL Server? I am wondering how Visual Basic works with SQL Server. I know very little about both programs, other then SQL is a relational database. I mostly know PC hardware, Windows (including server 2003/2008) and a bit of networks. Would any one be able to explain the two programs and how they work together?

From whom would I purchase a list of companies in my area that have purchased Microsoft SQL Server? I would like to do a select post card mailing to companies that use SQL Server. I am a contract employee specializing in assisting users with SQL Server projects and I looking for additional clients in the south-east suburbs of Columbus, OH. I would like to do a post card mailing to find new clients.

How to retrieve the first five rows from the database in SQL Server? I wonder how to retrieve only the first or the top five rows data from the database in sql server? I need the SQL command for this.. thanks!

What is an SQL Server? Can I run a web server using it? If so, is there a better alternative? I am trying to start a web server. I know i can use apache, but i heard about Microsoft SQL server, and I would like to know more. Links would be appreciated.

How do I access data from a SQL server? I'm not familiar with SQL servers. I'm working with a program that stores its data on an SQL server. The program basically stores user information, name, age, address, email, etc. What kind of program do I need to use to access the data? I'd like to be able to run queries so I can print out lists. For example, a list of user names and their email addresses.

How do I get data out of sql server into an XSD format that was given to me? I received an XSD format for XML data that I am supposed to submit. I have all the necessary data in the database (SQL Server 2000), but I am unsure on how to retrieve it in the provided format. Can anyone point me in the right direction? I would greatly appreciate any help!

Can you run MySQL and SQL server from the same PC without problems? Are they compatible? I want to run a MySQL server and a microsoft SQL server one the same computer. Will I encounter problems doing this? Are they compatible?

What are the best books or resources to learn SQL using MS SQL Server 2005? I am a newbee in this area and I recently joined a Database management class where in I am using MS SQL Server 2005. I couldn't find good resources where in I can find more examples and better explanations. Please suggest me some books or online resources for basic and advanced SQL using MS SQL Server 2005. Thanks in advance.

What are the SQL SERVER files needed to Execute a Database Application in vb.net? I want to ask about the SQL SERVER prerequisites which should be included in the setup of a application made in vb.net.The application uses the database in sql server 2005 to store the data.Is it possible to add the sql server files needed for the application to run without installing the sql server

How long does it take to be good at Sql Server 2005? Professionally how long does it take to become an entry level sql server 2005 developer? Any .Net language combination that you guys might suggest? I am not talking about about DBA as I know that it takes years to achieve this particular goals. Any suggestions will be greatly appreciated. Thanks for your time.

How do I look up error reference numbers in SQL Server? I got an error reference number in IE when accessing an internal site of my company. Any tips on how to look up this error in SQL Server Management Studio?

How to handle the exceptions in SQL Server 2000? Hi all! I'm a beginner for SQL Server 2000. But, I've learned exception handling in Oracle 8i. I know the meaning of the exception handling but I can't able to write a programs in SQL Server 2000. So please tell me the simple program for exception handling. And tell me, what are all the keywords or functions to be involved.

With SQL Server 2005 is it possible to view how many users are actually using the database? I have developed a database in SQL Server 2005, and connectivity is via Access 2003. We have over 100 users and need to determine how many users are using the database each day, is this possible?

What is the Microsoft SQL server 2005 and do I really need it? I have had The microsoft SQL server 2005 for a while on my computer and I want to uninstall it to free up some space but I don't know if I should. I can't remember where I got it and I don't really know what it does. Can someone please help me. THANX!!

Is it possible to install sql server 2000 in windows xp? I am trying to install sql server 2000 standard Edition in windows xp. When i am install i receiving an error msg " microsoft sql server 2000 standard Edition server component is not support on this OS.Only client component will be available for installation."

what all the modules to be installed to connect sql server 2005 in perl? From My perl program I want to retrieve data from SQL server 2005, do i need to install any plugins for this?

To learn SQL server 2005 in coimbatore city. which is the best computer institute? i have completed MCA in coimbatore thru distance education. now i came to know that the plenty oppurtunities are there for SQL Server. so i would like to know the details of institute, place, fees.

How do i grant a user permission to view only one view or table in sql server 2008? How do i grant a user permission to view only one view or table in sql server 2008 in a database.. i thought we should use securables but im not able to see tables or views to add... Please help

sql server? does anyone know which website that i can visit to get everythiing about sql server from novice user until professional level.. and also website for java regarding how to program it to make report; i mean in a system which using java,how to produce monthly report, annual report and etc. please help me....thanks a lot.

what is a good book to learn writing SQL for Microsoft SQL Server Management Studio 2008? I am trying to learn how to write SQL in Microsoft SQL Server 2008 but the only thing I am studying is writing SQL in Oracle Database. I am sure there are lots of different codes between these two. Can you help me finding any good books that you learn in Microsoft SQL Server 2008 ? Thank you

Is the Microsoft SQL Server Native Client program thing important? I am going to upgrade to windows 7 and the windows 7 upgrade adviser said that Microsoft SQL Server Native Client may experience problems running on windows 7 and im not sure if it is an important program or not does anyone know if it is important?

sql server? my sql server says not connected how do i connect p.s i am a beginner please be specific thank you

No components of sql server 2005 were found on your computer? I am trying to configure Surface Area configuration of Sql Server 2005 and been unable to do it. it is showing the above error message.Please me a solution. Thankyou Guys.

How can i connect my SQL Server database in Adobe Dreamweaver CS4.? I was able to connect my website but i don't know how can i connect my SQL server database in Adobe Dreamweaver CS4.Please tell me instructions how to do it.

Can I make Oracle to automatically trigger SQL Server to run an sql command? I need to trigger SQL Server to start running(populates a table), whenever something has changed on Oracle on a table. Does anyone know how to do this? Plz give sql code if possible.

How to insert a text between the required row in SQL SERVER? Hi, It is possible to insert a text to a table between two entries with out changing its id..... Ex:- Uid text 1 aaaaa 2 bbbbb so is it possible to insert a text between the two as Uid text 1 aaaaa 3 ccccc 4 ddddd 2 bbbbb in sql server by using procedures and queries...... Pls help me to solve the problem.

Is there a way to remove all the spaces at the end of a SQL Server field? I imported some data into SQL server and at the end of the data in a column it added extra spaces. (Each row has a different amount of spaces). Is there a query to delete all those spaces at the end of the field?

HOw to populate a drop-down box from sql server using asp script for dynamic web page? I am creating a dynamic web page for that I need to populate a drop-down box from a table in sql server. Can somebody please write the code in asp script?

How to attach Database to SQL Server 2000 remotely? Hello! I have SQL Server 2000 installed on one of the node at my office network running Windows XP Professional. I want to attach a database to it from another terminal over the network. Can someone tell me the exact process for the same?

From where i can download sql server 2005 video tutorials? I Want to download good quality Video tutorials related to SQL Server 2005.Free.Plz if any one know than reply me.

Is it worth purchasing a SQL Server management tool or do I use the tools provided by SQL Server? Is it worth purchasing a 3rd party SQL Server management tool or do I use the tools provided by Microsoft SQL Server? Do you have any 3rd party software system suggestions?

How do you save SQL results as Excel using SQL Server management studio? How do you save SQL query results as an Excel spreadsheet using SQL Server management studio?

In sql server 2005 how the arguments are passed to functions? Hi I am new to SQL Server 2005. I have just learnt building functions. While learning I got a doubt how the arguments are passed to the functions. Is it by Call By Value method or by Call By Reference method? Thanks in advance :)

How do I create a SQL Server on my laptop? I just installed SQL Server 2008 but there is no server to connect to?

How to access a SQL server Database and its tables thru internet? How to access a SQL server Database and its tables thru internet How to access SQL Database and its Tables through internet remote SQL server Database like intranet.

Where do you look in your computer to find what sql server you are running? Trying to install a program that requires the SQL server with a service pack 3. I am sure I need to update this with Microsoft, but how do I know what I have already?

New pc came with MS SQL Server program. What does this do (or what is it used for) and can I get rid of it? I see ms sql server 2005, native client, setup support files, server vss writer. Can I uninstall these and what are they used for? Thanks.

How to get the application's name in SQL Server 2005? Hi! I need some help with SQL Server 2005. I've got a database that works with some applications, in other words, a user with a Java or another application can update, delete or insert in its tables. I want to make a trigger so when a user performs one of those commands, I can get the application's name. Is there a way to do this?

Do I actually need Microsoft SQL server 2005 installed on my PC? I have a laptop and every bit of memory and battery power count when I'm away from home. I am running Vista Ultimate 64x. Do i actually need Microsoft SQL server 2005 running on my machine?

How do i connect to server on Microsoft SQL Server 2005? I have just installed Microsoft SQL Server 2005. When I start the Server Management Studio, it displays a "Connect to Server" dialog box. I have tried my best to connect to the serevr, but i dont know which server the programming is asking to connect to. I am assuming it's a local server that is set up on my machine since the setup required me to install Windows IIS, but i have no idea how to connect to it. I tried using all the options available at the "Connect to Server" dialog, but i am still unable to connect to a server. What should I do? I am frustrated and i need to use this software pronto, since i have assignments and deadlines to complete for my Enterprise Computing course.

What kind of sites can we start with a SQL server ? I have recently set up an apache server with php and a sql server. I did this because I was bored and it kept me occupied. Now it's set up and i got nothing to do. What can we start with a sql server ? For example an image hosting site, music hosting site, etc.

what is the right order to install SQl server and visual studio? i want to know, wheter it is necessary to install sql server 2008 before installing visual studio or it will work even if i install after intalling visual studio? Please help i am trying this for 10th time becoz i there was problem of connection with sql serer 200, 2005 was installing always with errors on my laptop. now i want to give my best shot... thanx for help

what is the best RAID type to use for SQL server? I am planning to setup 2 SQL server and cluster both servers, i wanted to know which RAID type can maximize the the ability of both clustered server with regards to data accessing and i want to make sure that the data will be safe in case any trouble arise

is it possible to install or run a software which consists databases with out installing sql server? like,in my pc .net framework is installed.now i got a software which was developed by c# and also contains sql query (for ms sql server).now could i run this software in my pc without installing ms sql server but only with .net famework.if not, what else i have to do to run this software

How to replicate Microsoft sql server 2000 database to remote server? How to replicate Microsoft sql server 2000 database to remote server for high availability and failover?

what salary should I expect in CA as a SQL Server DBA? I am being offered a position as a SQl server DBA at a firm in poway CA , they are offering me a package of 65k / annum to start with , I have about 2 yrs of experience as a DBA , what do you guys think about the pay , is it less since the expenses in CA are way too much as compared to NJ where I am staying ?

How do I connect remotely to my SQL Server 2005? The SQl Server 2005 is in the office. From y home how do I connect using the sql server 2005 manager studio? No IP is asked except the server name. I don't see how this is possible?

How to learn Microsoft SQL Server 2005(or Express Edition)? I already know SQL using MySQL. Now, I am planning to learn Microsoft SQL Server 2005 which has more demand. Can you recommend a good book or website?. By the way, do you know how to get Microsoft SQL Server 2005 for free?

What is the most in demand SQL Server 2005 or Oracle? Wonder if I should learn SQL Server 05 or Oracle/ Or both? I am giving myself 1 year to learn it. How to brake into that field? I read that nobody is hiring a DBA without experience.

How to identify a unique row in SQL-Server if there are 2 identical rows? Hi I am working in SQL Server. I have a table called TblEmp with 1 column EmpName in it. There are two rows with the same name. Is there any query thru which i can identify the unique row. I know in oracle it is Row_Num. Kindly let me know if there is any solution to this. Thanks Vikram.

How do I transfer flat file to SQL Server? Is there a step by step method? See, I'm a novice to SQL Server, we were trying to test the SSIS functionality available in SQL 2005, particularly in server management studio, i need help..anyone who could help me..thanks!

Is 47 too old to be a SQL a Server Database Administrator? I will finish my MCTS. Also should I take the SQL Server Developer or Administrator as certification? I can't afford to get into the wrong path as I am becoming old.Thx.

How Can I Find My SQL Server ? I need to install a program on my computer, but their is a slight problem. But they say I need to select a SQL server Instance Please help me.

How to remove a sql server 2005 database log file that is more than 7GB ? Database file size is 50MB. I tried to shrinkdatabase and it's log file but no success. I vad a solution In sql server 2000, I detached the database and remove the log file and when i tried to attach it again sql server 2000 made a new log filewith 1MB size. but sql server 2005 doesn't allow this way. help please

How can I script a SQL Server 2005 database in order to insert the data into another table? I am unable to attach a MDF to my remote SQL server database. I need a method of scripting it so that I can collect all the rows and data and then run that script remotely to insert each row. Any ideas? Please help. Thanks!

How do I fix this error in SQL Server 2005 express: CREATE DATABASE permission denied in database 'master'? I'm running vista and I have Visual Studio 2008 installed. In the process of installing sql server 2005 sp2, the installation said that I already the application installed, so I canceled the install. I then installed management studio with no problems. When I tried to create a new database, I received the above mentioned error. Help!

are there any keyloggers out there that can send the information to an SQL server? Also writing a script? I would like to create a script that when a USB thumb drive is plugged in, it automatically installs a preconfigured keylogger to send its content to an SQL server. Does anyone know of a program that supports SQL? Also, i have no clue where to begin for an auto-install script. Thanks!

How can i build Database including SQL Server? How can i build Database including SQL Server seperately for vb.net application. I dont want customer to use their SQL Server for my product. because it could have their own login. where i wants application to install without asking any configuration for SQL I have seen Microsoft Retail Management system (POS Software) that the samething i want to do.

How can I create a database in SQL server 2005? How to create a database in SQL server 2005 and connect it with a XML web service. How to do. Plzzzzzz Help me.

Where can I find the interface for SQL Server 2005? Does SQL Server 2005 have a neat interface similar to Oracle's 10g XE? If so how do I access it, where can I find it? Is Visual Studio Database Projects it? I know I have SQL Server 2005 installed because it came with Visual Studio 2005 Professional.

How to link a data from two different Microsoft SQL Server? We have two servers, both have a MS Sql server installed, I need to make a view from each other database tables, Is there someone knows how to do it? What is the script?

Can anybody tell me the steps to install SQL Server? I have installed Visual Studio 2005 and want to connect it with Microsoft SQL Server 2005..so pls tell me the steps to install and configure it. I have the installation files. If you pls tell me the procedure to connect VS 2005 with Oracle as the backend database software then it will be great. Thanks.

How can PHP be used with SQL Server 2005? I know PHP can be of some use in SQL Server 2005.I want to know how can one use PHP in conjuction with SQL Server 2005.

Where can I download Northwind Database sample for SQL Server 2005? I have Visual Studio 2008 installed together with SQL Server Compact edition but there is no database installed. What will I do? Where to get a copy of sample database and how to create my own database? Please help me? Thanks....

Which Version of Sql Server is Compatible to windows Vista? Trying to install sql server 2000/2005 on windows vista but setup terminated.How tro resolve it.Please help!

Can I install Oracle 9i, Oracle 10g, and SQL Server 2005 in one machine? Oracle 9i - 9.2 Enterprise (Developer edition) Oracle 10g -10.2 Enterprise (developer edition) SQL Server 2005 Developer Edition I already installed the 9i and SQL Server 2005, with the appropriate services stopped (set to manual). I am planning to install 10g on the same machine and set the appropriate services to manual. Can I have them all in one machine?

What is the main purpose of a SQL server in a corporate network? I've installed multiple SQL servers at work and didnt have a clear idea on what it is really used for. Mostly after I install all components (HW/SW), I leave the configuration tasks to our DBA in which they handle the rest as far as connection, securing, etc.... Please advise. Thanks!

How can we connect Sql server 2005 if we have vpn and ftp accounts or sites ? We have VPN and FTP User name and passwords for some sites.so now we want to access the database of these sites.how can we connect through the database if we are using sql server 2005 ???

How to connect JAVA GUI to SQL server database? Any information, help, references is much appreciated. I have simple JAVA GUI and simple SQL SERVER DB and i want to connect them together so i can use the UI to update the data in SQL. I think its simple idea but i can not find any information (may be tutorials) how to do it.

How do I simulate record locks on SQL Server? I am creating a script to monitor record locks on SQL Server but dont have any locks to test it with. How can I create some locked records?

I get the error, "Microsoft SQL Server 2000 Enterprise edition server component is not supported on this oper? I am having a problem installing SQL Server 2000 on Microsoft Windows XP Pro. I get the error, "Microsoft SQL Server 2000 Enterprise edition server component is not supported on this operating system." But I need server components also along with client components. please show me a solution.

Can I connect from microsoft access to SQL server and delete records? Can I connect from microsoft access to SQL server and delete records?

Can I install SQL Server 2005 onto a Server running MS Small Business 2003? I need to install SQL Server on our server to install MS Dynamics CRM 4.0. We are running Small Business Server 2003 and I need to know if SQL Server 2005 will be ok to install on it?

How do I set up SQL Server Express or 2005 on home machine? I want to set up my home computer to have SQL server so I can know how to work with ASP or ASP.Net once I'm in a business environment. Can you give me a link or instructions on how to set this up? Ultimately, I'd like to see the server in action so that I can view a page (which access the SQL Server DB) from another computer. Any good links for tutorials other than the microsoft site?

What is the more practical for me to learn SQL Server 2005? or Oracle? I read the job offers for Oracle DBA they are requiring a lot of experience and certs and degrees. SQL Server 2005 ads seems to be not as demanding when it comes to credentials. If I go for SQL server do you think I make a good decision?

How to install second instance of SQL server 2000 on the same machine? I want to install a second instance of SQL server 2000 on the same machine(running windows server 2003) but every time i install the second instance I cannot have connection to it from any client although I can have access to it from the server itself what should I do to make the second instance work? should I change anything in the parameters of the instance? maybe changing the port or maybe changing the destination of the program files when installing the instance to make it different than the the default instance program files??

What is the differends between MS Sql server Enerprice edition and Persanal edition? What is the differends between MS Sql server Enerprice edition and Persanal edition. I know that Enterprice edition will work only in server edition OS. I m going to use persanal edition in a company, and it has 12 pcs. Please suggest me which version i have to use here and the reason also.

How do I get MS Access to recognize a duplicate record now that tables have been moved to SQL Server? I recently moved some data tables from an MS Access database to a SQL Server 2000 database. The Access database continues to serve as the user interface for data entry, queries, and reporting. When the data tables were in Access and a user tried to enter a duplicate record, he/she received an error message. Now when a user enters a duplicate record, using the same interface, SQL Server accepts the record. I verified that the properties on the tables in SQL Server and the backup MS Access database were the same. Also verified the Primary keys on both SQL Server and MS Access were the same. Thanks Stanley. Your mention of "constraints" prompted me to use an ALTER TABLE command and Add a constraint. That did the trick.

How to make sql server 2000 generate sql scripts automatically? Is there anyway that whenever I create stored procedures or whenever I update some tables in the database...that sql server can automatically generate sql scripts for that on the development server? So it would be easier when I update the database on the production server? thanks

How can I connect from PHP script to an MS SQL Server Database? My PHP scripts run in a FreeBSD Server and there's another Windows Server 2003 that host MS SQL Server Database.

What are the easy ways to Convert a MS Access database to SQL Server and C Sharp? I have a Microsoft Access database. Now I want to convert it into Microsoft SQL Server and C Sharp.

Give me some websites or links to access resumes of people skilled in JAVA, oracle, sql server and embedded? Give me some websites or links to access resumes of people skilled in JAVA, oracle, sql server and embedded systems (0 - 5 yrs), preferably in bangalore (or else all over India)

How do i connect to SQL server with PHP? My pages run 100% ok on linux, but i need to use an SQL database and retain my PHP. This will probably run on a windows server. Someone give me the connection script for this. My pages run 100% ok on linux, but i need to use MSSQL database and retain my PHP. This will probably run on a windows server. Someone give me the connection script for this.

How to get a resultset from SQL server into java ? I need to run a Stored Procedure in SQL server from Java and catch the resultset , and so far I wasnt able to . can anybody give me an example ? ResultSet rsCombo = null; try{ cs = connSql.conSQLServer2.prepareCall("{call [dbo].[prscrapModulesList]}"); rsCombo = cs.executeQuery(); while (rsCombo.next()){ **** here shows an error the stored procedure is... PROCEDURE [dbo].[prscrapModulesList] AS select moduleid as id , moduleid as description, '-1' as cond1 from scrapmoduleload where moduleid not like '' order by moduleid **** question ... do I need a cursor to send the resultset to Java ?

Using MS Access to update a SQL server back end? I need to create an Access database to facilitate the updating and viewing of an SQL server table. I plan to use forms to control the data input of mandatory fields etc. What complications may occur by doing this? Do I need to prepare the table with anything specific? -Timestamps etc. Any other things to think about before I start?

Where can I get a free download for MS SQL Server Query Analyzer? I am running MSDE 2000 Rel A in conjunction with a web based project mgt software. I would like to install additional components for the PM software, but it requires MS SQL Server Query Analyzer. Does the analyzer even work in conjunction with MSDE 2000? I really can't spend the money on a full version of MS SQL Server 2005.

Help needed : How do you install MS SQL Server for MS Visual Studio 2008 Professional? One of my friends got a copy of Microsoft Visual Studio 2008 Professional but when he installed it, it only installed MS C++, MS VB, MS C#, ASP, Crystal Reports and Tools for Office. How could we install SQL server? Do you have to buy separately? Doesn't it come with Visual Studio?

What does it mean when you access a database through SQL Server and there are no stored procedures? I'm the administrator for my organization's project management system, which is basically just a web app that connects to a SQL Server 2000 database. The web app itself is one giant DLL (written in C++, from what I've read). I know a bit of SQL (just enough to perform simple operations like deleting records, etc.), but not enough to really troubleshoot anything. I'm having difficulty deleting records from a table (from the web app, not from SQL Server Managment Studio), and I keep getting a "Database error: The record list with the 'select blah from blah' select statement could not be read from the table - Invalid column prefix : No table name specified" message. It seems like everything's obfuscated and I can't call the vendor because the company I work for "forgot" to send payment for our tech support. Should I just manually delete the records from table using SQL, or is there some other way that I could solve this problem? The only ones that I see are "system stored procedures"