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???

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?

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?

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 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?

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?

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 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?

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 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!

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 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?

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.

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 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?

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 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.

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?

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 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.

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!

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.

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 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?

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!

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 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.

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?

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?

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 ???

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"