• Looping of databases

    The query which works only in one database at a time. How to make it run in databases at once (like a loop one database after the other) is there any query to that?

    narmukutty15 pointsBadges:
  • ASP.NET

    I have four textboxes and a database which is already created. What I want to do is if i enter the value in the four textboxes and press button, it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

    alessandro.panzetta9,725 pointsBadges:
  • SQL Server vs Oracle comparison

    What is the difference from SQL and Oracle in detailed?

    Geta5 pointsBadges:
  • Porting MS Access database to SQL Server

    I've got a problem with porting my MS Access database to SQL Server. In my inventory database, I have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, I do with this kind of queries: a....

    Ipong40 pointsBadges:
  • Retrieving large binary objects

    Server: SQL Server 2005 SP2 on Windows 2003 R2, Quad Core, 4GB Ram, Gigabit Ethernet Client: Windows XP SP2, Dual Core, 1GB RAM, Gigabit Ethernet I am retrieving images from my database across the network and am concerned about thruput. It seems to me when I request a 300k image that it will be...

    JButtery5 pointsBadges:
  • Restoring SQL databases

    Sir, I have deleted a table in SQL database. Is there any option to recover it without losing the data. Please reply.

    H1005 pointsBadges:
  • Restore a View Sql Server 2005

    I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a "CREATE VIEW..." command?

    VelameLaCosa110 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Slow performance for a SQL query

    I have a SQL query I am running, but it is experiencing significant slowdown. The main table - has over 1 million records and a unique key of cusID. It has a one to many relationship with the other two tables mentioned. The query code is as follows: Select customer.cusID,customer.VisitDate,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Connectivity with Developer 2000

    Hi friends, I am using d2k as front end and for back end. I want to use my SQL Server 2000 data. How can I connect it? Thanks!

    Amitd15115 pointsBadges:
  • Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs

    Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

    SQL2K8Dude5 pointsBadges:
  • Connect SQL Server 7 to VB 6

    How can I connect SQL Server 7 to VB 6?

    sasikala5 pointsBadges:
  • SSL on SQL 2005 Express

    Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Forms application that call to the data store. Any assistance will be appreciated.

    ETCGMan40 pointsBadges:
  • Planning to move data on new database server?

    Well I'm working in MNC as a network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to separate database server & application if any body has a plan or he/she know how move...

    Ravijoshi2020 pointsBadges:
  • Migrating DTS packages to SSIS

    What is the tool that migrates DTS packages to SSIS, and how effective is it?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 or SQL Server 2008

    I have been trying to learn SQL 2005 from like a month or two and i think I have done a good job. Now I was about to try some security stuff in it but I saw that SQL 2008 is in market. Can any body suggest me that what is the difference between the two and can I switch to SQL 2008? What ever I...

    JrSoftwareDeveloper5 pointsBadges:
  • Making a WAN

    Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter.  2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ (head quarter) - HP Mail Server (HP ML350) - Win 2003 Server + Exchange Server 03  +...

    PRINCESS85 pointsBadges:
  • List, Save and FTP list of all databases

    How do I run a job to list all SQL databases on a server, save the output and then FTP the output file to another server?

    Mistp00120 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following