SQL Server

Page 5875




  • Topics
    Replies
    Last post
  • Email as csv using Database Mail
    by Steve McCall
    3 Replies
    Last post by Vidhya Sagar
      • Hi everyone, I'm having problems sending my query results as a csv file. Ideally I would be able to send my results from a sql job every night as a csv but I'm having problems doing it. My code is shown below Code Block EXEC msdb.dbo.sp_send_dbmail @profile_name = 'admin' ,@recipients = m@m.com ,@subject = 'Notification Created Today' ,@attach_query_result_as_file = 1
  • convert timestamp to datetime
    by DLG007
    5 Replies
    Last post by Samnieng
      • Dear all, Could anyone advise how to convert timestemp to Datetime value using T-SQL for exmple of timestamp 0x00083D9C95BBF180 and I want to have it in readable datetime. Many thanks LG
  • Unable to make changes to disconnected recordset
    by Jason Callas
    2 Replies
    Last post by joeydj
      • Its been almost 10 years since I have had to do work with good-old RecordSet objects... I am filling a RecordSet with data returned from a SQL server via a stored procedure. I then set the ActiveConnection property to Nothing in order to disconnect it so I can make changes to it. But when I try to set the value on a given row I get back a "Multiple-step operation generated error
  • What is wrong with my codes to connect VB.net to sql server 2005 Express database?
    by Curious Person
    8 Replies
    Last post by Curious Person
      • Hi am very new with VB.net (Visual Studio 2005) and the first time try to use the sql server 2005 express. I did create a trial.mdf (local server) and complete procedure to attach the trial1.mdf in Microsoft SQL Management Studio Express. I try to use VB to connect /open/close it with the following codes: (but failed) ----------------------------------------------- Imports System.Data.Sql
  • I am new this SSIS, Please help me.
    by Sridhar Babu
    5 Replies
    Last post by misha_m83
      • Hi, I am working on .Net tech with SQL Server 2000. I want to update my technical skills to DW. I mean, i planning to learn SSIS and i am new this topic. Please help me........ thanks babu
  • No Parameter Pane when Reporting in 2005 against a 2000 AS Cube
    by Will Riley
    2 Replies
    Last post by Will Riley
      • I have this strange issue. VS2005 SSRS2005 SSAS2000 cube based on data from SQL 2005 database When i connect to the SSAS cube and create a dataset in a SSRS 2005 report i do not get a parameter pane. Also, if i right click on a dimension & select "Add to filter" i get the following error message "Object reference not set to an instance of an object&
  • Rolling back transactions for multiple Stored PRocs
    by A..J.
    1 Replies
    Last post by jwelch
      • I have a quick question. I need to execute some stored procedures in certain steps... all performing some inserts/updates What i need is, a mechanism, by which i can roll back to the previous state if i encounter an exception (either in the app or SP) so, if the my first two SP execute fine, perform their functionality like insert/update, and the third one fails... how can i roll back to the init
  • Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.
    by Fredrik Melin
    14 Replies
    Last post by pablo-ms
      • If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our
  • Problem With Common Table Expression (CTE)
    by Amytdev
    3 Replies
    Last post by Louis Davidson
      • I constructed the following but I get an error results trying to run it. What am I doing wrong Error: Msg 530, Level 16, State 1, Line 1 The statement terminated. The maximum recursion 2 has been exhausted before statement completion. WITH AllPNBom ( [Parent Part Number] , [Component Part Number] , ItemId , ParentId , Part_Class , HLevel ) AS ( -- Anchor mem
  • Upgrading memory in a SQL 2005 2 node active/passive cluster
    by Cutatl26sdf
    3 Replies
    Last post by Cutatl26sdf
      • Could someone give me an ideal of what it takes to upgrade the memory in my cluster. Is it as easy has upgrading the passive node, switching the nodes, then upgrading the other server. And do I need to re-configure the windows cluster. And will both server need to be down at the same time at any point. Or is their more to the process Thanks for any assistance. btw, I currently have 1
  • Differences between 2000 and 2005
    by fleo
    13 Replies
    Last post by fleo
      • Hi, Just want to validate that, contrary to 2000, 2005 will tolerate the use of SELECT statements within functions. Thanks
  • passing datetime variables into a bcp statement
    by syvers
    5 Replies
    Last post by syvers
      • Hi I posted a question a while back about passing dates through a BCP SQL statement and received the answer that they should look as follows declare @sql as varchar ( 1000 ) select @sql = 'bcp "Exec CHC_Data_V2..TestSP ''05/01/07'', ''01/01/07''" queryout "c:\entitytext.txt" -SAJR\SQLEXPRESS -T -c -t' exec master .. xp_cmdshell @sql Now I need
  • Hiding/Showing columns based on the columns present in the dataset
    by Digant Desai
    2 Replies
    Last post by Digant Desai
      • I have query which retrieves multiple column vary from 5 to 15 based on input parameter passed.I am using table to map all this column.If column is not retrieved in the dataset(I am not talking abt Null data but column is completely missing) then I want to hide it in my report. Can I do that Any reply showing me the right way is appricited. -Thanks, Digs
  • Security exception when calling custom code from a report.
    by paulballard
    9 Replies
    Last post by Lukasz Pawlowski -- MS
      • Hello, When I run my report from within visual studio 2005 it generates just fine. However, when I run the report from the reporting services local web site I get the following error. What do I need to do to fix this (temporarily turning off .net security uusing caspol didn't work). An error occurred while executing OnInit: Request for the permission of type 'System.Security.Permission
  • 0xC020801C Connection error
    by kix_eytin
    3 Replies
    Last post by karfast
      • can someone please help me with this. Cause im really stuck now. Here's my code snippet. My database do also require a password but i'm not sure on how will i insert it in the connection string. Thanks alot in advance. cnOLEDB.Name = "MyOLEDBConnection" cnOLEDB.ConnectionString = "Data Source=AV_SRV;Initial Catalog=AdventureWorks;Provider=SQLNCLI.1;Integrated Securit
  • offline OLAP Cube +MDX
    by Tewari
    2 Replies
    Last post by Tewari
      • I will be really very much greatful to one who can help me out as I have been struggling to solve this from 2 months. I have a .mdb database and I want to craete a pivot from it.The size of the database is around 400 MB so it was suggested to create a cube from this database and then create pivot.The database is populated with TOTAL values for all its class variables . When I create cube fro
  • Help with validation query to show "duplicates"
    by Carl M.
    14 Replies
    Last post by hunchback
      • Code Snippet CREATE TABLE Charges ( ChargeID INT IDENTITY( 1 , 1 ) NOT NULL, , CustID INT , ProcedureCode INT , ChargeDate DATETIME ) BUSINESS RULE: This is a procedure that cannot be charged more than once a month DECLARE @ProcedureCode INT , @Month INT SET @ProcedureCode = 1234 SET @Month
  • results of stored proc to temp table
    by mflancour
    4 Replies
    Last post by Kent Waldrop Jn07
      • I am writing a stored proc that needs to place the results of other stored procs into temp tables. I tried: insert INTO #temp_data EXEC ekg..sp_junk but received this error: An INSERT EXEC statement cannot be nested.
  • compact sqlce database
    by Qiuwei
    5 Replies
    Last post by Qiuwei
      • Hi, there; I got a SqlCe2.0 database here called JOB.sdf, size is 260K. When I tried to compact it, it took very long and that JOB.sdf.tmp was created with 27.7M!!!, I can still open table in the database, but I found that there is some invalid data (unreadable square boxes). It looks like database was corrupted. My application gave error: Error Code: 80040E14 Message : The OLE DB Execute
  • pivot transform help
    by scb2376
    2 Replies
    Last post by scb2376
      • I need to transform the following layout by hopefully using the pivot transform, but am confused about the editor ......I have a compound primary key that I want to keep intact but then values in the row need to be broken out into their own row. I need to go from this... PKcol1 PKcol2 PKcol3 col4 col5 col6 col7 A 2007 1 Y N N N A 2007 2 Y
  • Problems after installing SP2
    by Kevin Dente
    7 Replies
    Last post by Jeroen Alblas
      • I'm having some major problems with SSAS after installing SP2 (I never had an SP2 CTP installed, just SP1). When I bring up BI Studio and select Open/Analysis Service Database, put in my server name (which is on the same machine that I'm running BI Studio), the click the "Database" drop down to select a database, it shows the following error in the bottom of the dialog: Errors in the OLA
  • And/or filter field not enabled in the group filter tab
    by Nathan Tregillus
    11 Replies
    Last post by JCampos
      • Howdy, I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don¡¯t want) but if I put any other value in to the expression
  • I want to install SSIS on a 64 bit server without SQL Server on it
    by Josh557197
    1 Replies
    Last post by jwelch
      • I want to install SSIS on a 64 bit server without SQL Server on it. Say I want to install the SSIS engine on one server and have it call packages stored on another servers msdb. It this possible
  • How to view/edit SSIS packages already created?
    by Jay87
    4 Replies
    Last post by Jay87
      • I created a few in SqlServer2005 DEV version and ran them manually with success. But where are they I chose the SqlServer storage option and I see them when I create Job and steps but how do I view/edit these packages from SqlServer Mgmt. Studio The SSIS service is running.
  • IE7 and SSRS Document Map
    by Paul Mitchell
    14 Replies
    Last post by David Richer
      • The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6. Reporting Services version is SQL2000. Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS. Can anyone help or at least comment