SQL Server

Page 4247




  • Topics
    Replies
    Last post
  • Report designer - how you refer to an existing field in calculation
    by sonnyA
    2 Replies
    Last post by sonnyA
      • Hi, This seems simple but can't find. Say in my report I have 3 fields(A,B and C). In field C I want to give a calcultion based on fields A and B. Say field C value = A+B How do you do this In expressions I couldn't see existing report fields, it only shows dataset columns. Sonny
  • how do you reinstalling ODBC drivers in vista business?
    by Solway
    6 Replies
    Last post by Solway
      • How do you reinstalling ODBC drivers in vista business I have installed SQL 2005 Express & SQL Server management Studio Express, with SP2 However, the required driver "SQL Server" is not showing up in the list when trying to add a datasource in System DSN. Can someone help please. Regards Solway
  • How to connect to Oracle in a Script Component in a Data Flow
    by olimag
    3 Replies
    Last post by jwelch
      • Hi After having read the forums I understand that it is not possible to use parameters in the "Ole Db Command", when connecting to Oracle. What I have to do, is to delete a record in an Oracle table from within the "Data Flow", based on parameters. It does not seem to be possible to create the SQL statement in a variable (with parameters generated) and use
  • SQL Server Express and Client App both on Win XP machines ?
    by PSDCHD
    1 Replies
    Last post by Arnie Rowland
      • Hi, Can I access from App machine (on WinXP) to SQL 2005 Exp machine (on WinXP) I installed SQL 2005 Exp SP2 on Win XP SP2 on my PC. Please consider following environment: - My PC name: MyPC - Database name : MyData - Database role for MyData without any permissions: MyDBRole - Application role for MyData having all permisions: MyAppRole - Database user: MyDBUser
  • can't create replication because it already exists...
    by William Lowers
    3 Replies
    Last post by Hilary Cotter
      • I am working on creating a peer to peer setup. My previous setup was a combination of transactional and merge. when I try to add a specific set of tables to the peer to peer publication it tells me that it cannot because the articles are already published elsewhere... I have double checked all my other publications and these tables do not exist anywhere so I figure that one of the system tables
  • hyperlink
    by abz_26
    6 Replies
    Last post by GregSQL
      • Hi everyone, I am trying to hyperlink a file to the report. We are running visual and in one of the fields, we have a pdf file linked to it. When I tried making a report that pulls that information so we can click on it and be linked directly to the file, but all it gives me is the path to the file. Is it possible to link it that way I notice under properties, there are option for linking but its
  • Distribution cleanup
    by P3Gothenburg
    11 Replies
    Last post by A_Andreas
      • Are transactions that have been distributed to all subscribers always stored the maximum retention period in the distribution database I'm using peer-to-peer replication.
  • SQLCMD taking lot of time during insertion
    by Salil
    5 Replies
    Last post by binh xit
      • Hi I am using SQL Server 2005(Express Edition) and i am trying to insert around 50,000 records in a table through a sql file by providing that file as inputfile to the sqlcmd utility. SQLCMD utility is taking a lot of time in completing the transaction. Moreover if i am doing the same thing with the help of a procedure its taking around 30 sec to do so. Please tell me why its taking so m
  • another dynamic assembly loading problem (XmlSerializer)
    by tchen777
    14 Replies
    Last post by Steven Hemingray - MSFT
      • I am having an issue with loading dynamic generated assemblies in my CLR SQL stored procedure. I have tried turning on the "Generate serialization assembly: ON" and have read numerous articles regarding work around but have been very unsuccessful in getting this to work. The problem lies in when the code calls XmlSerializer xmlSerializer = new XmlSerializer(typeof(MyClass)); where MyCl
  • Schedule package upon deploymnent
    by luth0r
    2 Replies
    Last post by Phil Brammer
      • hi all! ive created a package that's supposed to run every night. the package works fine and is now ready for deployment so ive created a deployment utility for this (is this the best way to deploy ) what i want to know is is there a way to set the package to run every night upon deployment
  • Cluster Upgrade SP2 2005
    by TimChapman
    12 Replies
    Last post by SQL'd out
      • Have recently performed an in-place upgrade of a 2 instance sql cluster from 2000 to 2005. The upgrade process went relatively smoothly. However, I am running into problems installed sp2. The first problem that I run into is that I have resrcmon.exe locked. I can click next, which is fine, but once I get past that point I get stuck during the installation process. I am updating DatabaseServices an
  • Full-Text Crawl Error in logs
    by ferrarirosso
    12 Replies
    Last post by HolgerBarthel
      • Hello I get tons of errors of this type. Are the error-code (x14b) documented I've checked a couple of rows but don't find what could be wrong. I'm running sql 2005 with sp1, noise-word files are empty, index has many columns which are in different languages. Thanks for any support Extract from log 2006-12-20 22:52:51.53 spid20s Error '0xc000014b' occurred during full-text in
  • SQL 2005 - How do you refresh db backup maint job?
    by JWJ_SRP
    6 Replies
    Last post by JWJ_SRP
      • We have an application that uses MS SQL 2005 to stored information related to user internet usage. It is storing a large amout of data on a daily bases. The application is set to create a new logging database, when the current database reaches 10GB, then it will start logging to the new database. A new database is getting created at the rate of about 1 new db every 48hrs and the backup main
  • Best Practices Analyzer 2000 vs 2005?
    by SillyMS
    2 Replies
    Last post by SillyMS
      • I am new to Best Practices Analyzer, so I downloaded both 2000 and 2005 and noticed that the 2000 version covers lots of issues that 2005 seems to ignore. The 2000 version has lots of options, while 2005 seems to offer almost no options. I ran both against a 2000 database and the 2000 version caught lots of things 2005 ignores. Of course, 2000 can not analyze a 2005 database, so I wonder, Why does
  • Another cryptic message from SQL 2005 SSIS
    by Jayaram Krishnaswamy
    14 Replies
    Last post by Phil Brammer
      • It reminds me of the "opearation was successful the patient died" scenario. Compare this to the SSIS Error message: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS
  • SQL 2005 Reporting Service - "DTD is Prohibited in this XML Document" on ASPX page
    by gssundar
    5 Replies
    Last post by Albert Yen - MS
      • I have aspx page which uses Reportviewer object to execute/display reporting services report on the page based on the parameters passed by the aspx page. It works fine. I have a problem when I try to use import option on that page. It throws the following error. Can anybody help me to resolve this issue Advanct thanks for your help and support Thanks, Sundar Here is the error mess
  • Hide Calculated Column in Matrix Report And show only in Total
    by SomaJ
    1 Replies
    Last post by David Leibowitz
      • Hi All, I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using InScope , as it creates *Blank column. Please go thru details below. Year Month01 02 03 Total Salary Salary Salary Salary Cumulative (Calc) Employee01 20 5 25 25 Employee02 10 10
  • Working with Backward Compatibility
    by Subhash Subramanyam
    2 Replies
    Last post by Subhash
      • Microsoft Authority, As our application is going to be closed in few months and for testing purpose we decided to continue running dts packages in SQL server 2005. As part of upgrade we are migrating all others( Databases, OLAP and Reporting Services). We have created SSAS 2005 cubes which we want to process using Analysis Services 2000 Processing Task in DTS. Is this possible If not poss
  • Getting Extra Notifications after Content Formatter completes!
    by Poonam M
    2 Replies
    Last post by Poonam M
      • Hi, I am getting extra notifications which I am really not sure how and why its hapening. I did try debugging, and everything seems perfect till ContentFormatter. I am getting exact number of messages for a particular event and they are getting formatted perfectly by the custom content formatter. But when I check the NS<ClassInstanceName>NotificationDistribution in
  • Database user and Corresponding login
    by L Arvind
    3 Replies
    Last post by L Arvind
      • Hi everyone, I have a simple question regarding the database users on sqlserver 2005. When i run a 'sp_helpuser' stored procedure in a database to know the usernames and their corresponding loginsName, i find there are some usernames with corresponding loginName as null.I know for sure that for 'Guest' username the corresponding loginName will be Null, but i find many normal database us
  • Average of children
    by strippy
    5 Replies
    Last post by PedroCGD
      • i know this question has been around for some time, and have read most of the answers, but well still looking at how to do this in standard edition of sql 2005. to what i understand Average of children calculates the average not on the lowest level but on the next one (i.e. it sums the values on daily basis but it calculates an average on weekly or monthly basis). my problem was that i needed to c
  • Performance issues when querying
    by Mimi Jones
    7 Replies
    Last post by Mimi Jones
      • Hi, We're still in the testing phase with sample data and already we're having performance issues. The setup is two VMWare ESX images running on the same Intranet, one with SQL Server and MSAS and the other with our application. Both images are running Windows Server 2003 R2. The main system is on Windows XP. When the cube is queried from our application, it takes a long, long time to load. Bu
  • division in SQL results in 0
    by ubsman
    4 Replies
    Last post by Anthony Chennai
      • division in SQL results in 0 Posted on:  01/09/2006 09:20:13    declare @x int, @y int, @f float set @x = 100 set @y = 2000 set @f = @x / @y print @x print @y print @f in the above code @f prints as 0 instead of 0.05 how would i correct that
  • A way to control the # of Transport connections
    by VDBA
    2 Replies
    Last post by VDBA
      • Is there a configuration parameter that allows me to control the number of Transport connections used by service broker Right now it seems that it just uses one.
  • Problem in upgrading my database tables
    by Phaneendar
    1 Replies
    Last post by Jens K. Suessmeyer
      • hi, I've modified some of my database tables and in the existing version(ver1.3) of my database and i named the new version as ver1.5. now when i've detached ver1.3 database and attaching ver 1.5 to server it is taking the .ldf file from the folder ver1.3.(I'm maintaning the each version in a saperate folder) I want to create an independent .ldf file for ver 1.5 also. i dont want to depen