Answer Questions

• nature0276 Failed to connect to sql server problem - a strange one!

  Full Error message is: Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476 When I consult the error log I see: Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum ...Show All

• Mark Benningfield What are the differences between MS SQL Server 2005 & Oracle 9i ?

  Hi guyz, I have basic knowledge of Sql Server 2005 and now i wanna move ahead in Oracle 9i ! So, i have 2 questions here - a)Whats the Difference between Sql Server 2005 and Oracle 9 i Note: Please keep the discussion general so that student like me can understand. I have never seen Oracle but the industry requirements suggest that Oracle is way better than than SQL Server 2005. But thats what i think b)I am Running Windows XP SP 2 and i would like to practise Oracle 9i. So, Where i can download it for free I know i have checked there website but they don't mention the difference between each version. Oracle does't market their products as well as Microsoft. Please , I am Student .. so i request you to make the discussion general . Thank ...Show All

• Danny Tuppeny Volume Distribution

  Hi Guys I Have not been able to solve this problem from quiete a while now. I am using sql server 2005. I have got a table which contains these columns - start date, end date and volumes if the month in the start date is same as that of end date, the volume remains same, else if the months in the two dates are different, then i have to distribute the volume in such a way that some part will go in the first month and the rest in the other month.. i have to somehow calculate (or prorate) the volume according to the no of days in each month I have to perform a query on this table so that I can group the volumes for different months and different years. Hope I have made this quite clear. Thanks Mita ...Show All

• Andre.Ziegler Problems with output variables when using varchar

  I am using c# in Visual Studio 2005 to run a stored procedure in a sql 2000 databse. this is the stored procedure CREATE procedure dbo.returnVendor4 @vendorID varchar(10), @name nvarchar output as select @name = vendor_Name from vendors where Code = @vendorID I steped through the c# code, it gives me an error when the procedure is ran (at the ExecuteNonQuery() part). this is the error message "String[0]: the Size property has an invalid size of 0." I have a similar procedure that returns an int, and it works okay. My c# code that calls the procedure is below string retVal ; SqlConnection con = new SqlConnection( "server = lissadell; database = s00048271; uid = s00048271; pwd = 'chocolate'&quo ...Show All

• Hokgiarto Change the date format of a smalldatetime column.

  Hello people. Please, is there any way to change the date format of a smalldatetime column of a table in SQL Server Express What I mean is that the default date format for a column which type is smalldatetime is "MM/dd/yyyy" but I'm developing a localized application and the date format that I would like to use is "dd/MM/yyyy", so I would like to know is if there any way to change this. I know that I could write some code in my application in order to do the conversion, but I would like to avoid this because I'm using the databinding property of the control and if I have to write a piece of code in order to do the conversion, I will loose this functionality. I'm currently using WindowsXP SP2, SQL Server Expr ...Show All

• Anarchy An attempt to attach an auto-named database for file......

  I've read through all the posts in this fourm that are related to the problem I'm getting with this error message on my main form, but none of the fixes seen to solve the problem. So I hope someone can get me pointed in the right direction. I'm running visual studio 2005 professional, and SQL Server 2005 Express Edition and this is a desktop application. I added the db file to the solution with the Add New Data Source wizard, I can create the datasets and preview the data correctly. An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. When I run ...Show All

• Jangu integration of 2 SQL 2005 DB Servers

  Hi, I have 2 database servers and each has same database.Program that inserts these databases randomly selects one of them to insert data.So only difference is data. I have to generate some report using these 2 sources.System administrators reject integrating these 2 servers into one. My question is , I want to run a query that looks the column x in table y and finds unique records in this table.But this works just in one DB.What do you recommend me to find solution that finds real unique records, i.e. looks both servers to find records. Is there a Microsoft product that may be configured brain of different DB Servers or any other solution I have also memory restrictions and data is considered as more than 100 GBytes for eac ...Show All

• AbdulMateen Updating records ina table

  Hi there!! I have a table say Emp with index as (Empid) which is a autoincreament field. How do I update names of already existing rows having identified Empid. Complexity lies with the fact that I cannot use Emp table as Destination table because if i do so then it will insert new rows and empid will change. Thanks and Regards Rahul Kumar, Software Engineer use an OLEDB command transform from within a dataflow (assuming that is where you have identified the employee to be updated). the Command transform will execute a parameterized sql command for each input row. do and UPDATE where empid = and bind your employee id to the parameter. Thanx a lot Jurgen Well I have found one m ...Show All

• vicarious Adding numerous login via script

  Hi, Can anyone point me in the direction of a script that incorporates sp_addlogin, which allows for adding 200 sql authentication logins from an excel spreadsheet, or a temporary sql table with the id info, containing the username, password, and def db I'm trying to avoid adding each new login one by one. EXEC sp_addlogin 'username', 'password', 'default database' Thanks, BPH A simple approach is to create an expression in your Excel spreadsheet that builds the Exec sp_addlogin line. Copy the formula down to all the rows, then copy/paste the value into Query Analyzer. If you have loaded the columns into a database table, you can execute a Select statement that builds the lines. Again, ...Show All

• MeDave Append new records from ODBC source

  I have created a data warehouse that pulls information from an ODBC source into a SQL database. The schema in the destination matches the source, and the packages clear the destination tables, then append all the records from the source. This is simpler than updating, appending new, and deleting on each table to get them in sync since there is no modify timestamp in the source. There are cases where I just want to append records from the source table that do not already exist in the destination table, without clearing the destination table first. How can this be done with a SSIS job Also, how can the job be run from a Windows Forms application Sounds good. Could you give me some detailed instructi ...Show All

• Susand Installing SQL server 2005 evaluation

  After unzipping the download I have run the splash.hta file. I then chose run the sql native client installation wizard. I then receive the installation package is not supported by this processor type. Contact your product vendor. I am installing this for a class I am taking on a test station. It is a PIII 863 with 512 MB or Ram, running windows 2003 enterprise server SP1. I have looked at the hardware guidelines and it seems this is enough to run it. Any ideas Across the top of the splash screen is says SQL Server 2005 (Disk 1 of 2). Then the start options, prepare, install, other information. At the bottom it has Microsoft SQL Server 2005 Evaluation edition. No where does it mention 64bit. ...Show All

• bpsmith Only One SSIS Job Runs...

  Hi, Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the packages on both jobs have the protection level set to "DontSaveSensitive". Both jobs have been deployed in the exact same manner, yet only one succeceeds and the other fails. Can anybody tell me why this is going on J.Suazo wrote: Hi, Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the pac ...Show All

• arashikage SQL Syntax Error

  Thanks in advance Below is basic sql script. I don't know why it has syntax error. Please explain why and advise correct answers. DECLARE @Date_Range VARCHAR (200); DECLARE @RowCount int ; SET @Date_Range = '(Date BETWEEN CONVERT(DATETIME, ''2006-11-1 00:00:00'', 102) AND CONVERT(DATETIME, ''2006-11-30 00:00:00'', 102))' ; SELECT @RowCount = Count (*) FROM MyTable WHERE (EmployeeID = 1111) And + @Date_Range; Line 9: Incorrect syntax near ';'. Thanks, Arnie. Would you please explain your way. I am new too this area. Snow: You need to change this to something like this: DECLARE @loDate datetime ...Show All

• Paradigm Shift Adding Identity

  how can i change a column attribute using alter table in sql server 2005. i want to add an identity property to my column userid , which deosn't have an identity property defined when created. i tried this. alter table userlookup alter column userid int identity ( 1 , 1 ) not null i got this error: Incorrect syntax near the keyword 'identity'. Open management studio go to the table you need to alter open the Modify context menu edit changes now right click and use the last menu item: Generate script for changes You can use this way to know scripting template for any change you need. In that case you will see that SSMS will create a temp table, performs a bulk insert, ...Show All

• Michael Dyrnaes To create data mart or not

  UDM provides us a chance without creating data mart. How do we know when to create or not to create the data mart which then interact with the cube ( or rather the other way round :) ) Regards Alu Have a look at this previous thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=801915&SiteID=1 HTH Thomas Ivarsson Hi thanks for the thread. Regards Alu Hi do you know what are the most time consuming /complex queries that may easily lead to time- out expired. i would like to simulate the time difference to use UDM and without ( ie normal queries) so that I can vertified the usage.Thanks. Regards Alu ...Show All