• attach a new mdf and ldf files in sql server 2005 enterprise

    i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.

    Itdonsavi30 pointsBadges:
  • User defined function for an expression

    I have a user defined function that returns a single scalar value, e.g. a formatted name. Is it possible to reference the UDF as the value of a field in SSRS 2008?  If so, how?  Thanks.

    TheRicker5 pointsBadges:
  • Problems with SQL communications over ISDN

    We have upgraded a number of Windows XP clients (from MSDE 1 to MSDE 2000) which interact with a clustered SQL server 7 system (running on Windows NT server) via transactional replication. Our problem is that these clients are connected over ISDN dial up lines and since the upgrade we have noted a...

    McRick5 pointsBadges:
  • How do i recover the DB from suspect mode in sqlserver 2000?

    I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

    Sqkservrdb20005 pointsBadges:
  • SQL find duplicates SQL Server 2008

    Up against a SQL question that is difficult to code.  Any help is greatly appreciated.

    Jtigges5 pointsBadges:
  • Local clients loose connection to local SQL Server when system network drops connection to HQ.

    When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database.  For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought...

    TomHelm5 pointsBadges:
  • Encrypting passwords on SQL server 2000

    I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding users to my SQL Server 2008

    How do I increase the number of users CAl to my SQL server 2008 Licensed by server?

    Georgy25 pointsBadges:
  • How to Export a MS SQL Image column to a file.

    I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?

    KatanaBeach115 pointsBadges:
  • SQL Table Layout

    Hi I am creating a database. In my legacy system I had what we called a tables system where coded data could be expanded into different values   eg 0 = No 1 = Yes I tried to create this in SQL by having a properties table and then relating the other tables to the property table. However this wont...

    Philsal25 pointsBadges:
  • Resources for learning about SQL Servers

    can some one teach me this

    Mulky5 pointsBadges:
  • Moving Distribution database from an instance to antother does increase performance ?

    The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some...

    AGiachetti5 pointsBadges:
  • SQL Server memory usage

    I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application?  Is there any data or technique which could be used?

    Cgardel30 pointsBadges:
  • What is the easiest and best Front End development for SQL server.

    What is the easiest and best Front End development for SQL server. I have Visual Studio 2008 Professional IDE. VB.net or VB.

    KRMerker5315 pointsBadges:
  • Problems with SQL Server 2000

    In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit". What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do to fix this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Running SQL Server 2000 and 2005 simultaneously

    When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • row_number in sql 2000

    how to find out the row_number in sql 2000 like using row_number() function in sql 2005

    Rl10 pointsBadges:
  • Adding files to TempDB

    Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ASP.NET

    i want to insert the data into the existing database

    5555544425 pointsBadges:
  • The most-watched IT questions this week: March 9, 2010

    1. A member asks how they can apply GPOs to non-domain computers to make sure they don’t get on the corporate domain, and MrDenny, Technochic, Denwood, and SiThu help with a solution. 2. A member asks about business intelligence in a cloud environment. 3. A SQL Server reader asks how to monitor...

    Michael Morisy8,323 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