Questions & Answers

  • Errors creating database with SQL Server 2008 I&M Training Manual

    I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),...

    Howhighthemoon20 pointsBadges:
  • Software to automate backups for SQL Server 2008 databases

    I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not...

    Phrathepmali30 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:
  • SQL server 2008 provide access to SSIS

    Client needs access to SSIS sql server 2008   Thanks, Evgenia

    Evgenia5 pointsBadges:
  • Running a query on both SQL Server and Oracle databases

    How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Security Login does not work after restoring database on another computer

    I backup the production database on server named SQL1 then restored the database on server named SQL2. SQL server security login name "user1" has been created on both SQL1 and SQL2 servers. When I restore the database on SQL2 I have to re-map and give db_datareader access to the "user1" user name...

    Rick Martinez585 pointsBadges:
  • SQL Server 2008 Finding Most Recent Record Only

    Hi there I have a databse that logs letter print activity The fields being Letter_Ref Print_date Any time someone prints a particular letter it leaves a date in print ref What i want to do is find the most recent print date for each letter_ref is this possible and if so how

    Davewaltonuk20 pointsBadges:
  • Optimizing a SQL Server stored procedure

    I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...

    SQL Server Ask the Experts2,585 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:
  • SQL Server transactions in ASP code

    Can we create sql server transactions in asp, if so how can we manage transactions in asp. Please suggest me, how to do it.

    Vini Chandamama100 pointsBadges:
  • Spreadsheets

    Does Word allow you to perform calculations in spreadsheets?

    Jaimo325 pointsBadges:
  • Upload Excel to SQL Server Table

    I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....

    WorkAround5 pointsBadges:
  • TVCPL Table

    I get this error when trying to create a return delivery in SAP. Copying is not possible because an entry is missing in Table TVCPL: ZRMC

    boocrews5 pointsBadges:
  • I need to reboot my OS on my Windows XP Home edition desktop

    Every time I turn my old Dell Dimensions desktop on, it reads writes/read error at checkpoint [PnP1]. I need a free copy of reboot disk for Windows XP Home Edition. Does anyone have one? Please help.

    nowl0075 pointsBadges:
  • Error message 503 outlook

    I periodically get error message as above when I use my contacts list or sometimes when i respond to e-mail. Error message 503 Valid RCPT command must preceed data

    shpdoc5 pointsBadges:
  • Why did my screen suddenly go dim and how can I fix it?

    While using Scribus self-publishing website my laptop screen went quite dim.  Restarting did nothing.  Windows 7 system

    TomBanfield5 pointsBadges:
  • What is calibration?

    What is calibration in Nokia Siemens?

    basu5 pointsBadges:
  • Drawing with hyperlinks

    I have a floor plan diagram that I would like to set up so when I hover over a location it will hyperlink to another sheet in the workbook.  Does anyone know how to do this?

    petercj5 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