SQL Server

Page 2126




  • Topics
    Replies
    Last post
  • Cannot connect to server
    by kered pople
    6 Replies
    Last post by tusharkhulage1
      • Hi, I am using sql server 2005 sp1 developer edtion. I have looked at the install logs and all ok, but when connecting to my server (LAPTOP) i get the following error below. I have not changed any of the xml config file, if anyone can help me i would be very grateful. Thanks in advance kered TITLE: Connect to Server ------------------------------ Cannot connect to LAPTOP. -
  • Happy New Year and Christmas everybody! Another question:
    by Leandro Loureiro dos Santos
    7 Replies
    Last post by Mahesh Dudgikar
      • Can i alter a table included in a Publication I am having problems with that.
  • Set up permission based on the selection made from the drop-down (Parameter) list
    by Milto
    4 Replies
    Last post by Lisa Nicholls
      • I created a report with a school parameter for all our schools in SQL report. The school parameter gets it's value from a query. The report is generated based on the selection made by the user. If user choose school "A", report is generated for school "A" and if user choose school "B" report is generated for school "B". I am using a centralized user i
  • Just another surrogate key question
    by JohnSLG
    6 Replies
    Last post by JohnSLG
      • From what I've read, best practice in OLAP design calls for dimension tables to have surrogate primary keys which are generally integer identity fields. The fact tables which the dimensions relate to will have a composite primary key made up of all the dimension surrogate keys. The tables should also have the original business key stored for reference during data loads or other purposes.
  • Backup file size is growing....!
    by FahimatMicrosoftForum
    7 Replies
    Last post by Ekrem Önsoy
      • Dear All, I am using Append to media backup option in 2000 Version. The size of backup is growing. how can I best create the maintenace plan to clear the history or clear the old files in BACKUP (.bak) file but still be able to restore point in time from same physical file. I Is there any side effect of doing that. Thanks,
  • SQL Command Text
    by YoungEngineer
    10 Replies
    Last post by Phil Brammer
      • I have a select statement as follows: Code Snippet select * from employees where empname in ( 'name1' , 'name2' ) im trying to implement this with parameters in an OLE DB Source using SQL Command Text...im having trouble implementing the multiple parameters. Any suggestions on how to do this Im trying to assign the components of the 'in' field in variables, also, im
  • Hierarchy MDX
    by russzee
    6 Replies
    Last post by Bryan C. Smith
      • Below is my hierarchy : Program 1 Supplier 1 Supplier 2 Supplier 3 . . . Supplier N I need an MDX expression which on retrieves Suppliers for Program 1 and so on. So right now when i browse my cube I see all Suppliers for all Programs because of which there are alot of blank rows. I need only Suppliers unique to each Program. So the final o
  • When adding SSL certificate to SQL Server, C++ application no longer connects.
    by Anonymous564618
    7 Replies
    Last post by Xinwei Hong - MSFT
      • When adding SSL certificate to SQL Server, client applications no longer connect. Error: 17832, Severity: 20, State: 10 2007-04-03 11:42:52.82 server Connection opened but invalid login packet(s) sent. Connection closed.. SSL is not even enabled and we still have this problem. When the cert is removed, then the app works EDIT: THis seems to be happening when we use db
  • can not find reports folder
    by Venugopalachary
    2 Replies
    Last post by Venugopalachary
      • Hi I donn't see reportserver folder in my local host is there any wrong at instalation time Thank you
  • I need a duplicate "empty" database created from an existing "populated" with data. sql 2005
    by allpdoff
    4 Replies
    Last post by jezemine
      • I need a duplicate "empty" database created from an existing "populated" database with data. I need this to be created on a new Server not the existing box. Any suggestions
  • Newbie question: installation problem
    by David Garc&&am
    2 Replies
    Last post by Suprotim Agarwal
      • Hello, i'm trying to run "Reporting Services" in my Windows Vista (with the SP2 SQL 2005 installed!!!). When i try to acces http://localhost/Reports$SQL2005/Pages/Folder.aspx, i retrieve this error, i can`t access the directory... [HttpException (0x80004005): El servidor no puede obtener acceso al directorio de la aplicacion 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Servi
  • Post 2005 SP2 install, no script component can be edited.
    by jaegd
    14 Replies
    Last post by jaegd
      • Anyone starting to see "Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)" after installing SQL Server 2005 SP2 on x86 machines   Second, how can it be fixed After installing SP2, the script component editor will not edit script components created in pre SP2 releases. (I also have Visual Studio 2005 SP1 installed). The script TASK editor will start, but when attemp
  • SSIS package and windows forms
    by YoungEngineer
    14 Replies
    Last post by DarrenSQLIS
      • I have an SSIS package that I would really like to launch right out of a Windows form, is this possible Also, some of the variables for the SSIS package are captured via the windows form, is there any way to pass this on to the SSIS package and then executing it Can someone point me in the right direction to how to do this. Thanks
  • SQLExpress Memory Limitations & aspnet_wp.exe
    by CoderMike
    2 Replies
    Last post by CoderMike
      • Does the aspnet_wp.exe get considered in memory limitations for SQL Express (1GB limit) I'm asking because I run the Reporting Services on the same box (this is required with SQLE). When I run reports, it seems much of the work is in the aspnet_wp.exe process, so I'm trying to determine if running reports will get considered in the 1GB memory limit of SQLE. I know, however, that the ReportServer d
  • Table A 2 column join on one column in Table B
    by pps1
    2 Replies
    Last post by pps1
      • hello everyone i hope you could help me in this query. I have two tables: tblA, and tblB. tblA columns and data are as follows: Prod Prodchid Req T880A120 103P789 1 T881A121 275P246 2 tblB columns and data are sa follow Iprod Idesc Level T880A120 Assy-network 4 T881A121 As
  • How often to rebuild snapshot in Transactional Replication
    by DLivingston766
    2 Replies
    Last post by Greg Y
      • Hello, We are running transactional replication in a high volume environment and we are starting to see high IO on the distribution database when the distribution cleanup runs. We only build the snapshot once a week and I was wondering if I rebuilt the snapshot more often it would reduce the size of the distribution database and the amount of IO that are being generated during the cleanup Tha
  • Summary Only Report with Report Builder
    by dehinson
    1 Replies
    Last post by Bob Meyers MSFT
      • Hello, I have been trying to figure out how to develop a summary only report with no luck. I have tried several groupings but still cannot suppress the detail. Has anyone been successful in creating this type of report Thanks in advance. Dean.
  • Building expression like properties in Custom SSIS tasks
    by ScottCurness
    3 Replies
    Last post by DarrenSQLIS
      • Ive been using SSIS for a month or two and now find I need to create some custom tasks to perform some performance logging. in the the overloaded ProviderComponentProperties section I am trying to create a property which has the same look as the Expressions properties you find elsewhere (Little + on the left and a group of sub properties when expanded). Ive have played with creating a IDTSC
  • Sql Transactions and Web Services
    by Anonymous550970
    8 Replies
    Last post by Anonymous
      • I am using a web service to access SQL Server to return data to the client as well as to update, insert and delete. I am passing an Sql Transaction ByRef to the web service when I do updating...etc. The problem is because I am using transactions, I cannot share the web service....I get the error: System.Data.SqlClient.SqlTransaction cannot be serialized because it does not have a pa
  • SSPI handshake failed with error code 0x80090308
    by zerozerojc
    5 Replies
    Last post by Xinwei Hong - MSFT
      • Hi, I am using SQL Server 2005. I got the following error in event viewer. I tried to search on web the solution but failed. Does anyone have idea on that Many thanks :) Log]=Application [EventID]=17806 [Source]=MSSQLSERVER [Time]=02-07-2007 23:35:56 [EventMsg]=SSPI handshake failed with error code 0x80090308 while establishing a connection with integrated security; the connection has been clos
  • adding custom configuration to web.config
    by Shlomi Meoded
    0 Replies
    Last post by Shlomi Meoded
      • Hello All, I want to add custom cofiguration section to the report server web.config and use this configuration from the RDL, can it be done and if the answer is yes, how it can be done. Thank you
  • How can we format the percentage value format?
    by Helen999888
    6 Replies
    Last post by Helen999888
      • Hi, experts, Thanks for your kind attention. I wanna know how can we format percentage values with 2 decimals (e.g. 98.88%) I am looking forward to hearing from you shortly and thanks a lot in advance. With kindest regards, Yours sincerely,
  • Trying to Split my columns into years (col1 must have vals for 2005, col2 vals for 2006)
    by Carel Greaves
    1 Replies
    Last post by Eagle1984
      • Hi, i'm reasonably new to reporting services and am looking for a way to split my reports' Years to compare the months in year 2005 to 2006 but i can't get my data nest to one another in a single line, it splits the years into different rows as an example this is what i want if you can decipher that 2005 2006 Growth 2005 Year to Date 2006 Year
  • Sharepoint Add-In Front End Configuration Issue
    by Erik Miller
    14 Replies
    Last post by phaserkb
      • I was wondering if anyone else has come acress this iss or not... I have a distrbuted environment....I have installed SP2, .NET 3.0, and the WSS Object Model on the SSRS server and setupa database for sharepoint integration. But, my issue is with the front end web server for MOSS. I install the sharepoint add in and go to Central Administration to configure the connection and other steps, but I
  • Remote User
    by Computermat
    3 Replies
    Last post by Computermat
      • Hi, im new to here and SQL server. I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup