• SQL server as data source for OBI EE

    hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

    NewIT5 pointsBadges:
  • Formating Sysmessage text

    How does SQl Server generate this error message What happens when an error occurs in a User defined Stored Procedure. Which System stored procedure is fired I know that the error messages are stored in "sysmessages" table in "Master" Database - but which system stored procedure calls this table...

    Teguma15 pointsBadges:
  • Allocated Memory Alert

    Our clients newly installed SBS 2003 R2 is sending out Allocated Memory Alerts. My co-worker says this is common for SBS installations, something to do with SQL Server. He figures we should maybe shut down the SQL service, as it is not in use at this company. I have certainly seen this crop up on...

    AndreaF9,775 pointsBadges:
  • Changing date fields in SQL Server Analysis Services

    In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?

    SQL Server Ask the Experts2,585 pointsBadges:
  • order of evaluation in DateAdd with multiple expressions

    I've spent 3 hours researching how order of evaluation would work in this expression. If @BeginTime was 16:45:00 for example, what would be the result of this expression? set @BeginTime = DateAdd(mi,-Datepart(mi,@BeginTime)-Datepart(hh,@BeginTime)*60,@BeginTime )

    LHalkape15 pointsBadges:
  • Error connecting to a SQL database

    I receive the following errors when I attempt to connect to a SQL Server database on my home computer: 1) Keyword not supported: 'intigreted security'? 2) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports in vb.net

    iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001

    Shaz255 pointsBadges:
  • SQL server 2005 to SQL server 2008

    I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

    Standaman15 pointsBadges:
  • windows Server 2003

    Hi, we are in the process of developing an SQL Server-based application for the purposes of monitoring historical server performance and baseline data. Which windows Server 2003 tool and specific data-gathering option would be best suited to obtaining this information?

    Jessie12320 pointsBadges:
  • SQL Server error: Cannot find log file

    I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql in C#

    How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

    Sajjadzare5 pointsBadges:
  • Variables in T-SQL

    Hi, I want to know y does the following script run in SQL and not in T-SQL DECLARE @tblName varchar(30) SET @tblName = CONVERT(VARCHAR(20),GETDATE(),112) + 'Table' DECLARE @sql nvarchar(4000) SELECT @sql = 'CREATE TABLE "' + @tblName + '" ( ID VARCHAR(15), Name VARCHAR(15) )' EXEC(@sql) go it gives...

    Babar198220 pointsBadges:
  • SAP Implementation

    Has SAP been iimplemented in Shipping Company? Who are the implementation partners. Is SAP ecc 6.0 ideal on oracle DB or SQL DB.?

    Enjay15 pointsBadges:
  • search Button In vb.net 2005

    The code is for searching entire sql database if i enter RegistrationNo which is primary key plz help.iam getting errors. If IsNull(TextBox1) Then MsgBox "Please Enter the RegistrationNo" End If If IsNull(Me.TextBox1) = False Then Me.Recordset.FindFirst "RegistrationNo= '" & Me.TextBox1.Text & "'"...

    Shaz255 pointsBadges:
  • SSIS Import from Multiple Databases

    How do I iterate over a series of databases with identical structure and import from a seris of tables within each using the SSIS ForEach facility?

    RobH5 pointsBadges:
  • Using Oracle 10g Stored proc in SSRS 2005

    I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run...

    Ala10ala15 pointsBadges:
  • Configuration of Report Server – no errors but Window Service Identity shows not configured

    Using Vista SP 2 and SSRS 2005. When in the Windows Service Identity, I only see the Local Systems in the Built-in Accounts. I have read in a few documents that normally there are 3 options, (Local System, Network Service, Local Service). Can someone tell me where this list gets it’s values? I...

    Jennyp5 pointsBadges:
  • Backup failing

    Hi Mrdenny, I have as GIG. I have a Database Full Backup Maintenance Plan that fails to execute, and I get the same error as GIG's. I checked my disk and I think there is enough free space available (471GB). What could be causing the full backup to fail? Please help! Thanks in advance.

    Proud2bBrown15 pointsBadges:
  • Database maintenance task (full back up) fails on SQL Server

    Hi My daily maintenance job fails due to the below error from last 20 days regularly Executing the query "BACKUP DATABASE [shipment] TO DISK = N'D:\backup\shipment.bak' WITH NOFORMAT, NOINIT, NAME = N'shipment', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Write on...

    GIG240 pointsBadges:
  • How to move SQL Server databases to a new drive.

    I have installed all my databases (nice_cls and nice_audit) in D:/ drive and need to move them to E:/ drive.

    KD31355 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.