• 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:
  • Looking for the user interface in SQL Server 2005 Developer Edition

    I just installed SQL Server 2005 Developer Edition and I can’t find the user interface. I’m looking for the place I’d type queries as I did in SQL Server 2000 Enterprise Manager. Where can I find the UI?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Syntax to reference a table on a database residing on another server

    I have the following insert statement: insert into Resident(Identifier_Type,Identifier,Full_Name,Dob,DL_Number,DL_State,Change_User,Change_Date,Change_PropID) select N'SS',Social,Full_Name,DOB,DL_Number,N'TX',Change_User,Change_Date,Change_PropID from N'haa-sql1.imisTest.dbo.Resident' I'm getting...

    MParkhouse5 pointsBadges:
  • Copying a SQL Server stored procedure with a query

    I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Installing SQL Server Enterprise Edition on Windows XP

    I have two questions. First, how do I install SQL Server Enterprise Edition on Windows XP? And second, how can I find the SQL password without using an application?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Table size in SQL Sever 2000

    Please, I need a script to know the size of every tables in my DB. I found that my database is growing above what I expected,and I need to know the size of its tables.

    Yunior5 pointsBadges:
  • Stopping transactional replication from skipping a block of records

    Have you ever run into an instance in SQL 2005 where transactional replication is skipping a specific block of records? I have tried many troubleshooting techniques: dropped/created sub and pub, created new empty destination table, reinitialized and several others. New transactions come across just...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing row level security in SQL 2000

    Is there a way to implement row level security in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Finding the appropriate settings for copying tables within databases

    I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: "Could not allocate space for object...

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-SQL how to identfiy tables that have dulicate roaws

    I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks

    Techzon1225 pointsBadges:
  • Consistent error occuring in SQL Server 2005

    I have five servers in my network. On one member server, I have SQL 2005 Standard ver.9.00.1399.00 running on MS Server 2003 R2 SP2. In my event log on this server, I am receiving an error every couple minutes. They show up in the SQL error log as well as the event viewer. The error is: Event Type:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Ask a question. Win an IT Knowledge Exchange T-shirt

    Community members Brent and I decided to put together a cool little contest. It is very simple. For the next week, starting today, all members that ask questions will be entered to win 1 of 5 IT Knowledge Exchange t-shirts we will be giving away. The more questions you ask the better your chances...

    ITKE361,970 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