• 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:
  • Printing in SunSystems Accounts package

    Does anyone have any experience in setting up a new Printer for Sun Accounts? We have just had a PCL card installed in a Konica 130F, and it will print from Windows Apps, from DOS but not from SUN Accounts. We have set up an Environment on the Windows Server, and the Printer in SUN, but nothing...

    Robbiehall0 pointsBadges:
  • TaskPad view in SQL Server 2005?

    Is there a way to get the TaskPad view from SQL Server 2000 for use in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Concatenate Two Fields t-sql

    I need to concatenate two fields one varchar(50) and the other varchar(12) The result I need is to see the full 50 characters of the first field even though all 50 may not be filled. Thanks

    Jp52825 pointsBadges:
  • Describing several performance monitoring counters

    Could you please describe the following performance monitoring counters, what they mean and the range to which they are acceptable? Full Scans/sec Checkpoint pages/sec Transactions/sec User Connections Average Wait Time (ms) Lock Waits/sec Number of Deadlocks/sec Target Server Memory(KB) Total...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Reporting Service 2005 Report Stayle/Layout

    How to make the Reports layout change automatically? That it looks just like the clients webpage? Even when they change their colors, borders etc.

    Hedi10 pointsBadges:
  • Migrating stored procedures from SQL Server 2000 compatibility mode to a SQL Server 2005 database

    I recently migrated some reports and stored procedures from a SQL Server 2005 database server in SQL Server 2000 compatibility mode to a SQL Server 2005 database. Afterwards, we have not been able to get the stored procedures to run to completion. We have found two issues: one is collation between...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SAN storage solutions on SQL Server

    It has been said somewhere on this site that “what will be more advantageous [for SAN storage] are more drives in the array versus a couple of very large drives.” However, if the whole lot of arrays is a bunch of disks RAID-5 that are presented as a logical disk and then partitioned into many...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server DB Backup

    Hello, I am a new member and would like assistance understanding why when I attempt to schedule a SQL Backup it doesn't seem to stick after I close and reopen it. I am doing the following: Windows Server 2003 – Enterprise Edition/SQL Vs. 8 1. SQL Enterprise Manager 2. SQL Server Group 3. Open the...

    Ilfoprog50 pointsBadges:
  • Copying DTS packages from SQL Server 2000 to SQL Server 2005

    I am in the process of migrating from SQL Server 2000 to SQL Server 2005. We have several hundred DTS packages. Converting to SSIS will take many months, so we are planning to run the DTS packages under 2005. Is there an easy way, or a utility, to copy the DTS packages from one server to another?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Blank fields on reports in SQL Server Reporting Services

    I am working on Microsoft Visual Studio Team System for testers, and I have generated reports using SQL Server Reporting Services. However, when I select Dial-Up 56 or Cable/DSL 384 network in the Network mix, the values in all the fields of the reports come up as 0. Is there any reason why this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieving specific XML data in SQL Server

    I have a question regarding SQL Server. I have a table with an ntext datatype column where I am storing XML data. My question is: How do I write a user-defined function to retrieve a particular xml attribute in that column?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Building and locating multiple TempDBs for SQL Server

    When building multiple TempDBs for a SQL Server that has multiple CPUs, should each TempDB (tempdev, tempdev1) data file reside on its own physical drive? Can all the tempdev data files reside on the same physical drive?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Eliminating duplicate rows in SQL Server 2000

    I have a database I recently inherited in SQL 2000 that contains some duplicate rows. How can I identify the tables that have this problem (duplicate rows meaning ones that have the same “time_stamp” value, and “time_stamp” being used as a raw identifier)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • I am using SQL Server 2005, I keep receiving the following error message:The following error keeps occurring every 30 minutes in error logs. “The specified user account has expired”.

    I am using SQL Server 2005, I keep receiving the following error message: The following error keeps occurring every 30 minutes in error logs. "The specified user account has expired". Has anyone ever come across this error message?

    Tizi30 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