Answer Questions

• Peter Nowak (Germany) attribute date of type numeric to datetime...!

  hi everyone..!! how can I turn an attribute date of type numeric of a table and pass it to another table (using SSIS) as datetime The 'trick' is usually, that if the 'date' is stored as a number, you must find out what the numbers represent. eg 12345 - is this seconds, minutes, hours And counting from when Once you know the time-unit the numbers are using, and the starting point, you can use the dat ...Show All

• Prajkta Poison Messages - 5 times's a charm

  Hello again, I have some poison message detection in place, based on the BOL sample. My problem is that after the 5th message retry my queue goes down - that is the fifth retry on any message. In actuallity, the first message is retried 3 times and it is taken off the queue [for real], the second message comes in and on the second retry - pooof - the queue is down. I though the poison mechanism should work on a per message basis. It there a set ...Show All

• Bhawna compare two text files

  Dear all, What software can compare two text files They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily. Please give me some suggestions. Thanks. Alex thanks Eisa. it is helpful. Could you suggest some freewares Windows has a command line utility (fc) that compares two files. Type "fc / &qu ...Show All

• abinaysh How can i insert a default row if it doenst exists already?

  Hi, I am currently loading dimensions using a Sql Server Destination and i was wondering if i can create a middle step to insert a certain row so i would identify in my dimension the undefined records... I know i can do it with sql statement but i was wondering if there is a better way. Best Regards, Luis Simoes Would this not be part of the fact load, you wish to infer the dim member from the fact data when there is not already ...Show All

• Shirley11772 Fail to Connect Report Service via Management Studio

  Dear sir, I installed a copy of SQL Server 2005 Evaluation Edition in my XP Professional Computer. When I try to connect to Report Service using Management Studio, it fails to connect with the following error: ********************************************** TITLE: Connect to Server ------------------------------ Cannot connect to XXXXXXXXXXXX ------------------------------ ADDITIONAL INFORMATION: The server committed a protocol violation. Sect ...Show All

• Khalilme one to one relationship

  How do I create a one to one relationship in a SQL2005 Express database The foreign key needs to be the same as the primary key so it can't just increment to the next number. Oops, it is indeed a function sorry about that typo :-( You're actually looking for the SCOPE_IDENTITY() function, not the @@SCOPE_IDENITY global variable. You'd use it like follows: declare @paren ...Show All

• Richard S Sql query for helpdesk application

  I am having a difficult time to create the following query. I am creating a vb.net command-line app that will produce a report from our helpdesk system on a scheduled basis. I have the following table structure timeStamp - Date/Time RuleID - Text(50) ResultId - Text(50) The RuleId are the Ids of the different server process that we monitor. The ResultId can be a 1 for Success, or 3 for Failure. Entries are only added during a falure, ...Show All

• bhamby TraceLog warning

  I have an application which makes massively reportserver requests to get a pdf. in the trace log the following entry appears: [6080] w3wp!runningjobs!5!28.02.2006-11:23:57:: w WARN: Thread pool pressure. Using current thread for a work item. What exactly does it mean does it mean that there are too much requests at one time for the reportserver regards patrick We too are receiving t ...Show All

• Bil Possible bug with SqlServer 2005 calling UDT Read method?

  Hi, I have a UDT written in C# that is formatted with UserDefined. I added the IBinarySerialize interface and it was implemented automatically by Visual Studio as follows: void IBinarySerialize .Read(System.IO. BinaryReader r) void IBinarySerialize .Write(System.IO. BinaryWriter w)   This compiles fine, and the assembly deploys fine. However, when I execute a call to a stored procedure and pass a UDT that has ...Show All

• koaybl TOP URGENT PLZ: SQL backup files

  I have installed Beta 2 over SQL Express and when i wanted to install either Beta 2 or Express it dosn't allow e and i need to backup my databases urgently how can i do that is it possibe to do it with the phisyical files found it.. by default it wil be in Program Files\SQL Server Folder\Data I'm afraid you are not being clear, it seems like you have expres installed and you need to ...Show All

• Diml New SQL Express Installation

  I just installed SQL Express in my workstation but when I try to create and ODBC connection, the new server does not show in the drop down. Do you have any tips... Thanks. Why ODBC out of curiousity Why not connect with ADO 2.8 or ADO.net using the new sql native client Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=myDatabaseName;Data Source=.\Sqlexpress ...Show All

• klem182 Problem with Dependencies and Default Values

  Dear Anyone, Im having trouble with RS2005 with regards to dependencies of report parameters and the default value. Below is my scenario: 1st parameter: List of Letters from A to Z Multiple Select 2nd Parameter: List of Names starting with the last name Uses 1 data set for list of values and default values Multiple Select Steps: Select 2 letters from the 1st parameter. This action would refresh the list o ...Show All

• evans Equivalent to Shift+Enter in Management Studio result grid cell?

  Is there a way to insert a line break into a cell when view table in Management Studio In Enterprise Management it was Shift+Enter, but that doesn't work in SQL 2005. For example, we have a column that contains address format, so we need to have multi line data (line break). When viewing data alredy in the table in a grid view using query, line breaks are not visible, but if switched to text view, the line breaks are visible. Programaticly or ...Show All

• Sazid Khan Server does not exist messages.. ?!

  We have recently upgraded our SQL Express 2005 server, to SQL Server Standard 2005. It refused to install a new default instance during install, so i upgraded the SQLEXPRESS instance instead. Im now trying to install Microsoft CRM but when it tries to connect to the SQL server get the following error: "Setup was unable to verify that the SQL Server Agent (SQLSERVERAGENT) was running." "[DBNETLIB][ConnectionOpen (Connect() ...Show All

• Zartor error: 40 with sql server 2000

  Hi I am getting this really annoying error that I cant resolve. I have created a website that accesses a SQL SERVER 2000 database and it works perfectly on my home machine. The error has occurred when I have transferred it to my hosts server. This is the error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default ...Show All