• How do I configure SQL 2005 to use 22GB RAM on a Server with 24 GB RAM running Windows 2003 EE ?

    We have Windows 2003 Enterprise Edition (32bit) running on a IBM Quad Core Xeon Dual processor system with 24 GB RAM. The same server runs SQL 2005 with SP2. How do I configure SQL Server to use the maximum RAM say upto 22GB RAM ?

    Ravikswamy35 pointsBadges:
  • Job Database Mail to Sharepoint Server Entry

    Hi.... I want to do ... SQL schedule Job database mail to sharepoint server entry,,, Any idea to show the way. Coz I'm very new to sharepoint server. And I'm using SQL Server 2005 64 bit. Schedule Job database mail is currently working properly and I want to send these mail to SharePoint Server....

    AYZTUN5 pointsBadges:
  • Advice needed to reinstall SQL 2005

    I'm fairly new to administrering SQL 2005. I need to reinstall SQL Server 2005 due to a few problems I've been having with dll's not being registered. We also run the reporting services. I just need to know what impact uninstalling and reinstalling SQL will have on the current DB's and reports and...

    Catloftus5 pointsBadges:
  • SSIS package failure message

    I am running SQL Server 2005 and my package fails with the following error: OnError MyServer\serverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column "Some_Column" (5017) to column "Copy of Some_Column" (6373)....

    MarkFyffe5 pointsBadges:
  • Re-applying column constraints

    I have a 100+ db that was hacked. The column level constraints/defaults were removed. I'd like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.

    Kcook5 pointsBadges:
  • T-SQL Query- how to explode XML fragment stored as NText into table?

    I'm using a commercial storefront software that offers "extension data" fields as NText to store custom data. I am storing an xml fragment that looks like this: <priceSplit xmlns="http://tempuri.org/priceSplit.xsd"> <split> <type>Credit Processing Fee</type>...

    Lambrite5 pointsBadges:
  • SQL sever

    Hi, Thanks Flame. I followed the steps in the link you gave. I got to where it prompted for id and password and click next after that but it gives error message as below. Connection failed SQLState: '01000' SQL ServerError: 14 [Microsoft][ODSC SQL Server Driver][DBNETLIB]ConnectionOpen...

    Chukbillo20 pointsBadges:
  • SQL Server

    Hi, Thanks Mr Denny. but when i go to start - programmes - MS SQL server 2005 - configure tools - SQL Server configure manager' I do not see or know where to open a Connect To Server window or where to click on the File drop down menu, and select "Connect Object Explorer". Kindly give give a...

    Chukbillo20 pointsBadges:
  • Is SQL Server Upgrade Advisor worth using?

    We are undertaking a technical study/risk evaluation as to whether to upgrade a substantial SQL Server database from 2000 to 2005. Is the Upgrade Advisor tool of significant benefit it assisting us with the risk evaluation? Nobody in our company has used this tool as yet, so any advice will be...

    ChrisThompson5 pointsBadges:
  • Clustering in SQL Server 2005/Windows Server 2003

    Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Scheduling errors after moving a SQL Server to a different domain

    We run SQL Server 2005 on Windows Server 2003, and we have put our server onto a recently changed domain. Since we’ve done this, we’ve had numerous problems running reports. The latest issue has been that as soon as we start the Internet Information Server (IIS) website to access the reporting...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?

    In SQL Server 2000, you can use a backdoor to create your own view in INFORMATION_SCHEMA... In SQL Server 2005, I get a permissions error though. Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases like the INFORMATION_SCHEMA views? Thanks...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing text documents in tables in SQL Server 2005

    I have a table in SQL Server 2005 which is used to store text/word documents, and I have enabled full-text search on the column and included a corresponding document type for the document. The problem is when I upload a real NotePad Text/MS Word document saved from the NotePad/MS Word application....

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to Restore Backup in SQL Server 2005

    I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," & _...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading from SQL Server 2000 to SQL Server 2005

    I have been offered a free upgrade to SQL Server 2005 Express Edition, but I am very pleased with my current version, SQL Server 2000. If I decide to upgrade, will I have any problems with our network? We use languages like C# and Visual Basic often.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up a SQL Server 2005 database on SQL Server 2000 EE

    I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000/2005 Transaction Logs

    Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file...

    JCDBA20 pointsBadges:
  • Writing a query in SQL for use in SQL Server 2005

    I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Linked server error message on a SQL Server 2005 machine

    We are installing a vendor-developed application that requires linked servers between the vendor database’s server and many of our other servers. It has been set up and tested effectively, but it should be noted that it is a double hop to the servers. Server A (which houses the application)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Archiving a row of data into another database on SQL Server 2005

    I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?

    SQL Server Ask the Experts2,585 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