SQL Server

Page 1287




  • Topics
    Replies
    Last post
  • Linked server from Sql 2000 to Sql 2005
    by T_EC
    3 Replies
    Last post by T_EC
      • I'm having issue in connecting to sql 2005 from sql 2000 via linked server. Please advice what I should do to overcome the problem. Thanks. -EC
  • web parts with ie7
    by vjn
    0 Replies
    Last post by vjn
      • Hello, I'm using RSWebParts in a SharePoint page. The Explorer and the Viewer web parts worked fine with IE 6 but now I'm using IE 7 and when I choose a report in the explorer to be opened in the viewer it opens a new browser window with the report instead and the viewer stays empty. I looked into the source code and I think thai it's all ok. Does someone passed by something like this Any solution
  • range comparison
    by Andrew Todd
    3 Replies
    Last post by Jarret
      • How would one go about writing an expression such as: var not in (a to g, s to z) in the expression builder to be evaluted with and iif statment iif(var not in (a to g, s to z),var,"not in listed") I would rather not have to write this in the SQL statement as a case statement.
  • SQL installation paths
    by chittam
    6 Replies
    Last post by chittam
      • Hi I have sql 2000/2005 installation path errors in some of prodution servers. Like we have standards that backup files should go to E:\ drive and data files to f:\ and log files to h:\. Can any one help me in this issue what can be done with out reinstallation, Thanks in advance
  • Am I physically connected to the server on the computer I am using
    by Doug Marquardt
    8 Replies
    Last post by Arnie Rowland
      • Hi All: Is there a way to tell if I am connected to the server on the computer I am using to connect with I want to determine whether the connection is to the local server or a remote server. Thanks. Doug.
  • SSIS - Connection String Issue
    by MA2005
    14 Replies
    Last post by Phil Brammer
      • Hi I have been trying to resolve a connection string issue all day, and havent figured out whats the problem. I keep getting the Acquire Connection error everytime I run my package. Can you someone review the format of my connection string, and confirm that it is indeed the correct format: I have two conn strings specified in my config file, one is to connect to a remote database and one is
  • How to embed word/pdf object into report?
    by leshan01
    6 Replies
    Last post by BobP - BIM
      • Hi, I have a report which includes all the customer data. each customer have a separate page based on their id. For example, the report is 10 pages and each page is data for one customer. Now we need to insert the instruction on the second page of each customer report. that means we need to insert 10 instructions on the above report so each customer will get one page of data and one page
  • what is SOS_SCHEDULER_YIELD?
    by Handong love
    4 Replies
    Last post by sqlworkshops
      • what is SOS_SCHEDULER_YIELD and when dose SOS_SCHEDULER_YIELD work if having more CPU, will SOS_SCHEDULER_YIELD be influenced by thanks for reading
  • use of CASE in script
    by Redi311
    2 Replies
    Last post by Mugambo
      • I have been working on a job that is supposed to do the following: 1) Imports last name, first name, date of birth, ssn, medical record number, and enterprise id from TAB seperated text file an example of the format would be ENTID<tab>LAST<tab>FIRST<tab>DOB<tab>MEDREC<tab>SSN 2) Looks up the person in the import system and inserts a primary key value that
  • Regular Expressions in SQL 2005 using C#
    by YoungEngineer
    6 Replies
    Last post by moona
      • Hi all, i wrote a little function that is basically supposed to give me a match of a regular expression in C#. i tested it out in VS05 and it seems to work fine. It hits the fan when i try it on SQL Query analyzer once deployed. Anyone have any idea why here is the C# class that I deploy to a db using VS05. using System; using System.Data; using System.Data.SqlClient; using
  • Cannot set numeric to null before inserting to table
    by sadie519590
    4 Replies
    Last post by sadie
      • Hi, I have a flat file whose data looks like this: "Opening Balance", Acct1234, 1001.01 "Closing Balance", Acct1234, 1001.01 In my script component for "Opening Balance", I set my output columns like this: Row.AccountNumber = CDate (rowValues(1) Row.OpeningBalance = CDec (rowValues(2)) Row.ClosingBalance = Nothing Be
  • Problem running SSIS from C# executable when kicked off by another executable.
    by agentf1
    3 Replies
    Last post by jwelch
      • If I kick off my C# executable from the server everything works fine but if I have another C# executable kick off the C# executable that runs the SSIS I get an error message saying it cannot run SSIS package. I am thinking it sounds like a permissions problem but not sure. Any suggestions/guidance would be greatly appreciated. Errors I am getting. 2007-09-26 15:02:30,187 [1] ERROR report
  • automatic update
    by cirkin_kral
    2 Replies
    Last post by Jonathan Kehayias
      • I hope that a someone has answer for me. I want create a new database in sql server and import the database tables of Dynamics CRM and of other application (Accountview) import so that I can make a link of these two databases. My question is it possible that this database update or refresh automatic and how The database of Dynamics CRM manages by sql server. But the database of accountview i
  • Sharepoint Add-In Front End Configuration Issue
    by Erik Miller
    14 Replies
    Last post by phaserkb
      • I was wondering if anyone else has come acress this iss or not... I have a distrbuted environment....I have installed SP2, .NET 3.0, and the WSS Object Model on the SSRS server and setupa database for sharepoint integration. But, my issue is with the front end web server for MOSS. I install the sharepoint add in and go to Central Administration to configure the connection and other steps, but I
  • replace value of
    by SQLScott
    3 Replies
    Last post by Jinghao Liu - MS SQL Server
      • Can someone please enlighten me on a specific way "replace value of" is used I'd simply like to know if replace value of can be used to udpate an empty node value. I can't get it to do that, so I'm thinking it can't, but I would certainly like to be corrected if it is possible. For example, suppose of I have the following in a Typed XML column: Code Snippet
  • Visual Studio/BIDS out of memory errors opening large DTSX files
    by Wil_Reed
    1 Replies
    Last post by Person_me
      • I'm currently experiencing major problems with SSIS when opening and editing large .DTSX package files that contain Exec DTS 2000 Tasks which have the package data loaded internally. I have no issues if I point the task to a .DTS file, or to an actual DTS package on a SQL 2000 server - but if I load the package internally then once the underlying .DTSX file gets over around 17MB or so in size (whi
  • junk character within FLAT FILE
    by Antony Kumar
    5 Replies
    Last post by Jamie Thomson
      • sample Data: "061107"  Every flat file ends with the junk character  How to remove this using "Derived Component" or "Script Component" Pls provide the sample code for this task. Thank you.
  • Management Studio Express for Vista
    by soleil4716
    2 Replies
    Last post by soleil4716
      • Does anyone know if Microsoft SQL Server Management Studio Express is available for Vista or not Thanks.
  • RDL Location on the Server
    by SQLChamp
    4 Replies
    Last post by Lisa Nicholls
      • Hello, I'm wondering where exactly is the default location of the rdl file stored on the server http://<server>/reports/ Thanks, -Lawrence
  • 4 part name query very slow
    by John1234566
    3 Replies
    Last post by John1234566
      • exec sp_tables_ex 'linked server' The table_cat returned a null value. I ended up writing select * from linked_server..schema.table and it did work. However, it was really slow. 56 seconds vs. less than a second for the pass through openquery. My guess is that the problem is that the table_cat was null and this is why it is so slow. Is this correct How do I resolve this speed
  • How do you send the result of a query by SendMail?
    by Jayaram Krishnaswamy
    9 Replies
    Last post by Jayaram Krishnaswamy
      • For example the result of an Execute T-SQL Statement task. This task does not have a hook-up for variable assignment, the SendMail can take in a variable. How do you pass the result of EXEC T-SQL statement be assigned to the variable in the SendMail task
  • How to create an installer for deploying Sql Server Express
    by xs8899
    1 Replies
    Last post by Arnie Rowland
      • Hi, I have created an installer for deploying Sql Server Express. My installer will start the process of installing Sql Server Express. However the installation of SqlServer Express will fail because it says another installer is currently running (which is my installer). Is there anyway to work around this problem The reason why I would like to create an installer for the installatio
  • Reporting Services Charts
    by Corey1969
    1 Replies
    Last post by Mary Lingel MSFT
      • Hi, I am new to reporting services and I am stuck. I have a report I am trying to design, it has startdate and end date as parameters, I als have a non-queried parameter with the values of month,week,user,hour. These parameter values create a drowndown box on the report, What I am trying to figure out is how to display information in a chart depending on which item is selected i.e (month,we
  • expression sum and iif help?
    by Nick Sheng
    3 Replies
    Last post by Nick Sheng
      • Hi All, SUM(IIF(Fields!NO.Value >= 1, Fields!tsHours.Value,0)) i write this expression inside the group footer row, it give a #error when generating report. please help Cheers Nick
  • Problem with transact SQL Query
    by BH1234
    7 Replies
    Last post by JVSoares
      • Event Event_ID Person_ID Event Start_Date 1001 50 Referral 02-02-2007 1002 50 Appointment 03-02-2007 1003 50 Assessment 07-02-2007 1004 84 Referral 14-02-2007 1005 84 Appointment 20-02-2007