SQL Server

Page 2422




  • Topics
    Replies
    Last post
  • DEPLOY packages from Server A to Server B.
    by daijun
    7 Replies
    Last post by daijun
      • I developed some SSIS packages in SQL2005.When developing , The connect is set with Server A. And i know ,later we are supposed to move to SERVER B.but B's IP and machine name are both unknown for developers. The deployment guys will be cahrge in that. what's easiest way for me to tell the deployment guy to add a connection to SERVER B after the SSIS packages have been developed any su
  • SQL Server 2005 connectivity issue - SSL Security Error
    by ncp01
    4 Replies
    Last post by ncp01
      • We recently moved from SQL 2k to SQL 2K5 and existing application stopped working with following error message. [DBNETLIN][ConenctionOpen (SECCreateCredentials()).]SSL Security error. The code used to make connection is as below. Option Explicit Const NewConnStr = "Provider=SQLOLEDB;Persistant Security=False;User ID=%DBUser;Password=%DBPassword;Initial Catalog=%DBName;Data
  • Possible to use ReportViewer to change connection strings of a report's datasources?
    by tee_user5
    5 Replies
    Last post by Lisa Nicholls
      • Is it possible to use a ReportViewer control (or something in .net) to change connection strings of a report's datasources The connection string comes from a shared data source, so using an expression for the connection string in the actual report is out. Essentially, I'm looking to tack on Analysis Services cube role(s) to the connection string to change data permissions. If there's ano
  • Detached vs Attached database files
    by Mourad76
    3 Replies
    Last post by Madhu K Nair
      • Hello all, I'm using SQL 2005 Express edition. I'm currently connecting to the database file directrly (from ASP.NET) and that db file is not attached to the server. My question is this: What is the difference Will the performance improve if the db is attached and I connect to it throught the server I'm really not sure what the difference is. Thanks
  • Windows Update breaks SQL Server Express
    by Richard Warren
    3 Replies
    Last post by Tailor
      • I've let my Vista Ultimate 64-bit installation on a Dell Precision M90 pretty much have its way with automatic update which has worked reasonably well...until now. I've installed the MS CRM 3.0 laptop version into my Outlook client. Everything was working well until automatic update tried to install Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) which failed. It also r
  • Running IS Package as SQL Agent Job
    by cherriesh
    2 Replies
    Last post by Rafael Salas
      • Hi, I'm testing my IS package in my local PC which extracts data from one SQL Server table to another SQL Server database. In BIDS, it's running without error. I also tried it in cmd with DTExec /f "c:\package.dts", it also ran ok. I tried assigning it in SQL Agent as job. with same command DTExec. This time, it ran successfully but got 0 rows. I dunno what went wrong, why suddenl
  • Issue programatically building oledbTransformation.
    by Sriharsh
    1 Replies
    Last post by Phil Brammer
      • I get the following validation error when i run a package which contains an OledbTransformation. The external metadata column collection is out of synchronization with the data source columns. The column "Param_0" needs to be updated in the external metadata column collection. The column "Param_1" needs to be updated in the external metadata column collection. Please advi
  • Report builder - free form reports other than tabular or matrix or charts
    by Rajasekhara Yennam
    0 Replies
    Last post by Rajasekhara Yennam
      • Hi Does any body know that creating free form rports using Report Builder is possible Free-form report - in the sense - that user should be able to drag the fields from the leftside fields pane and drop on body as we do in report designer using BI studio. I could not figure out a way to do so. Is this a limitation Thanks Raj Yennam
  • Transactional replication - updatable subscribers - Image Data type- Sql Server 2000
    by Trinity20000
    3 Replies
    Last post by Gary Chen
      • Sql Server 2000 I am looking for bidirectional transactional replication using updatable subscribers (queued or immediate) . Is it possible to replicate the image data from the updatable subscribers to the publisher. I understood that the Image data can't be replicated to the publisher from the updatable subscriber. I am not using the WRITETEXT or UPDATETEXT. I am using just INSERT and UPDA
  • Saving maintenance plan failed?
    by EaUsKY
    14 Replies
    Last post by Sirish Davuluri - MSFT
      • =================================== Saving maintenance plan failed. =================================== One or more arguments are invalid ------------------------------ : Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword) Microsoft.SqlServer.Managem
  • Row locking
    by SaranK
    5 Replies
    Last post by Arnie Rowland
      • Hi, I am looking for a locking advice. I am looking to implement a queue like mechanism where in multiple connections / users connect to the database to get a single row. I do it as follows. I have two tables A & B. I have a stored procedure which joins the two tables and returns only one row whose status flag is N [N - not read before]. The returned row is the oldest
  • Count & LastNonEmpty
    by SolarWind
    5 Replies
    Last post by SolarWind
      • Is there any way to make Count work properly on a measure group where aggregation for every single measure is set to LastNonEmpty Basically it's a fact table that contains periodic snapshots of data & so count only makes sense within the slice based on insertion time. Thanks!
  • Adding a column name to a table in each of the databases based on a condition
    by endemol
    2 Replies
    Last post by endemol
      • i have the folowing databases DB1,DB2,DB3,D4,DB5........ i have to loop through each of the databases and find out if the database has a table with the name 'Documents'( like 'tbdocuments' or 'tbemplyeedocuments' and so on......) If the tablename having the word 'Documents' is found in that database i have to add a column named 'IsValid varchar(100)' against that table in that database and t
  • SSRS Cannot acces calculated measures in cube
    by yudhi
    0 Replies
    Last post by yudhi
      • Dear All.. i have build cube in server A (64bit). and i want to develop reporting which acces data from cube in other server (32bit) all server i have installed SP2 and hotfix march. if i browse all measures and calculated measure in pivot table (OWC) i heve not found problem. but if i want to develop reporting in reporting services using mdx statement, all calculeted measure in cube take a longer
  • Microsoft Support to MSDE
    by Vasanths R
    1 Replies
    Last post by Jens K. Suessmeyer
      • Hi , Does microsoft supports MSDE still or it will support only Sql 2005 Express edition.
  • multidimensional problem
    by Tony Chun Tung Siu
    2 Replies
    Last post by Vladimir Chtepa
      • Dear All, I have a question on MDX. Say I have the following data in the simple cube: date time, speed 1-Sept 1:00, 100 1-Sept 2:00, 120 1-Sept 3:00, 110 2-Sept 1:00, 80 2-Sept 2:00, 90 2-Sept 3:00, 100 now I would like to have a summary which can give me the result as follows: datetime, speed, dayTopSpeed 1-Sept 1:00, 100, 120 1-Sept 2:00, 120, 120 1-S
  • Reliability? [What the heck?]
    by Juliusz
    6 Replies
    Last post by Andy Leonard
      • One of the MVPs prised SSIS for being on the enterprise-level. I tend to disagree. Here we have - enterprise system for one of blue chips. The package is invoked every minute through SQL Agent. It runs three days or three weeks and then reports: Executed as user: EUR\user04. ...9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 13:11:01 Error: 2007-01-
  • SSRS and setting ID on Page_Load
    by jpt_av
    1 Replies
    Last post by ?®€?§Q?
      • I'm looking for a way to set the id (on an asp page) when a selected row from a SSRS report in clicked. The id set would then become a session parameter on said asp page.
  • Deleting data bloats log file
    by Moonshadow
    11 Replies
    Last post by Moonshadow
      • When I delete substantial amounts of data using the SQL DELETE command, the database size apparently remains the same (702 mb) and the log file goes from about 17 mb to over 1 gig. I was expecting for the overall size to decrease drastically, but got just the opposite. Is this typical Can I do something to slim it down As I am just trying to decrease the overall size to make it easier to work w
  • SSRS Format Codes
    by BobFromArgo
    1 Replies
    Last post by FSchmid
      • Where can I find a list of all the format codes, complete with their definitions
  • Long Label Expression
    by Mguvu
    10 Replies
    Last post by Jarret
      • I have a long expression that returns the value of my one label. The expression is suppose to figure out if there are three parts to the MailAddress field and return the appriopriate number of fields properly formated. The format I need to get returned from this delimited field looks like PersonIdNumber CO Line Name Here 123 Address Street City State Zip Country Ea
  • Problem running SSIS from C#
    by agentf1
    14 Replies
    Last post by agentf1
      • I am having a problem running a SSIS Script from within a C# program. Script was running fine and then one day it stopped running and is giving me the following errors and nothing has changed. 2007-07-18 14:27:52,098 [1] ERROR reporting.Processor [(null)] - Problem with DTS Script 2007-07-18 14:27:52,895 [1] ERROR reporting.Processor [(null)] - {Microsoft.SqlServer.Dts.Runtime.DtsError, Microsoft.
  • SSRS report in firefox Browser is a mess --- please help
    by bsmitha
    3 Replies
    Last post by jp_benzene
      • hi i have a SSRS report where matrix is embedded into table. when i view the deployed report in IE, it works fine But when i view the report in FIREFOX browser.. the report for toss.. the alignment of the report is completely screwed up :-( My client badly requires Firefox support for all their reports Any suggestion and help would be appreciated Thanks
  • programatically create a DSN for SQL-Server with non-standard port-number
    by Franz585421
    5 Replies
    Last post by tosc
      • Hi all, I have to create a DSN for SQL-Server. Therefor I use the function "SQLConfigDataSource" from "ODBCCP32.DLL". But the problem is that the SQL-Server does not use the Standard-Portnumber 1433. I've tried to make the DSN with "SERVERNAME xxxx" where xxxx is the Portnumber, sometimes it works, but often it does not. When it does not work, then the Checkbox
  • Evaluate a formula and calculate a variable value
    by Bill YU
    14 Replies
    Last post by clintz
      • Hi, Is it possible to evaluate a varchar formula and calculate variable value i.e. I have a formula saved in a varchar variable: (202/7.3 + 67) * 2 - 12 + 6+@param = 210.67 How can I get @param result Thanks