[sql-server-2005] Forum Topics

To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel …

Hi i am making a stored procedure with multiple select statements when i execute them than different resultset are maken for each select statement all i need is to get one resultset from all select statements of sql quries in the stored procedure......HERE is the SP code..[CODE]SET NOCOUNT ON; Select …

HI I would Like to Know how can Display the error Message When Executing the SP .. and the Stored Procedure doesn't having any value to Fire the Event .. [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: <sabari,,Name> -- Create date: <Create Date,,> -- Description: …

Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was …

Sir, I am currently doing a project on "Pharmacy Management System". My question is "Can I used DataGridView to show the items that i have searched and the rest won't be visible??" If yes then can anyone give me the code for search button?? I have used the following code …

I have an intranet using php 5.3.8 on Server 2003 using IIS 6.0 and SQL 2005. I run a command to call a batch file that starts and stops sql server and then calls a stored procedure to delete records from a table Items and then refreshes the records from …

I want to create a SQL login in SQL2005. I tried creating it but it gives me error message [COLOR="Red"]"Create failed for login 'username'. User does not have permissions to perform this actions"[/COLOR] What to do now to create a SQL login in sql 2005

Hello everyone, I am developing a form in VB.Net and ASP.Net that enables a user to grab data from a SQL Server 2005 Express database and display the data on the screen depending on the search criteria that they provide. What would be the best way to go about doing …

Hey all... I have assigned a job to create back of the databases of our company, maintain it for 7 days and after 7 days delete the back... I have worked on this and make it up the following query but still confused on its authenticity. Please Check and tell …

hi i am trying to convert data from excel sheet to dataset\datatable using sqlserver2005 as backend, so anybody can help me . Thanx in advance.

What is the problem with the following login code? [code] Dim conn As SqlCommand = New SqlCommand("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts;Integrated Security=True") conn.Prepare() Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("select", conn.Connection) command.Parameters(1).Value = txtusername.Text command.Parameters(2).Value = txtpass.Text Dim i As Integer = command.ExecuteNonQuery conn.BeginExecuteNonQuery() If Page.IsValid Then Response.Redirect("~/salesbill.aspx") Else Lblerror.Text = "Username …

I have created a form in which there are various values such as Name, Address, Date of Birth etc. The user is also allowed to select an image in a picture box. I want to insert these values along with the Image into database in appropriate columns. Any help is …

Hello Everybody, I have used inner join with two tables to join them and tried to calculate the sum of rows. Now the table descriptions are- Table1- agent_business_collection (it stores business collection of an agent of different business packages) Table2 - agent_business_commission (it stores commission of an agent against different …

Can someone help and show me how to display using (VB.net) these two tables combined into one. I'm really struggling trying to figure this out after hours of work, I decided its time to ask for help! So in SQL Server 2005 I have the following tables... [B]Students[/B] PKId Cart_Id …

:'( Hello everyone, i wrote an application that makes database backups and zips them. Can anyone please tell me what i need to do in order to get the apllication to work on IIS 6 windows server 2003 SQL 05 1. The application works fine on machines for both XP …