SQL Server

Page 5658




  • Topics
    Replies
    Last post
  • Deterministic - column property
    by Gish
    1 Replies
    Last post by AKuz
      • Shows whether the data type of the selected column can be determined with certainty. (Applies only to Microsoft SQL Server 2000 or later.) This is what Microsoft documentation says for this column property. How I can use his feature for database application development What is the practical use of this property SQL Server 2005. Thank you, Smith
  • Error when accessing sample databases
    by Bob Mitchell
    5 Replies
    Last post by Bob Mitchell
      • Hey, Everyone - I have downloaded two of the sample databases and get the following error when I attempt to open them: Unable to open the physical file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Assets_Maintenance_log.ldf". Operating system error 2: "2(The system cannot find the file specified.)". (Microsoft SQL Server, Error: 5120) So what am I doi
  • Can you associate a task/job with a report?
    by SamProsser
    2 Replies
    Last post by SamProsser
      • Hi there, I'm wondering if there is a way to associate a job or task of some kind (i.e. SQL Agent job or SSIS package) with the generation of a report I have a need to provide an on-demand report that somehow initiates the updating of its data source prior to generation. In other words, I'd like the report to do *something* that can start an external process (external to the repor
  • SET NEW_BROKER statement hangs system
    by Madhu K Nair
    10 Replies
    Last post by Amaan
      • SQL Version - SQL Server 2005 Standard Edition, SP 1 I have a database which is Broker Enabled. We use Query notification extensively and the application is in testing stage. Both Testing and development database is on the same server. When I create database for testing I used to do Backup-restore method. When i restore a borker enabled database, the restored database and the source database will
  • External Release Date JDBC Driver 1.2
    by rrobinson
    1 Replies
    Last post by Brad Sarsfield- MSFT
      • Is there an estimated release date for the JDBC driver version 1.2. Currently this is only a Technology preview which is not to be used in production. My problen is that we can no longer distribute SQL 2000 as part of our ISV agreement after Dec 31st and The current released version JDBC 1.1 has a issue with JBOSS startup which is corrected in 1.2.
  • Render report straight to pdf
    by stevejebson
    0 Replies
    Last post by stevejebson
      • Hi, Can anybody tell me if it's possible to set a report to render directly to PDF please. I've found stuff on how to do it via a url but that's not how we want to do it. Thanks in advance Steve
  • Help me with this error
    by sureshv
    4 Replies
    Last post by Rafael Salas
      • I am transferring from oledb datasoure to flat file destination. I get the following error.I am having this problem at mappings in the flat file. I get this error.i have only one datasoure.please le t me know about this. Error at Data Flow Task 1 [Flat File Destination [631]]: There is more than one data source column with the name "ErrorCode". The data source column names must
  • The Balanced Scorecard and Data Mining
    by Ranier Bonnici
    1 Replies
    Last post by Jamie MacLennan
      • Do you think that data mining has a role within the balanced scorecard If yes, what kind of models can you think of
  • DTS Package problem?
    by Bill_C
    2 Replies
    Last post by Satya SKJ
      • I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain). I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent rep
  • OLE DB Source using table name variable
    by mruniqueid
    9 Replies
    Last post by jwelch
      • I have a package-level variable [User::viewName], type = string, containing a view name. I want to setup an OLE DB source to use this variable value as the source, so Data access mode = "Table name or view name variable". The Variable name dropdown contains [User:viewName], so I select it. When I click OK to leave the edit dialog I get the error: The variable User::viewName is require
  • Dynamic SQL to populate a variable
    by rusag2
    1 Replies
    Last post by Louis Davidson
      • Here's the WRONG way to do what I want. I need a way to populate a variable from the output of a dynamic query. declare @TableName sysname set @TableName = 'Customers' delcare @Output bigint declare @SQL varchar(max) set @SQL = 'select top 1 RowID from ' + @TableName select @Output = EXEC (@SQL) create function udf_GetDatabaseFingerPrint( @
  • Cannot open user default database. Login failed.
    by SeanBudlong
    2 Replies
    Last post by Jag Sandhu
      • Cannot open user default database. Login failed. Login failed for user '[machine name]\ASPNET'. I'm working in VS 2005 with a starter kit. I close VS and open an MDF file in SQL Server 2005 Management Studio to modify a table. I attach the file, change a data type, then detach the file. When I go back to VS and try to run the program, I get this error. Everything runs normally before I bring the
  • Headers on new pages using Lists and Subreports
    by Charleh
    2 Replies
    Last post by smartmani
      • I have a large report which profiles a customer and produces many pages consisting of sales records, support calls and emails, etc etc. I have one main report which contains a list for the report header with the customer name, logo and some address and contact details, then all the other parts of the report follow at the bottom of the page as subreports, passing the account number as a parame
  • How to get nextcounter for each row via a stored procedure and use it in insert into clause for each row
    by Kamii47
    9 Replies
    Last post by Kamii47
      • Insert into TestJobTable (BookNumber,BookCode,IsActive,SourceId,ContactNumber) select [exec getnextBooknumber 'Book'],BookCode,'1', @SourceId ,[exec getnextBooknumber 'contact'] from TestBookTableTemp where SourceId = @SourceId and BookCode not in ( select BookCode from TestBookTable where SourceId = @SourceId ) Here i have to select records from the temprory table and insert it in
  • Simultaneous execution of the same SSIS package from code
    by thecolour
    2 Replies
    Last post by thecolour
      • Hello I am trying to call the same package with different starting parameters using asynchronous method calls. My code is namespace ReconHost { public partial class HostContainer : Form { public delegate void InvokePackageHandler ( Microsoft.SqlServer.Dts.Runtime. Application app, int var ); Microsoft.SqlServ
  • Data Mining Clusters
    by Keith Henkel
    4 Replies
    Last post by Jamie MacLennan
      • In a response posted Nov 21 (Clustering Dimension), Jamie wrote... "The only option of using a table-based model as a dimension is to write out the cluster labels and simply make the cluster label as a dimension attribute. You could even append the cluster label to the source data (e.g. the customer table) and not have a seperate dimension, simply a browseable attribute on the dimension o
  • SQL 2005 - Query Rounding
    by plank
    1 Replies
    Last post by DaleJ
      • Hi, We are running a few queries (with the same calculations) where the rounding results are diiffering - and we can't see why. The calculation that is resulting in differening results is: ROUND ( policytables . [Monthly life Amount] , 2 ) - ROUND ( policytables . [Monthly life Amount] * PolicyType . [Gross Business Commission] , 2 ) AS [Net to Insurer from life mta]
  • Application cannot communicate with DB
    by omar.salama
    1 Replies
    Last post by Rajagopal Ravipati
      • I have a C# windows application which i've developed that uses an embedded SQL CE DB. When i deployed the project, It worked fine for many PCs. But for some PCs it seems it cannot (The application) communicate with the DB. Why i am saying that That's because the application itself opens . but at the first task where the applciation requests the DB for information, It just CAN'T do that,
  • How to re-use connection manager ADO.NET connection in a script task?
    by papalarge
    2 Replies
    Last post by papalarge
      • I'm currently using: Dts.Connections.Item("myADO.NET connection").AcquireConnection(Nothing) Dim conn As New SqlClient.SqlConnection(Dts.Connections.Item("myADO.NET connection").ConnectionString) conn.Open() This seems silly, in that I'm not really using the same connection, but using the connection string of a connection that already exists. And, for my purposes, it's n
  • Script does not want to update a variable...
    by Darlove
    8 Replies
    Last post by Darlove
      • I wonder why this script IS NOT UPDATING the user-def variable varFileName (package-scoped) and I do not get any errors when running the package at all. Dim strRow As String = Row.Column0.Trim() Dim strConn As String = "" Dim strFolder As String = "D:\data\" Dim strFileName As String = "" If Mid(strRow.ToLower(),
  • T-SQL Challenging Product
    by R2D2RABEAU
    14 Replies
    Last post by R2D2RABEAU
      • Hi There, I need some advice: I have the following table: Id Desc Level Parent Value 1 aaaa 1 0 null >> 1.5 * 4 = 6 2 doz 2 1 44 3 bb 3 2 1.5 4 cc 3 2 4 5 bbbb 1 0 null >> 5 * 2 = 10 6 roz 2 5 77 7 bb 3 6 5 8 cc 3 6 2 I want
  • How to add SQL 3.5 in Visual Studio prerequisites ??
    by PlaTyPuS8
    1 Replies
    Last post by Ambrish Mishra - MSFT
      • Hi! I want to deploy an application that require the SQL Server Compact Edition 3.5 to be installed..... and I want to deploy my application with ClickOnce! But, the problem is that I can't select "SQL Server Compact Edition" in the prerequisites of the Visual Studio Project properties... Do you have a solution thx!
  • single report with the data from "Multiple data sources"
    by Rajeshaz09
    7 Replies
    Last post by Lisa Nicholls
      • Hi, In my project i want a report. In that report data is getting from more than one data sources(systems). While creating data source view i used named query for both primary and secondary data source. But at the time of crating "Report Model" i am getting below error. An error occurred while executing a command. Message: Invalid object name 'Table2'. Command: SELECT COUNT(*) FROM
  • SELECT DISTINCT
    by Carel Greaves
    6 Replies
    Last post by Sarim Ghani
      • Hi Just a question I have a query that selects profile data for members, if I don¡¯t do a select distinct it gives me a lot of correct values, (unique values) of members i.e. only one record per member, but every now and then I get duplicate values for one member, multiple times. Why does this occure I know SELECT DISTINCT is there to remove duplicates, but without
  • SQL Server installing with millions or rows in tables
    by Naimul
    3 Replies
    Last post by Arnie Rowland
      • Hello, Currently we are in the process of implementing a sql server database where couple tables will have millions of rows (about 98 millions and will grow) and an asp.net site that will retrieve and sort the data What will be the best practice installing the database in situation like this one Do we need a cluster server Indexing needs to be done in a special way Thanks in