• How to work with Visual Basics 6.0 and SQL Server 2000

    I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?

    SQL Server Ask the Experts2,585 pointsBadges:
  • load balancing in sql server

    Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

    Rabinarayan5 pointsBadges:
  • Can I install SQL Server 2005 32-bit on Vista 64-bit?

    I have a processor of 64-bit and windows vista SP1 64-bit. But i want to install sql server 2005 32-bit does it support or can i install it on 64-bit. shekhar.parate@wipro.com

    Shekhar085 pointsBadges:
  • Merge two companies into one network

    The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company "A" employees to log into...

    PatM5 pointsBadges:
  • Windows XP virus Query!

    Hi there, I actually has 2 problems! I`m running Win xp with service pack 2!Mcafee virus scan 2004 Home Edition! 1.Each time i reboot my pc it doesnt load the explorer shell!Only the background is visible but nothing else!What i then need to do is open Task Manager - Processes - and end...

    Wazzup0 pointsBadges:
  • Will defragmenting hard disks improve SQL Server performance?

    Does it help to defragment the local hard disks on SQL Server to improve performance? I just started a new position and the drives on the servers are very fragmented. Could defragmenting them help boost some performance? Thanks.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 backup server

    Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

    NewnanIT1,110 pointsBadges:
  • Report from check disk on active NTFS partition

    If I run check disk on the next system boot, I'd like to know if it found and fixed any problems. Does it generate a report, and where would I find it? Someone suggested the event log, but I may not know what I am looking for: a log, a report, a breif line item description?

    BullwinkleJMoose0 pointsBadges:
  • Compressing Old Files

    Hello, I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) in disk...

    BinooDas123410 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005?

    What are basic differences between SQL Server 2000 and 2005?

    Rupam5 pointsBadges:
  • Database Views in SQL Server

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.

    Jwcurrier30 pointsBadges:
  • SQL Server Logins

    Hi Currently using SQL server 2000 Is there a way of making SQL server logins use case sensitive passwords. for example    user = SA password = PassWord123 as it stands "SA" can login with password = password123 how can can i change it so the user cannot login with different case password. I...

    KH155 pointsBadges:
  • Crystal Reports XI period in database name

    SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

    Fortuna35 pointsBadges:
  • SQL SERVER 2005 Performance Monitoring

    Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

    Rick Martinez585 pointsBadges:
  • upgrade SQL Server 2008 32-bit to 64-bit

    We have a new SQL STANDARD SERVER 2008 R2 x64, and an existing SQL STandard Server 2008 R2 x32. I want to migrate the database from the old x32 bit to the new x64 bit machine. Has anyone got any information regarding this, or resource to research read up on. Thank you

    Revsoft5 pointsBadges:
  • Open IT Forum: What cloud concern do you need addressed?

    Will all of the buzz surrounding the cloud - no doubt amplified by Vivek Kundra's push to the cloud - are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know...

    MelanieYarbrough6,345 pointsBadges:
  • Microsoft ISA Server 2000 – Firewall service deliberately stopped – Want to allow ping.

    Hi. This may seem really stupid, and well it is. I have a customer who is running ISA 2000 primarily as a web cache. It is not used for security in any way, in fact, users can just turn off their proxy settings and access the internet, so security is not really an issue here. The box is 4 years...

    Macleodp5 pointsBadges:
  • Automate SSRS report

    I have a monthly task where I have to run an SSRS report for each contractid we service and export each one to excel.  The problem is that there are over 800 contracts and the tool only allows me to enter 1 at a time.  I would like to somehow enter maybe 50 contractid's and have the tool run each...

    Dlowder5 pointsBadges:
  • sql server 2005 do not show Add new administrator in Surface area Configuration

    Hi  all I haved a problem with the installation of SQL Server 2005 SP3 in a WIn xp OS.   I proceed to install the free application but when i try to check the permisions to create a DB i went to Configuration tools > SQL Server Surface area Configuration, but the screen did not present the...

    Mcom5 pointsBadges:
  • VB2008 and Connection to SQL

    Is there any way to connect to a SQL server using Vb2008? I'm trying to add a datasource but this allows me to conenct locally only.

    alessandro.panzetta9,725 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