• Error backing up with SAP transaction DB13

    The following error message occurs when I attempt to backup with SAP transaction DB13: ***************************** SQL Job information ****************************** Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326] Type: TSQL DB-Name: RPD For Run: 20090620 09:43:26...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible to connect from the SSIS Analysis Services task to SQL Server 2000 Analysis Services?

    Using the Analysis Services Processing Task in SSIS 2005, we are trying to connect to SQL Server 2000 Analysis Server cubes. While we are able to successfully create an Analysis Services connection, when we try to configure the task and specify the connection created above, we receive the following...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to delete spaces in charts

    Hi All I am facing some problems with charts in ssrs 2005. i have inserted 5 graphs in report.Each graph is set by filter.When i run the report ,it is giving some blank spaces if chart doesnt have any values.So how can i solve my problem. Any help would be appreciated . Regards, Anitha

    Anu19825 pointsBadges:
  • SQL Server 2005 Processor Licence

    Hi All, Just wondering what happens when an additional licence is purchase for a SQL Server 2005 that is currently running with one processor. IE. How do we purchase the processor licence for our clients, what to do when we purchase this licence? Thanks in advance.

    Db23290 pointsBadges:
  • RPGLE Stored Proc to Reporting Services

    Have SQLRPGLE program set-up to use cursor to return result set, want to use this to return table to MS Reporting Services get error message "low-order nibble of byte array offset 2451 is not valid. Byte Value OO. What does this mean and why not data back to client?

    Oldmickey65 pointsBadges:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • Adding processor to SQL Server 2005

    Hi All, We are about to add an additional processor to one of our SQL Server 2005, just wondering if there are any downside to doing this and if this a low risk task to do, i.e. we won't encounter any problem after doing this? Thanks.

    Db23290 pointsBadges:
  • sql server remote server connection

    What is the best way to access a sql server in another country using the public ip address? I tried linked server unsuccesfully. Please help. Thanks.

    Preethibh5 pointsBadges:
  • Why is SSIS xml variable in escaped format?

    In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote...

    PaulDav5 pointsBadges:
  • How do I get the value of a lookup field stored in nvarchar field

    I have a list with a lookup field which is being stored in an nvarchar column. I'm trying to access the value in a Sql Server query, but what comes back is this: ↓ ъ䅃㒳ꅉ I've tried converting this column to every data type there is, and no success. Please help!! Thanks...

    3300Metairie35 pointsBadges:
  • Convert column from Number(9) to varchar2(3) in SQL

    What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ....

    GeoMar5 pointsBadges:
  • Show the table field on vb.net form

    How can I show table fied on vb.net form.I have used sql2005.

    Chat305 pointsBadges:
  • Problem with Download-only Articles in New Subscription of Merge Replication

    Hi, I have a Publication in a SQL Server 2005 Merge Replication with Mobile Devices. To explain my problem follow this example: I have an Article in Download-Only with 100 rows. When I start new subscription I look, in the Replication Monitor, that Process start with "Insert 300 rows" for this...

    Eclipses5 pointsBadges:
  • Which version of SQL will work best?

    We have a small but critical application that is accessed by about 30 - 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC...

    LeninKAF5 pointsBadges:
  • dynamic temporary table variable usage

    We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can't resolve the problem. It occurs after the INNER JOIN on the...

    PaminBuckeyeLand15 pointsBadges:
  • Migrate User & Permissions SQL 2000 to SQL XXXX

    Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

    Njimenez5 pointsBadges:
  • Deleting Nightly Database Backups (dumps)

    How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday

    637815 pointsBadges:
  • Failover issues in a SQL Server 2005 mirrored database

    I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up SQL Server 2008 databases to a tape drive

    I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

    Phrathepmali30 pointsBadges:
  • SQL Backup File

    I have two computers running sql server, sqlserver01 and sqlserver01. On sqlserver01 I backup the database locally to C:\SQLBackup\backupfile.bak (db size: 150GB) then I copy and paste the *.bak file to sqlserver02 via the network. It finishes copying but when I try to restore it on sqlserver02 it...

    0 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