• Database migration from SQL Server 2000 to SQL Server 2005

    I am attempting to migrate a database from SQL Server 2000 to SQL Server 2005; the size of the database is almost in terabytes. During migration, I would like to interact with the database on the SQL 2000 server. Is it possible to achieve migration without detaching the database from SQL 2000? If...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up and restoring a LIVE database in SQL Server 2000

    I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a database name query in SQL

    Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using a .bak file with SQL Server 7

    I currently use SQL Server 7, and I have a .bak file downloaded. Can you direct me on how to open this .bak file and how to convert it to allow usage with SQL Server 7?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Slowdown on a server running SQL Server 2000 and Windows Server 2003

    I have a server with SQL Server 2000 SP4 and Windows Server 2003 Standard Edition SP1 that runs SAP Business One. The server's specs are: ML350G5 XEON 2.0DC 4GB RAM 6 UNITS SAS 72GB C:=>Raid 1+0, D:=>DATA Files, E:LOG files, F:TempDB files Swith Hub: 3COM 2924 SFP plus 3COM 4210 Cable: CAT5E...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Assigning access to SQL Server Integration Services (SSIS) packages

    How do we assign access for users to SQL Server Integration Services (SSIS) packages?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory

    I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How SQL Server will work with PerformancePoint Server 2007

    Can you explain the basic architecture and operation of PerformancePoint Server 2007, and how it might work with SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 within MS Access VBA

    I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...

    Rjwilcox45 pointsBadges:
  • Setting database security to prevent restoring databases on other SQL Servers

    Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Including a primary key in a nonclustered index in SQL Server 2005

    The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Network Redeisgn

    Hi, I am serving as a system admin for an organization. We have ISA 2004 network, with Exchange 2003 Standard edition server, 2 Microsoft SQL server 2005 Standard edition for database projects, Windows 2003 domain controller in two sites A and B using active directory services. These two sites are...

    NetworkSanjay5 pointsBadges:
  • Code differentiating between SQL Server 2000 and SQL Server 2005

    If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Dealing with a hyperactive SQL Server

    On occassion, our SQL Server goes hyper - 100% disk activity with I/O queues. It happens only once a year, lasts for a couple of days and then stops. We have our database administration staff look at it, but we have no real idea what the cause is. Can you suggest a direction or idea?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Trouble opening an inaccessible table in SQL Server 2005

    A client of ours is running SQL Server 2005 with PS2 on Windows Server. His database size is about 5 GB. Every now and then something happens and one table (the most important) becomes inaccessible. When we try to open the table, it gives a “SQL time out” error. This sometimes happens twice a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I create a web based application in SQL Server?

    Is it necessary to know C#, .NET or VB.NET to create a web-based application in Microsoft SQL Server 2005?

    JulieB5 pointsBadges:
  • Spawning additional stored procedures in SQL Server 2000

    Is it possible in SQL Server 2000 for a stored procedure to spawn a second stored procedure which will not interfere or slow down the processing of the original? I need the original procedure to finish and return its output variables to the calling program before the second (whose function is to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating from SQL Server 2000 to SQL Server 2005 on a failover cluster environment

    I am planning to migrate my SQL Server 2000 databases to SQL Server 2005 on a failover cluster environment. What is the simplest strategy you could recommend to fulfill this goal?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Managing a sytem with both SQL Server 2000 and SQL Server 2005

    I am the systems administrator on a system that has both SQL Server 2000 and SQL Server 2005 running on it. When they are starting up, the system works fine, but when we reboot the server, the 2 SQL Servers appear to fight each other for resources and the system crashes. This does not occur every...

    SQL Server Ask the Experts2,585 pointsBadges:
  • .Bak file to convert Sqlserver 7.0

    hai i am using Sqlserver 7.0 version only but currently i download .bak file ,how to open this file and how to convert into Sqlserver 7.0,its very urgent pls help me.................... thank U

    Ewrw5 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