SQL Server

Page 5188




  • Topics
    Replies
    Last post
  • Issue printing through browser
    by mbr_rptusr
    2 Replies
    Last post by mbr_rptusr
      • I'm having an issue where I print a reporting services report through a browser be it IE or Firefox and the report page is being split into two pages for a single page. A report that is 3 pages ends up being six pages when printed. Does anyone know of a fix or workaround for this problem. Thanks
  • SQL Server loosing connections
    by facemann
    6 Replies
    Last post by oj
      • I have posted this in the SQL Server Data Access forum but wondered if this was a better location. We have two Server 2005 boxes and one Sever 2000. About 3 months ago we started experiencing random database connection drops. These were manifested by exception errors in database applictions that have worked fine for years. The .NET application exception message: "The specified network name is
  • Challenging Select Statement
    by Evidica
    2 Replies
    Last post by Mark - SQL
      • Posted - 03/07/2007 : 15:53:24
  • Overwriting an excel file using SSIS
    by swan_sgp
    14 Replies
    Last post by Rafael Salas
      • Hi All, I created a package which runs everydays and dumps the data into an excel file. The problem iam facing is that -today the package runs and fills in the excel file,tomorrow it again runs and fills in the data without deleting the previous records....... But i want it to delete the records already present and fill in the excel only with the new records... Any help is gr
  • 2000 --> 2005 made performance worse
    by VB.Net Pro
    4 Replies
    Last post by clarayeung
      • I have read another thread on this, but I wanted to ask a little more generally, what makes this happen The app I got called on is a SQL Server database with an Access front end and a web app front end. The database was on an old machine with SQL Server 2000 and it performed adequately. Then they bought a new high end machine, brought the database over in SQL 2005 and it performs worse than bef
  • DTSX package will not run from SQL server agent
    by jschroeder
    2 Replies
    Last post by Michael Entin - MSFT
      • When I try to run a DTSX package from SQL server agent, I get this error message: Started: 3:59:42 PM Error: 2007-08-13 15:59:42.39 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS roperty" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when t
  • Parameter not working
    by RookieDBA
    7 Replies
    Last post by RookieDBA
      • I am pretty new to reporting services and hope some of you experts can help. I created a report from AS cube that has a column "Description" with 30 distinct values. The report has a multi-value parameter "Description" with the following details: Data Type : String Value Field: Description Label Field : Description The filter that i have on the table is =(Fields!Descri
  • Named query as a pivot
    by ajhuddy
    1 Replies
    Last post by Philippe Cand
      • Hello, Is it possible to create a named query in the DSV that is the result of a pivot (e.g. cross tab ). The number of columns as a result of the pivot are based the number of records in one of the driving tables - in other words, it is not fixed.
  • Stored procedure result set in another call?
    by 1Dave
    3 Replies
    Last post by Manivannan.D.Sekaran
      • Lets say I have a stored procedure that creates a result set of an org structure. I then want to use that returned result set in various other queries/stored procedures etc. I know that I could join on the stored procedure using the open query method. I know that I can also create a temp table in the new query and insert the exec statement into the table, but that requires me to define the
  • Columns_Updated () and Update() functions
    by Alaa M
    8 Replies
    Last post by Alaa M
      • Hello all, I'm trying to apply an audit DB trigger on a master-detail tables ,I do not need to insert record in the audit master every time an update happend in the audit detail,I tried to use columns_updated() > 0 but it didn't work the way I axpected it to be ..it stopped inserting into the audit master even if an update was applied against the master table ...any help please and I use the
  • Cannot View Server Logs
    by Michael Hoglan
    5 Replies
    Last post by Andrea Montanari
      • I have SQL Server 2005 Express on a Windows XP SP2 machine. Everything works fine and I have several dbs running. How ever I was wanting to optimize some programs and needed to watch the server and see what it is processing. I log into SQL Management Studio Express and when I go to Management->Server Logs I see the logs and the Activity Monitor. If I right click on the log all I see is Refresh.
  • Logging isn't working properly
    by sadie519590
    4 Replies
    Last post by sadie
      • Hi, I have several packages where I set up a SQL Server log provider. The packages are all called from jobs. However, for some reason, only ONE of the packages is logging to the sysdtslog90 table in my specified database. All of packages have the identical set up for the logging. Here are my settings under logging: PROVIDERS AND LOGS: Name: SSIS Log Provider for SQL
  • Error 28092 when upgrading from Express to Workgroup Edition
    by psc161
    8 Replies
    Last post by psc161
      • Hello, when I try to upgrade SQL Server 2005 using this command line: setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SQLACCOUNT=NT-AUTORITAT\SYSTEM SECURITYMODE=SQL SAPWD=XXXXXX I get error 28092 (administrator rights needed). It seems like the upgrade tries to use Windows authentification although I've told it to use SQL Server authentification. Or did I miss a paramete
  • [SS2K5] : Dynamically construct a FROM statement with current SCHEMA
    by Bertrandr
    3 Replies
    Last post by Bertrandr
      • Hi, I've got a DB with some schemas. There's same tables under these schemas as for example : MySchema1.MyTable1 MySchema2.MyTable1 I wrote CRUD stored procedures for these tables. I'd like to dynamically create the FROM statement inside the stored procedures by getting the schema name from the current context. Kind of : FROM SCHEMA_NAME () .MyTable1 So I'll have one ge
  • Drill Down in Table
    by vikram kansal
    2 Replies
    Last post by Filaretos Postekoglou
      • Hi, I have created a drill down using a table. The drill down has 13 levels in it which causes a big vacant space between the top level and the mesures on the right hand side. I would like to hide the columns so that when i drill down the measure columns should dynamically move towards the right (as i keep on going to the next level) . I have tried using inscope for hiding that particular c
  • export from excel to SQL.. "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.
    by Vladimir552654
    1 Replies
    Last post by Rafael Salas
      • Hi all, We have Windows 2003 64 sp2 Xeon, 2005 EE SP2 64 bit... Trying to do conversion from DTS sql 2000..One package use load from excel to sql..So I tried to create same thing by myself.. Hell, so many issues.. So I used wizard, package created, I changed Run64bit to False, tried to run package, once - completed in debug mode.. Now it's time to create deployment utility and deploy package
  • Merge-Replication - Transaction Log is growing largely - Help Needed...
    by Swapna B.
    1 Replies
    Last post by Greg Y
      • Hi, We have configured the following in the Publisher server.. 1) Merge Replication - Synchronisation to be running in the continuous mode. 2) Merge Replication - Synchronisation in Scheduled mode. The issue that we are facing here is the transaction log file of the databases which are in replication are growing very largely. And we get this error message in the Subscr
  • Why aren't win32 management studio tools on x64 disks?
    by ChicagoBud
    7 Replies
    Last post by Josh Benner
      • Is there any other way to get them without buying sql server 2005 for win32 Thanks. -- Bud
  • Can we use Java Script coding into the custom code of SQL Reporting services?
    by Kalaivani Prakash
    2 Replies
    Last post by Kalaivani Prakash
      • Is Custom code of Sql Reporting services will only support VB Coding Can't we use Java Script coding into the custom code of SQL Reporting services
  • how do i copy a fields from another table into a new table?
    by tenchyz
    2 Replies
    Last post by Adam D. Turner
      • I want to put fields from four tables into one table. I created a new table, but how do i get the same fields from the other tables to this table along with primary and foreign keys. Table Fields Tbl_Date_Dimension [Date_Dimension_Year] , [Date_Dimension_Period] , [Date_Dimension_Fiscal_Week] Tbl_Report_Level Report_Level_Id Tbl_Customer
  • wizard for creating interface to ssis package?
    by mflancour
    3 Replies
    Last post by JayH
      • I'm very new to ssis, so I hope I don't sound too ignorant. I was told there might be a way to create User interfaces for ssis projects. ie, I am trying to create an import package that will let a user import an excel file to a sql table. What I would like to have is some sort of web interface that lets the user select the source file and destination table. The more I search for a way to d
  • Required free eBook on Reporting Services 2005.
    by Vishal Gurav
    3 Replies
    Last post by Vishal Gurav
      • Hello Friends, I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link. Thanks, Vishal.
  • Merge Rep - Partition jumping
    by PPCDude
    2 Replies
    Last post by Greg Y
      • Hello, We are merge replicating data from a server to client servers. The publication has a static row filter. If a change is made on the client to the field defining the partition, we are seeing a problem. After a synch, the record is deleted from the client. Here are more specifics: There are work orders created on the branch office server with a status of "Scheduled". These are
  • Chinesee Characters
    by Gertus
    5 Replies
    Last post by rusag2
      • Can anyone explain why this will return different results in Query Window The second one return just question marks for the data Regards Gertus CREATE TABLE #chineseText ( rowNumber int , chineseText nvarchar ( 50 ) ) INSERT INTO #chineseText SELECT 1 , N ' жа ' UNION ALL SELECT 2 , N ' жа
  • My Cube is empty after processing - where did the data go?
    by SADave
    6 Replies
    Last post by SADave
      • Hello! I inherited a cube from another developer. After working though it for awhile and fixing broken views etc, I am able to get the cube to deploy and process. However, the cube appears to be empty. I can retrieve no data from it at all. In Dev Studio, I can drill through the data source to see that the tables and views are actually populated, but nothing appears inside the cube.