• Tuning a simple SQL statement in SQL Server 2005

    How would I tune a simple SQL statement, like "SELECT @eno = eno FROM emp WHERE dno = @dno," in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to make ODBC see SQL Server 2005 Synonyms

    I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access? I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.

    Randym1,740 pointsBadges:
  • Is it possible to copy system DBs to another server?

    Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

    Db23290 pointsBadges:
  • Creating XML file using SQL Server 2005

    How to create a xml file using sql server 2005? what are all the steps to do for this?

    Sunithashree5 pointsBadges:
  • Improving the performance of full-text searches in SQL Server 2005

    Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Tracking Table Changes SQL Server 2005

    Is there a SQL Server 2005 script that would give all the table_names in a database, the last time they were updated and by whom? I've gotten as far as: select name, modify_date from sys.tables order by name but I can't figure out the "user" part.

    VelameLaCosa110 pointsBadges:
  • Connect SQL Server 2005 Express db to Visual Basic 2005 Express

    I get an error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but "Test Connection" gives me the same error. What can I do to resolve this error?

    Dhanson20 pointsBadges:
  • Upgrading clustered SQL 2005 64 bit standard to enterprise

    Does anyone have any steps on how to upgrade a clustered SQL 2005 64 bit standard edition to a clustered 64 bit enterprise edition ??

    Gazzer5 pointsBadges:
  • Re-linking database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 pointsBadges:
  • Error message on an instance on SQL Server 2005

    I have three instances on one server running SQL Server 2005. Two of them are working OK, but the other one is giving me an error message that says it cannot load xpstar.dll. What might the problem be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Multiple users with access to a table in SQL Server 2005

    If more than one user can put in a BEGIN TRAN statement, along with being able to update records, of the same table on SQL Server 2005, what will be the rollback results?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

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

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