• 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:
  • Changing databases at run time in SQL Server 2005

    I am using Crystal Reports 8.5, Visual Basic 6 and SQL Server 2005. In my server, I have two databases named Eng_School_Database and Guj_School_Database with the same structured tables. I want to change the databases at run time so that the report should contain the data of desired medium. I have...

    SQL Server Ask the Experts2,585 pointsBadges:
  • rtf text in SQl Server

    We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access - Word strips out the rtf tags and returns a...

    EricF5 pointsBadges:
  • I want to load XML to a table in SQL Server 2005

    i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

    Mitha10 pointsBadges:
  • Differences between SQL Server 2005 Standard Edition and Enterprise Edition?

    What is the difference between running SQL Server 2005 Standard Edition and SQL Server 2005 Enterprise Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to check Max Worker Threads in SQL Server 2005

    We've had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question

    BrentSheets6,925 pointsBadges:
  • Backing up SQL Server 2005 databases to a tape drive

    I am currently running SQL Server 2005 and I’ve set up a maintenance plan that backs up my databases to the disk. I'd like to change that and backup my databases to a backup tape drive that's attached to a backup server. Can this done, and if so, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Script to restore database permissions during a migration to SQL Server 2005

    We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to add row to a SQL Server table where username can be inserted

    Say I have a table called "Customer" (SQL Server 2005) and 10 users have access rights to this table. If I want to add a row to this SQL Server table to insert the username who initially modified this row, how can I accomplish that task?

    SQL Server Ask the Experts2,585 pointsBadges:
  • install a second instance of sql server 2005

    how do i install a second instance of sql server 2005 on the same server?

    Twkennis5 pointsBadges:
  • Writing a query to store an image file in a SQL Server 2005 table

    How would I write a query to store an image file in a SQL Server 2005 table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Recovering a deleted database in SQL Server 2005

    I've accidentally deleted a database on SQL Server 2005, and I do not have a backup. Is there any way to recover it?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Hardware requirements for SQL Server 2005

    Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db 's will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the CPU's, RAM memory and...

    Arne5 pointsBadges:
  • Lacking a FQDN during database mirroring on SQL Server 2005

    I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Explaining triggers in SQL Server 2005

    Can you explain to me the syntaxes of triggers used in SQL Server 2005? Could you also give me a simple example of a trigger?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieving data from SQL server 2005 using VB6? VB6??

    How to create an application in VB6 that can retrive data from microsoft SQL Server2005.Is that possible.Thank you.

    Royal5 pointsBadges:
  • Lagging Microsoft SQL Express Server 2005

    Hi, I have Microsoft SQL Server 2005 Express Edition with SP3, SP4, on Syperemicro Server, Intel Xeon E3-1220 v2 3.10GHz,8GB RAM and OS Microsoft Server 2008. We use Windows 7 desktop clients machine with enough CPU and RAM and arcgis software who is sync with MSSEE. But works very slowly. I am...

    mICROSOFT1235 pointsBadges:
  • naming column returned from FOR XML EXPLICIT query in SQL Server 2005

    Is there a way to name the column returned from a query that includes a for xml explicit? I get a column named XML_F52E2B61-18A1-11d1-B105-00805F49916B. I'd like to name it something more appropriate for ORM software The code I currently have is: Declare @RoleIDs table (RoleID int) insert into...

    Cramhead15 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