• Crystal Reports 8.5

    I have a report that uses SQL 2008 database. It is a money field. I do not want the decimal or the $ sign to show. If it has cents like 1.50 I want it to appear as 150 if it is just 1.00 I want is to be 100. How do I accomplish this?

    llplora5 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:
  • SQL Server 2008 database backup terminating abnormally

    I'm running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log...

    Tablestructure15 pointsBadges:
  • How many users can access the file stored on SQL Server 2008?

    After we store any file on our SQL Server 2008, how many clients will able to access that particular file from the server at a time?

    NikhilGaikwad5 pointsBadges:
  • Establishing a connection from an IBM DB2 database

    I've been trying to establish a connection with an IBM DB2 database (from which I can extract data). Here are some of the details I have:Server NameData LibraryUsername/PasswordI've used both Microsoft Excel and SQL Server 2008 but neither way is working. Using Excel, this is what I tried: I have...

    ITKE334,780 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:
  • Should we use Hyper-V snapshot for backup on SQL Server 2008

    So we have SQL Server 2008 in Hyper-V as a supported configuration. It's been performing well since we're using fixed or pass-through disks (which has increased our processor/memory settings). My big question is can we use snapshots as a reliable backup mechanism? Should we use the tried and...

    ITKE334,780 pointsBadges:
  • Trying to get rid of “divide by zero” error message using SQL Server 2008

    In SQL Server 2008, I keep receiving this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. Now, this is more of a general question but what is the best way to write SQL code so this message will never appear again.

    ITKE334,780 pointsBadges:
  • Free Chapter – Hardening a SQL Server implementation

    Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration. Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based...

    BrentSheets6,925 pointsBadges:
  • High LATCH_EX wait

    What is LATCH_EX wait? Our LATCH_EX wait is very high. What do I need to look at to fix this?

    Rick Martinez585 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

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

    Client needs access to SSIS sql server 2008   Thanks, Evgenia

    Evgenia5 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:
  • vb.net 2008 and sql server 2008

    How can i connect to the sql database using the app.config file over a network and also have the ability to edit the app.config during installation or when the application is installed on another machine on the lan

    Semauel8515 pointsBadges:
  • Reading xml url into SQL Server 2008 Table with OpenXML

    I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url as text into my sql table.  My...

    Rscheinberg595 pointsBadges:
  • Problem with Visual Studio 2010 and SQL Server 2008.

    Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to attach SQL Server...

    Imraja25 pointsBadges:
  • Sql Server 2008R2 on Windows Sever 2008 R2

    When i attempt to install it tells me that my operating system is not supported, rule "Operating system supported edition" failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you

    Coopfirst5 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