SQL Server

Page 2517




  • Topics
    Replies
    Last post
  • Connect to SQL Server from a PDA
    by janols
    14 Replies
    Last post by Hernexto
      • Hi, I'm developing Pocket Pc application, my application establishes connection with a SQL Server Express 2005 Database. When I try to connect to the database I get an error "SQLexception", when i deploy and run my application both on my physical PDA (HP iPAQ) and the Pocket PC 2003 emulator in Visual Studio 2005. I am working in .Net Compact Framework 2.0 and my PDA runs Windows Mob
  • Installing Express toolkit
    by Zakaria.Khan
    3 Replies
    Last post by Mike Wachal - MSFT
      • Hello I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working. Can anyone help with this
  • SQL using 2003 AD Groups
    by Anonymous570724
    1 Replies
    Last post by Raul Garcia - MS
      • We have began to use Windows AUthentication for our SQL 2000 Server. When we llok atthe groups in AD we do not see any Domain Local groups Is there a reason for that Can I just add the group without browsing I assume DLG will work with SQL for security. Thanks Brent
  • How to find out PublicKeyBlob
    by Andreas Brosten
    3 Replies
    Last post by Andreas Brosten
      • I have created a custom authentication for Reporting Services, and it works great if I edit the RsSvrPolicy.congif like the following: <CodeGroup class="UnionCodeGroup" version="1" Name="SecurityExtensionCodeGroup" Description="Code group for the security extension" PermissionSetName="FullTrust"> <IMembershipCondition class="Url
  • SQL Server Windows Auth for ETL called by CreateProcessAsUser
    by lloydsantos
    7 Replies
    Last post by lloydsantos
      • Hi, We are having problems in our project. We have ETL packages we call from our web app that we want to run and the user is the logged in one in the web. We use Windows Authentication in our web app and we used the CreateProcessAsUser to impersonate the user. <identity impersonate="true"/> is also in our web.config. We were able to call the dtexec successfully (with the user
  • deAttach database
    by Sami Karaeen
    4 Replies
    Last post by Sami Karaeen
      • hi is there way by code to stop the sql server service and deattach a database and then restard the service thanks
  • Cannot add a new folder under a Reporting Server Project
    by maui577827
    1 Replies
    Last post by Jens K. Suessmeyer
      • Hello, I was just wondering why is there no option to add a new folder under a reporting server project. I have a reports project and under it i would like to add subfolders like Daily and Weekly just to make it more organized. I understand that during deployment, we can specify to which folder we want the report(s) to be deployed, but what is the reason behind not having an option to add a
  • Generic calculated measure
    by SSAS_STUDENT
    2 Replies
    Last post by Gert-Jan van der Kamp
      • Hi I have to create a calculated measure which is applicable for 16 measures. How can i specify it in a generic manner for eg: create member currentcube.ytd as sum(ytd(),[measures].[sales units]; here my scenario requires the calculation of YTD for many other measures also other than sales units so can i have something instead of [measures].[units], so that it will be g
  • SSIS Randomly Empties Out Column Data While Using Flat File Source
    by Ahmad Siddiqi
    2 Replies
    Last post by Ahmad Siddiqi
      • I'm having a problem using the Flat File Source while using the underlying .Net classes to execute SSIS Packages. The issue is that for some reason when I load a flat file it Empty's out columns randomly. Its happening in the Flat File Source Task. By random I mean that most of the times all the data gets loaded but sometimes it doesnt and it empty's out column data. Interestingly enough this is r
  • Validating the parameter text box
    by SonuSarojan
    1 Replies
    Last post by Shyam Sundar
      • Hi, I have one date parameter in my report. The user will be able to manually enter or use the calendar control. In the case of entering manually, is there any way to validate the input string How can we prevent users from entering alphabets Also, is there any way to reduce the length of the parameter textbox. Can you please help Thanks, Sonu.
  • aggregation question
    by lijun
    3 Replies
    Last post by Umachandar Jayachandran - MS
      • Aggregation SUM adds the numbers together. Is there a similar aggregation function that returns the product of all the numbers Thanks
  • date output format
    by VSempoux
    2 Replies
    Last post by VSempoux
      • Hi, I have the following problem. I have made a parametered report where i ask a begin date (@datefrom) and an end date (@dateto). when i enter my dates via the little calendar is see the format dd/mm/yyyy When i do a preview of report i have a textbox with the following expression : = "Total work time from " & Parameters!DateFrom.Value & " to " &
  • how to change the actual data filename
    by jerrymont
    1 Replies
    Last post by Andrea Montanari
      • i'm hoping someone can help me out with this problem. i have a database called Tracking.mdf and its associated logfile Tracking_log.ldf i need to build another database based on the above with more tables and keep the data separate hence the requirement to make a copy of the tracking data file i've tried changing its name but it will not attach. i can change its database name to w
  • MSResultSetGenerator does not work any more
    by Mathias Raacke
    5 Replies
    Last post by Mathias Raacke
      • I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool": Error 102 Custom tool error: Failed to g
  • Best Practice for Counts/Distinct Count Measures for Filtered Data
    by JawKnee
    2 Replies
    Last post by JawKnee
      • Let's say the Count/Distinct Count measure is based on filtered data. When the situation allows, is it better to do a CASE statement with 1s and 0s from the table in the DSV and then do a SUM on this field Or is it better to create a new Named Query in the DSV filtering out the data through the WHERE clause based off of the original table and then do a DISTINCT COUNT measure on the newly created
  • 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
  • How do you add multiple data sources to a report?
    by PortiaT
    3 Replies
    Last post by PortiaT
      • I have a query that pulls information from 2 different servers. I have created two shared data source now I need to connect them to my dataset.
  • How to capture error upon connect error?
    by SillyMS
    1 Replies
    Last post by Allen White
      • I would like to continue processing when a connect error occurs. Set oServer = CreateObject("SQLDmo.SqlServer") oServer.LoginSecure = True oServer.Connect oName Would like to continue if the connect fails rather than have the script fail. How do I do that Thanks!
  • Server Upgrade
    by Lan
    1 Replies
    Last post by Arnie Rowland
      • We currently have a stand alone production server SQL 2005 STD + SP2 and plan to upgrade to clustered SQL 2005 Ent + SP2. What's the proper way to upgrade I want the existing server instance use Ent engine.
  • How to reflect base table changes in cursor
    by itsAshish
    3 Replies
    Last post by Manivannan.D.Sekaran
      • I have a small question - I have a cursor which is running on the table and i am deleting some rows from the same table during the cursor loop but it didnt reflecting it. Is there is any other option i need to sepcify during declare. declare localshowcursor cursor for SELECT video_release, programname, network, date_encoded, time_encoded, COUNT(*) AS Number FROM SigmaStageTemp s Wher
  • Memory allocation error while processing cubes
    by Preston M. Price
    14 Replies
    Last post by Phil Jeary
      • I get this error while processing my cubes: Error: Memory error: Allocation failure : Not enough storage is available to process this command. There is plenty of space left on the hard disks on this machine, I can't find a remedy for this problem on Google either. Any help would be appreciated. Thanks in advance.
  • Performing insert / update queries using Pocket PC / SQL CE
    by jonellison84
    12 Replies
    Last post by Sunil Rathore
      • I'm writing an application for Windows Mobile 5 / Pocket PC using VB.NET 2005. The database is connected using an instance of SqlCeConnection and updated by an SqlCeCommand. The application can perform select queries on data originally entered into the database through Visual Studio, or perform update / insert queries at run time. Anything inserted or updated can be returned by a select query whil
  • Page Break stops working after adding condition in Hide property
    by Digant Desai
    5 Replies
    Last post by ChandraD
      • Hi, I have a report which has 3 tables kept inside rectangle.I have PageBreakAtBegin Set to True for the last 2 tables.Hide Property for rectangle is False.Everything is working fine. Moment,I place condition in Hide Property,no matter it's True or False,page break stops wroking.I can see all the tables in the single Excel file or report Any help will be appriciated
  • REPLACE Arguments
    by lvance1611a
    3 Replies
    Last post by Arnie Rowland
      • Hi, I'm trying to create a view that shows columns based on user access level. I would like to be able to test for different values without having to add a REPLACE command for each value. For example, My UserLevelID can be 1, 2, 3, 4 or 5. 5 is an Officer level so I have the following command: REPLACE ( m . UserLevelID , 5 , 'Yes' ' ) AS 'Officer' , The problem is that I want
  • How to schedule to run Integration Packages using SQL Agent/Job?
    by garynkill23
    9 Replies
    Last post by Andy Leonard
      • Hi Folks, I deploying a couple of integration packages which needs to be run sequentially. Currently, I quite puzzled how come i cannot run them as a SQL Agent job. It always fail with "Executed as user: Servername\Administrator. The package execution failed. " But if I had put import these integration packages into the SQL Server 2005 Integration Services FileSystem, it does run