SQL Server

Page 1556




  • Topics
    Replies
    Last post
  • matrix data area conditional formatting off max value
    by Bob_Sullivan
    3 Replies
    Last post by rw251
      • I have a matrix where i'm trying to have the report select the maximum value in the data area (not including the subtotals) and bold that value. month day1 day2 day3 day4 total Jan 10 15 5 12 42 Feb 5 8 3 11 27 Total 15 23 8 23 69 I'm sure i will have to use the IIF function in conjunction with the InScop
  • export to excel issues
    by Mainiac007
    3 Replies
    Last post by MLCollins
      • can anyone explain, why when exporting a really simple spread to excel, one ends up with a ton of blank rows I have a report with 8 columns but when exporting to excel i end up with around 50 columns. All most are blank
  • UPDATE-Cannot shut down VS after using report designer
    by BobP - BIM
    14 Replies
    Last post by Lukasz Pawlowski -- MS
      • Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only
  • OPENROWSET Error
    by dgolds
    2 Replies
    Last post by dgolds
      • I am trying to execute the following ad-hoc query (I have already configured the remote server to allow ad-hoc queries): --EXECUTE AS USER = suser_name() SELECT c.* INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=MyRemoteServer;Trusted_Connection=yes;', 'select * from mydb..mytable (nolock) where PurchaseOrderID in (''19509114'', ''24075854'')) AS c; I receive the following error messag
  • Ignoring Noise words in SQL 2005 Full Text Search
    by _kenneth_
    2 Replies
    Last post by _kenneth_
      • To ignore the noise words in the query microsoft remommends to execute the following statements, by which we can take advantage of the new transformation of noise words in CONTAINS queries: EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure 'transform noise words', 1 GO RECONFIGURE GO But this never works. Can any one please suggest how to make this work.(witho
  • Access denied error message using xp_cmdshell to access network share
    by TimYork
    3 Replies
    Last post by Laurentiu Cristofor
      • When running the following statement in SQL 2005, I get the error message "Access is denied": exec master . dbo . xp_cmdshell 'TYPE \\SERVER-B\SHARE\FILE.TXT' The following are true about the network: The SQL Server is installed on SERVER-A. SERVER-A and SERVER-B are Windows 2003 servers on the same Windows 2003 domain. The SQL Server and SQL Server
  • Newbie Advice Installing SSRS
    by Clintonf
    14 Replies
    Last post by James Wu - MSFT
      • Hi, I've decided to install SSRS (2005) on my windows XP machine. I'm not very familiar with IIS (i'm currently using version 5.1) and I think between IIS and SSRS, i've managed to break something. I've been looking at various articles to try and get some clarity on my predicament. However, i'm not getting any joy with them.s I have located the logfiles (which I can provide). Unfortunately, I have
  • schedule stored procedure
    by suman83
    2 Replies
    Last post by Arnie Rowland
      • How to schedule a stored procedure to run at a certain system time in a regular basis
  • Possible to use ReportViewer to change connection strings of a report's datasources?
    by tee_user5
    5 Replies
    Last post by Lisa Nicholls
      • Is it possible to use a ReportViewer control (or something in .net) to change connection strings of a report's datasources The connection string comes from a shared data source, so using an expression for the connection string in the actual report is out. Essentially, I'm looking to tack on Analysis Services cube role(s) to the connection string to change data permissions. If there's ano
  • Can not expand MSDB folder
    by Ljiljana
    3 Replies
    Last post by Ljiljana
      • Hi! I am trying to deploy a package to SQL. However, when I open Integration services I can not expand MSDB folder. Error is; SQL Server specified in SSIS service configuration is not present or available.... Login time expired .....(MsDTSSrvr) I have found post here that says MsDtsSrvr.ini.xml file needs to be changed from <Name>MSDB</Name> <ServerName>.<
  • cluster error
    by epaiged
    4 Replies
    Last post by csears
      • We have a one node cluster that is receiving the below error messages in the cluster.log and the Event Viewer. In the SQL Server 2005 SP2 job that fails we receive a slighlty different message. The OS is Windows 2003 SP1. This is not a 64-bit box. We have checked the permissions of the cluster service account in SQL Server to be sure they are correct. Can anyone please help with this issue.
  • De-normalisation
    by GregAbd
    6 Replies
    Last post by Kent Waldrop Ap07
      • All thoughts appreciated on this one. I have a Detail table, say Detail (PK int, ID int, Value varchar(50)) which has say 5 rows; PK ID Value 1 1 Value one 2 1 Value two 3 1 Value three 4 2 Value four 5 2 Value five I need this data as XML, grouped by ID so I'd like one XML string to read <Detail><PK>1</PK><ID>1</ID><Value>Value one</Value
  • Error when using SP in data flow
    by Ronald Dirkx
    3 Replies
    Last post by Phil Brammer
      • I want to execute a stored procedure in an OLE DB source in a Data Flow Task. The stored procedure has a parameter. When I put in an SQL command as : EXEC sp_readcustomers 1 (thus passing 1 as the parameter value I can use the Preview button and I get a list of columns being returned. The data flow task should run inside a ForEach Loop where I assign the value of an ADO resultset to
  • Backup Device vs backup command
    by Vidhya Sagar
    6 Replies
    Last post by Satya SKJ
      • Hi, Will backup get completed quickly (the time taken for backing up large databases) on backup device or using backup command If backup device, why
  • Who is the default owner for sql express in windows authentication mode?
    by Aswin
    1 Replies
    Last post by Mark Benvenuto
      • If i create a database in sql express in windows authentication mode, the database owner is in the format of 'MACHINENAME\USERNAME'. If i connect this database to iis server i got login failed error message. This is my connection string in my web.config : Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=dbsgh;Data Source=software92\sqlexpress I solved this
  • Could not establish trust relationship for the SSL/TLS secure channel
    by Tarek Ghazali
    4 Replies
    Last post by Dan Handevik
      •   Hi, I am working on sql server reporting services 2005 , i got this error while deploying a report Error 1 The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. C:\Temp\NotificationReport\db.rds 0 0  NB: i checked IIS no ssl required on all sites. Any Help Thanks Tarek Ghazali
  • about catalog view
    by Andre&amp;#39;s
    2 Replies
    Last post by andrew knight
      • I can find all databases i created from sys.databases view but i could not find tables info under relevant database by sys.tables view and I do not know why sys.tables,sys.columns and other views do not have database_id attribute any idea thanks
  • Cannot shut down VS after using report designer
    by BobP - BIM
    14 Replies
    Last post by Lukasz Pawlowski -- MS
      • Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only
  • Using Multiple datasources in a single datasource view
    by HariK
    2 Replies
    Last post by ishahk
      • Guys, Is this possible with Analysis Services 2005 I have a fact table in a DB2 database which holds all quantitative data. There is another dimension table in Oracle which hold the descriptive information. I need to join the fact and dimension table. Everything was ok until I went ahead and started to process the cube where it failed because it started to look for the fact table in the Oracle
  • OLE DB Command... Read returned fields from query...
    by PedroCGD
    9 Replies
    Last post by PedroCGD
      • Dear Friends, I have an OLE DB Command inside an ETL. I want to execute a stored procedure that returns 2 fields, for example: CREATE PROCEDURE sp_Name AS SELECT Field1, Field2 FROM Table How can I continue the dataflow How can I return the values from the query Returns only a row...
  • SQL Execution Error
    by Jon Stroh
    2 Replies
    Last post by Jon Stroh
      • I have converted a CF app to MSVS 2008 beta 2 and SQL Server CE 3.5 , everything seems to work except one query. It work in Query Designer nor can I load the form the datsource resides on. It will work if I just right click the query and left click preview data. The error is an SQL Execution Error. Error source SQL Server Compact ADO.net Data Provider Error Message: There was an error parsin
  • Temporary Table
    by Lee John
    6 Replies
    Last post by ManiD
      • Dear all, I have two store procedures,sp1 and sp2 sp1 : some codes here SELECT * INTO ##A FROM ATABLE sp2 : some codes here SELECT * FROM BTABLE LEFT JOIN ##A ON BTABLE.a= ##A.b I use vb.net to call sp1 first and fill the data to dataset,then call sp2 and fill the data to dataset. So you find that sp2 is left join to ##A. ##A is a result from sp1. If I run sp1 fi
  • Remote access to sql server
    by GraemeP
    14 Replies
    Last post by GraemeP
      • Hi, I use a VS2005 application with a sql database. All is working well over a local network but I now want remote access to the system via the internet. Is this possible I have a fixed IP address & am wondering if I can just use the ip address as part of the connection string (And if so - how!)
  • Can't change TCP Port using configuration manager for x64 SQL 2005 SP1 virtual instance
    by MikeL.
    8 Replies
    Last post by NNagpal
      • Hi, I hope someone can help me!   I changed the TCP port that the default instance of SQL 2005 x64 SP1 is listening on and now SQL server won't start as the port is being used - no problem I say to myself, I'll just change it again, however I can't!   My problem is that I can not change the TCP Port back again using Configuration Manager - no matter what values I put in
  • how to excute a query in CLR function? thanks
    by davidw
    0 Replies
    Last post by davidw
      • Since it doesn't allow run dynamic query in a sql function, so I am thinking to create a CLR function to run dynamic query and call the CLR function in my sql funciton, is that a good idea and how should I call the dynamic sql query thanks