SQL Server

Page 4000




  • Topics
    Replies
    Last post
  • Scheduling an Encrypted Package
    by dgrm44
    14 Replies
    Last post by dgrm44
      • I have a package that I have set the protection level to EncryptSensitiveWithPassword. How do I setup SQL Agent to run this package. I have checked books online and google and can't find a decent article that walks you through the steps of setting it up...specifically how to use the /DECRYPT switch with sql agent.
  • Open SSIS project error: Unable to cast COM object of type
    by Steve Wang 2006
    10 Replies
    Last post by bobl987
      • When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong TITLE: Microsoft Visual Studio ------------------------------ Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM
  • Sending one message to multiple consumers
    by proof
    7 Replies
    Last post by Sergio Silva
      • Hi Remus What if I need multiple clients to read (RECEIVE) the same message Would it be possible Thanks
  • The request failed with the error message
    by waslam
    2 Replies
    Last post by waslam
      • I have SSRS installed on a web server and points to another SQL Server with the ReportServer database. Every now and then I would get this error message on Report Manger: Client found response content type of '', but expected 'text/xml'. The request failed with an empty response. Here is a trace from Stack Trace from ReportServerWebApp log file: <Header> <Product>Micr
  • Sql server 2005 trial edition
    by red60man
    3 Replies
    Last post by Milos Cimfl - MSFT
      • Hi , i am trying to install Sql server 2005 trial edition , There were 3 types of files for download Self-extracting executables: X86 Executable X64 Executable IA64 Executable Didnt know for which they are applicable , i have a windows xp professional SP2 I downloaded "X86 Executable" . Then tried to run the setup.exe file . It says installing Sql Server 2000 but i want Sql SERver
  • Creating user to own schemas?
    by windthorstking
    4 Replies
    Last post by windthorstking
      • I have noticed that some folks create a user to own a schema, with both having the same name (ex: userowner = pfm schema = pfm) and others make dbo the owner for all their schemas. From what I can tell, it doesn't really matter; what does matter is if your database users are granted access to the schema. Since most users only have public rights and dbo has database owner rights, is there any part
  • Line Chart Colouring
    by Emil Xavier
    0 Replies
    Last post by Emil Xavier
      • Hi, I have a chart with chart type set to "stacked column". I have two values being displayed in the chart. One which contributes to a stacked column representation and another which has been set to "Plot data as line" under the "Appearence" option. The idea being to a marker above each of the stacked columns so that an "action" can be provided. I am try
  • Can someone help me in understanding the output of this TSQL script
    by lndsouza
    6 Replies
    Last post by lndsouza
      • declare @startdate datetime declare @enddate datetime declare @testvalue datetime set @startdate = '2005-12-31' set @enddate = '2006-12-29' set @testvalue = '2006-05-17' if convert ( varchar ( 20 ), @testvalue , 102 ) between convert ( varchar ( 20 ), @startdate , 102 ) and convert ( varchar ( 20 ), @enddate , 102 ) print 'yes' else
  • How do I do this with SQL Express?
    by 2326ac
    1 Replies
    Last post by Andrea Montanari
      • Hi, In Microsoft Access when I had a one-to-many relationship between tables, I could (in the master\parent) table enter a record and a plus symbol would appear enabling me to enter the many side details. How can this be done in SQL Express Thanks for your help A
  • Redirect Rows Move good and bad recs to bad table.
    by Gal1
    8 Replies
    Last post by jaegd
      • I use a redirect row method for error of OLE DB Destination For sqlServer2005. For some resone even though only 1 record has error and should be redirect, all the record in the current batch (I think depending on the "maximum insert commit size") are redirect. the only way for me to get the exact bad record is to set the above parameter to 1, but then it takes hours to run the package
  • Native Oracle SQL -> SQL Server 2005 CE .sdf file -> using Visual Studio 2005?
    by Jay Tee
    5 Replies
    Last post by Jay Tee
      • I've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as: select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table There's also a CASE statement in there with some other data transformations. Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Ser
  • Keep group together
    by GraemeH
    3 Replies
    Last post by Shyam Sundar
      • Is there any way to keep a group header and detail rows together so I don't get the header on the bottom of a page and the details orphaned at the top of the next page Table Keep Together property only works at the table level (though not sure how that works anyway). And I don't want a page break before each group. Thanks in advance.
  • Print Query
    by BilalShouman
    7 Replies
    Last post by Louis Davidson
      • Hello I wanna ask if there is a procedure that prints out a query result example : exec sp_print 'select * from test' Is there sthg like that Regards
  • Reporting Services, pivot function or union on MDX
    by Joos
    2 Replies
    Last post by Joos
      • I have to build a rather simple report with only one chart. The chart has to show a 100% stacked bar chart, with the VBS members as series. I have 2 measures, subscriber count and total revenue. Now I want 2 bars: a first one showing the vbs stacks on subscriber count and a second one showing the vbs stacks on total revenue. Because subscriber count and total revenue are measures, I cann
  • SQL Express & Visual basic 2005
    by Sathyan.C.K.
    3 Replies
    Last post by Arnie Rowland
      • Hello, Iam new to Visual basic 2005, I have installed SQL Express and prefers to use ADODB to connect to the database. This is the code i tried con.Open(cstring1 = "Provider=SQLNCLI.1;" _ & "Server=(local);" _ & "Database=D:\VS 2005 Projects\MyDB.mdf;" _ & "Integrated Security=SSPI;" _ & "DataTypeCompatib
  • Job Site Searching Resumes How to store and search?
    by Scott_wb
    5 Replies
    Last post by Scott_wb
      • I am building a generic job site and well I have hit a speed bump. I need to store resumes in the database to be searched on. Well what is the best way to store these full text resumes so that they can be easily searched on SQL 2005
  • Replicate to other server if replication with main server failed ...
    by NagaPutra
    1 Replies
    Last post by Mahesh Dudgikar - MSFT
      • Let say I've 4 server with MS SQL 2000 installed and I want all of them having the same data. So I'm using merge replication by assign one of them as publisher/distributor. The problem is when ( let say ) server that have been assign as publisher/distributor down then all the other server cannot make replication. My idea was to make it replicate to other available server ( among them ) if re
  • Run Report with specific Records.
    by WoFe
    1 Replies
    Last post by SNMSDN
      • I am not sure where i should post this question since it falls both in Report Server and T-Sql but here goes... I currently need to run a Report that has only specified records that the client/user wants by clicking the check in the check box next to the record they want. They can pick as many or a few of the records that want then run a report only with the records they indicated they wanted..
  • Another nested SQL question
    by windthorstking
    8 Replies
    Last post by windthorstking
      • I am trying to get a nested SQL statement to work in my main SQL report code below. I can successfully run the nested code by itself and the main code by itself, however, I am having some trouble getting them to work together. [Note: the chart_components table and the episodes tables can be linked via the episode_key field ] SELECT srm . EPISODES . MEDREC_NO , srm . EPISODES . A
  • SQL Server on Windows CE 5
    by Jaydutt Shukla
    1 Replies
    Last post by Mike Wachal - MSFT
      • I read somwhere that the CAB files needed for installing SQL Server CE on a WinCE OS can be obtained with SQL Server 2005. Does Express edition have those files I also read that same files are also distributed with VS2005. Since VS2005 is a development product, what are distribution for those CAB files when packaged with VS2005 Additionally, there is SQL Server CE 1.7MB separate download but I fou
  • is there a unique row id hiding behind the scenes?
    by db042188
    11 Replies
    Last post by Arnie Rowland
      • I've heard that if one doesnt have a clustered index on his/her table, that clustering occurs on some underlying row id. Is this true If so, is that id retrievable
  • Display subtotals and grand total
    by JayaC
    4 Replies
    Last post by DanR1
      • Hi, I have a table: CREATE TABLE [dbo] . [TBL_REPORT1] ( [Source] [varchar] ( 3 ) NULL, [Contract No] [varchar] ( 15 ) NOT NULL, [Business Group] [varchar] ( 4 ) NULL, [Customer Name] [varchar] ( 50 ) NULL, [Equipment Description] [varchar] ( 20 ) NULL, [Lease Type] [varchar] ( 2 ) NULL, [Term] [int] NULL, [Booking Date] [datetime] NULL,
  • New Data Source VB2005 and Access 2007 beta
    by lowdown762n
    2 Replies
    Last post by Barry Andrew
      • Well I'm hoping I'm asking this in the right place. But probrably not. I am using VB2005 express and have Access 2007 beta. When I try to add a new data source VB is looking for a .mdb database type. However Access 2007 beta uses .accdb. I'm not sure how to get these two talking since in the vb drop down boxes all it list is a connection on access with .mdb and all files. When I try all files and
  • DTS Migration Wizard error
    by windthorstking
    5 Replies
    Last post by windthorstking
      • I'm using SQL Server 2005 Enterprise x64 and when attempting to migrate a DTS from our SQL Server 2000 Standard x86 server I received the following error message: DTS Migration Wizard Error Could not load file or assembly 'Microsoft.SqlServer.Exec80PackageTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the fil
  • LAst order date
    by begunrom
    1 Replies
    Last post by Bryan C. Smith