• Concatenation

    I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?

    BGramby15 pointsBadges:
  • System hangout

    I have client working on a HCL pc with 2GBram core2 processor he is working on SQL server the problem is that the performance goes down in the evening and hangoff and he even could not open his network drive can any one you could suggest some solution for this problem

    Udaykirak15 pointsBadges:
  • Transact SQL stored executed from AS/400 CL program.

    How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

    Jcorzine20 pointsBadges:
  • Export SSRS Report to Microsoft Excel

    Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

    AmitJoshi14310 pointsBadges:
  • SQL Server Management Studio

    SQL Server management studio will no longer run on my client PC. It ran fine for about 12 months, but now warns with: Evaluation Period has expired..... I am only running the mgmt piece only. How do I get this ability back on my pc?

    Ssutton910 pointsBadges:
  • Visa and SQL compatibility issues

    Do you have any solutions for the compatibility issues I am having with Microsoft Vista and SQL server Data Engine?

    SQL Server Ask the Experts2,585 pointsBadges:
  • AD Domain Admin permissions to SQL

    Can a Domain Admin grant himself permissions to a SQL database? Or, put another way, can a Domain Admin make himself equivalent to the SA account?

    Kenkizer5 pointsBadges:
  • How do you add Name and mail to Address fields to a grouped report.

    How do you add Name and Address fields to the body of a Grouped table report?

    Glstevens5 pointsBadges:
  • SQL 2005 Password

    If you move a sql 2000 database to sql 2005 which admin password does it have now.

    Jabbman4220 pointsBadges:
  • Oracle SP syntax issues

    We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can't seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • query for join

    i have 2 tables unittypes,rules unittypes has unitid and description unitid description A1 description1 A2 description2 A3 description3 rules has id unitid 1 A1,A2 2 A1,A3 i am trying to get it to get a resultset like 1 description1,description2 2 description1,description3 the sql i wrote was...

    Rampradeep5 pointsBadges:
  • connetion failed ,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL

    I enabled remote connections in sql server 2005 configuration and services but also it giving same plz help iam trying this from three days

    Shaz255 pointsBadges:
  • Executing Oracle stored procedure from SQL server

    Using a linked server I can't seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider "MSDAORA" for linked server "PASSRPT" returned message "Syntax error in {resultset...} ODBC...

    Fishman15 pointsBadges:
  • SQL2005 SP3

    Hi, I recently applied Service Pack 3 to SQL2005 64 bit and my server performance has been very slow since. The statistics have been updated on my databases, but that has not made a difference. Has anyone else experienced such behaviour post SP3 install? Thanks, Lakshmi

    Lmurthy5 pointsBadges:
  • Enterprise Manager problem

    Any nvarchar column content is shown as <binary> when using table browsing or view from enterprise manager in SQL Server 2000.

    Jadwiga10 pointsBadges:
  • Leak rate trigger

    If I have a cell that has >=50 AND another that has >=15 then I want the cell with this formula to read YES, if either of the two cells are not >= those numbers then the cell should read NO.

    Adam435 pointsBadges:
  • Optimize the query in sql server

    CREATE VIEW [dbo].[vwResults] AS SELECT r.ResultsPK, b.PersonID, dbo.ltcPerson.FirstName, dbo.ltcPerson.LastName, dbo.ltcPerson.PersonFriendlyID, b.DateCreated, b.FormName, r.FieldName, r.ValueString, r.ValueNumber, r.ValueDate, r.ValueTextInt, r.ValueBit, b.UserID, b.BatchID, b.ParentID, r.Active,...

    Rajupatil5 pointsBadges:
  • Purpose of creating SQL Server stored procedures at run time

    Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it's effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance

    Skothamasu15 pointsBadges:
  • remove password from SSIS package

    How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don't know the password. This package was created by an employee who left the company a couple of years ago.

    Rmk3255 pointsBadges:
  • login failed

    when i start debugging project,sql connection will be closed,before that it will be open .Iam using sql which comes along with vb.net 2005.Iam using sqlconnetion in login form also there its not giving error when i used sql connetion code in another form its giving error login failed .iam tried up...

    Shaz255 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