• Do all versions of Microsoft SQL Server 2005 support database mirroring?

    Do all versions of Microsoft SQL Server 2005 support database mirroring?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Flowchart

    Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!

    melkamu15 pointsBadges:
  • Would a Windows Server 2008 Server Core work on a SQL Server instance?

    This may seem old but I've been setting up a SQL Server 2005 on Windows Server 2008 and I'm trying to pare it down to its barebones (while it still being functional). On that, I'm looking at the Server Core but I'm not sure if it will run on SQL Server on that SKU.

    ITKE344,705 pointsBadges:
  • ssma_oracle.to_char_date

    ssma_oracle.to_char_date function was missing in the conversion. Do you have the code for the function?

    ayso2976005 pointsBadges:
  • How can I open the database of Microsoft SQL Server 2005?

    Actually I have a system and I use the Microsoft SQL Server 2005 for the Database. Can anybody help me. Thanks.

    Gregtf5 pointsBadges:
  • Disk Partitioning w/SQL Server 2000/2005/2008

    I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am...

    JohnMCouch5 pointsBadges:
  • Import data from Access into SQL Server 2005

    Hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into MS SQL Server 2005. I am receiving info into database access on a daily basis. So I have to do an auto job to import data from access into SQL Server 2005. I think that creating a...

    7715 pointsBadges:
  • P2V Windows XP SP3 SQL Server 2005 Express

    Hi all, can I do P2V with Windows XP SP3 and SQL Server 2005 Express? Is that is possible and how? I mean what kind of software if its doing cold or hot?

    Fulgen5 pointsBadges:
  • unique next no. generation problem

    have to generate unique_number the condition is the user may or may not have system_no which is allocated by the system the user first time start the system/application and if the user format that system the same unique_no will be generated again.this no. comes to our server for user_id and...

    sukhendass5 pointsBadges:
  • Apps built on SQL Server 2005 running in 2008?

    Will applications built in SQL Server 2005 run in a SQL Server 2008 environment

    jwover5 pointsBadges:
  • SQL 2005 Security to access 2 databases on same server via Stored Procedure

    We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive "SELECT permission was denied on the...

    A00001615 pointsBadges:
  • Pros and cons of running SQL Server 2005 through virtualization on VMWare

    I have been asked to provide pros and cons for running SQL Server 2005 on one hardware (VMWare) for multiple groups of DBAs. The proposed plan is to have SQL Server 2005 Standard Edition with system administrators managing the server and DBAs not allowed to logon directly to the server (only...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server view column conversion problem

    I have a view with a column SWID. The source column is Varchar while in the view creation it has been cast to INT. The source table has a non-numeric value "CITY", while during the view creation, this record have been filtered out. When I select all records from the view, it's working well....

    Rmb19815 pointsBadges:
  • SQL Server 2005 Express SP3 Memory Usage

    Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I fear...

    Ndea4475 pointsBadges:
  • Store and retrieve data from SQL Server 2005 in UTF-8

    I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table SQL makes it into question marks ???. What should I do to be able to store and read UTF-8 data? My columns are all...

    MrGeorge65 pointsBadges:
  • BCP utility in SQL Server 2005

    Hi, how to send logins from server to another server using BCP utility?

    241219840 pointsBadges:
  • Cannot connect VB program with SQL Server 2005 in local machine

    The simple program of fetching the data of table through vb.net program. I am retrieving the data into DatagridView . I am writing following String str for connection: Dim str As String = " Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= " my database name is...

    AtulMCM5 pointsBadges:
  • SQL Server 2005 with VB.net

    Hello, I am hareen. I am working on collegedatabase managment software, which is developed in vb.net. I'm using SQL Server database 2005 and my database name is collegedatabaseMV.mdf . I have some questions. What is necessary to load SQL Server 2005 on client computer when I'm installing my...

    HareeDeveloper5 pointsBadges:
  • Errors while attempting the mirroring process in SQL Server 2005

    I am using SQL Server 2005 Enterprise Edition, and I’m having a problem beginning the mirroring process. I am receiving the error messages: “Alter failed for Database 'db_muthu'. (Microsoft.SqlServer.Smo)” “An exception occurred while executing a Transact-SQL statement or batch....

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?

    After a lot of trying and hard work I finally manged to store an image into an SQL Server database using a byte array. But now I'm stuck at how to retrieve it back into my application's picture box control. This is what I need to do: I need to retrieve the saved image straight back into my...

    Obhasha0795 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