SQL Server

Page 5463




  • Topics
    Replies
    Last post
  • Simple Query on one table
    by VBE_programmer
    14 Replies
    Last post by VBE_programmer
      • Hi, I am new about T sql querys. I have one table with two columns col1 col2 --------------------- A B B A C D D C P Q Q P I would like to display the result in the following way using in one query In my view A-->B and B--->A are same and C-->D and D->C ..etc Col1 col2 --
  • Calculated Measure does not appear in all the drilldowns
    by Gumbatman
    5 Replies
    Last post by Gumbatman
      • Hello, I created a hierarchy [Time].[Year-Month] that has the following -Year --Period ---English Month I want to return the headcount from the 1 st Period only. This works fine. I did it by making a new measurement called LastActive by using the LastNonEmpty aggregate function. I then made a calculated measure called BeginHeadCount as the following: ([Measures].[L
  • vista error 500
    by robhare
    24 Replies
    Last post by robhare
      • Goodday If I go to Http://localhost/reports I get this error I have followed the tutorial but still get the error as below. If i go to http:// localhost I get the iis7 wecome page , without a problem. Sorry I,m a bit new at this , I see in the error message that I must type something in a command line window. Is this the black blackground box with C:\windows\system32>_ already typed
  • Reporting Services SQL 2005 x64 standard edition
    by Francois_Benade
    3 Replies
    Last post by Francois_Benade
      • Can reporting services be upgraded to include data driven subscriptions or must SQL server be upgraded to enterprise edition. Currently I am using SQL 2000 standard edition 32bit with reporting services and data driven subscription. Has the features been changed from 2000 to 2005 Thanks Francois
  • Getting the row count of all table in several database
    by Dale L.
    2 Replies
    Last post by The masked Dale
      • Hi all, Im working under sql server 2000 and im trying to acess to some informations to make some report. Im trying to acess to the list of each table in the database, and for each table i would need to know its size. I can get acess to the different table in a single database but i cant get its row count. Is there a way for me to obtain that information or to dynamicaly set a
  • Convert ANsi-89 to Ansi-92 outer join
    by sidlet
    14 Replies
    Last post by Tom Phillips
      • I've been using this syntax for years on SQL Server and now comes the time to convert to SQL 2005 (90 compatibility). This syntax returns four rows. Basically it returns one row for each servername/component/context/property/value even when there does not exist a property of 'fff' since it's a left join: Code Block select t1.* from tblconfiguration t1 ,tblconfiguration t2 where t1.c
  • Help on creating SSIS
    by malhar
    8 Replies
    Last post by Jason Rawlins
      • Hello , I am getting the given error message while creting SSIS. Please help me to solve the error.... Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server.. regards, Malhar , THanks
  • problem with key encryption
    by LioraGirl
    3 Replies
    Last post by Daniel Reib
      • Hello, I am using report server sql express. The report was working until yesturday.Sudenly the report did'nt work and give an error : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more
  • Issues with execute package task in SSIS
    by Vivek S
    10 Replies
    Last post by Vivek S
      • Hi, We have used an execute package task in our master package to execute a child package and we have set the execute out of process=false. This master package is running fine in 32 bit server but is failing in 64 bit server. is there any settings to be done in the server or is it the problem with the property setting(execute out of process) Vivek S
  • What is necessary to create SDF-Files on desktop legally?
    by csname
    14 Replies
    Last post by Bob - GP
      • I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC. I get this error message: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU" If I install "SQL Server 2005 Express" the error message disappears and everything works fine. Question: Is it allowed
  • 64 Bit MSDASQL.DLL
    by sqlguy12
    14 Replies
    Last post by John Sem
      • Is microsoft going to provide 64 bit version of MSDASQL ( OLEDB Wraper for ODBC) in future This was working great while accessing Data from IBM AS/400 on Iseries from 32 bit sql 2000. Now, it's all screwed up with rediculously slow OLEDB both from MS and IBM. I wonder if any of these guys really care!
  • Regarding ManagedDTS assembly
    by jaegd
    2 Replies
    Last post by jaegd
      • Will the Microsoft.SqlServer.VSTAScriptTaskPrx assembly effectively replace MicrosoftSqlServer.ManagedDTS assembly for script tasks There are a number of script tasks which use ManagedDTS (e.g. new Application() + associated function calls) that no longer work with Katmai. For example, I've used tasks which build and configure packages thesmselves, since certain tasks' properties do not sup
  • Support for OLEDB Scrollable Updateable Cursor via Query
    by KostyaXP
    7 Replies
    Last post by KevinLion
      • Hi, is there any update on the subject Jet has it for ages. I want to use Scrollable/Updateable Cursors & OLEDB Rowsets opened via Select query. Last time I have heard that MSFT is planning to add this in the future. Is there a beta version that I can try Thanks, Konstantin
  • NSTL Guidelines for Motorola Q
    by itsRashmi
    2 Replies
    Last post by itsRashmi
      •   Hello all,          We have some doubts regarding NSTL guidelines for motorola Q. Our application is managed application. Which ocasionally connects to server. It is very helpful if we can get answers urgently. Hopper Test ¨C How can we make it run on Smartphone 5.0 (Motorola Q) Is this tool only applicable for pocket pc 2003 Applicati
  • Persist ConnectionString
    by Subin556222
    1 Replies
    Last post by DarrenSQLIS
      • Hello All, I have changed connection string property of connectionmanger at runtime and saved package.But my new connectionstring is not persisting, i am getting my old connection string after reload package . ConnectionManager cm = package.Connections[test.ConnectionManagerID]; cm.ConnectionString = @"C:\Test.csv" ; app.SaveToDtsServer(package, null ,
  • Shortcut to insert new GUID into uniqueidentifier cell in MSSQL Management Studio Express?
    by Iggy Kay
    5 Replies
    Last post by Kent Waldrop Au07
      • Hi, anyone knows if there's an easy way to insert new GUIDs into uniqueidentifier cells when editing data in table on Management Studio Express or Visual Studio 2005 Server Explorer I can't find a shortcut, and copying from external tools is pain.. I suppose it's possible to build a VB macro in Visual Studio, would it work when editing table data Thanks in advance!
  • Query Analyzer -- Northwind dbs?
    by _Leon_
    1 Replies
    Last post by Samuel Lester - MSFT
      • Hi Everyone, I have a question in regards to SQL Server 2000 and its Query Analyzer. I am trying to create certain queries and I need a Northwind database to work with. However, I can't seem to add the database to the dbs' combo box. Basically, I could not find the way to add this database to the analyzer so I can practice with it. Only databases that are there are the system's ones: Master, Model
  • Object reference not set...
    by MLCollins
    3 Replies
    Last post by MLCollins
      • Hello. I'm getting an error - "Object reference not set to an instance of an object" when running an SSRS report with graphs. It only happens when the returned dataset is empty (based on parameters set by the user, it is possible to return no rows). I've tried using the NoRows property (I entered "No Data" in the property box), but I still get the same error. Is there another w
  • How to verify the validity of a file prior to attempting restore?
    by hassiah
    3 Replies
    Last post by hassiah
      • Hello, I would like a way to check a file before attempting to restore it. I want to be able to tell that this is a valid SQL backup file and not just some random file before I attempt a restore. Any help would be appreciated! hassiah
  • ANN: Data Dynamics Reports public beta
    by James Johnson - DD
    0 Replies
    Last post by James Johnson - DD
      • Data Dynamics is pleased to announce that the Data Dynamics Reports public beta has been released. Introducing Data Dynamics Reports, a new royalty-free reporting toolkit for Microsoft .NET developers. Based on the Report Definition Language (RDL), Data Dynamics Reports integrates into Web and Windows Forms applications and provides a rich API with which to create and modify reports. In addi
  • How is the data secured over the air in Merge Replication ?
    by nabeelfarid
    4 Replies
    Last post by mmmmBeeeer
      • Dear ppl, I have a question for you. One of our client has asked us how is the data secured over the air during Replication I have read that Merge Replication uses TLS (Transport Layer Security) protocol to secure the data over the air. But I was wondering if it is all done automatically Or do we need to install certificates like for SSL. We have a Windows Mobile 5.0 application using SQ
  • Possible to access no. rows in groups outside the table?
    by MrOctree
    4 Replies
    Last post by Shyam Sundar
      • Hi there, I'm currently grouping data on some criteria, the way the data works basically means that there are between 2-3 groups guaranteed (no more).  In the Group Header I have CountRows(table1_group) thus giving me the total number of rows in each group at the top of each grouping.  However, I need to do a calculation in a textbox above the table using these row counts.  The m
  • sql and xphome
    by NLglenna
    3 Replies
    Last post by bass_player
      • Hello group, I am new to sql. We are attempting to set up sql express on o/s xphome. The database we need to set up is for staff scheduling and the program is written using access. Has anyone has success doing this Thanks, Glenna
  • Logical fragmentation
    by Ankith
    2 Replies
    Last post by Sherry Li from MSFT
      • Hi: when does a table not show any Logical fragmentation 1). Is it possible if the table has only non-clustered indexes and no clustered indexes, it wont show any logical fragmentation at all or shows less logical fragmentation . Also what is the difference between logical fragmentation and Physical fragmentation of a index .Is there actually something like a physical fragmentation for a
  • Diagram to Clipboard
    by JimBobJames
    1 Replies
    Last post by Jens K. Suessmeyer
      • Does anyone know how to automate the copying of a sql server 2005 database diagram to the clipboard so that this could for instance be accomplished from a word template. Does SQL Server 2005 expose an interface so that you can do this I am trying to automate the copying of a database diagram into a word doc - can be done manually by right clicking on the diagram and sending to clipboard, p