[microsoft:sql-server] Forum Topics

I have database for a project i'm working on. yesterday i restored it from an old backup and the schema changed back to a earlier state. but now all the sstored procedures , views etc are missing and the project system can't use it and work. so is there any …

Hello, I was wondering does anyone have an idea how to make a dropdown menu that dosent repeat values from the SQL Server? Perferably using a while loop. I was thinking of camparing the set values with the new values as it loops through them but im not sure. -Thanks

Hi, what would you recommend as the best book for someone *new* to SQL and SQL Server (specifically 2005, Developer version)? Thanks!

Hi guys, I'm learning basic SQL. I have a query I can't solve. Need to create a query named Task1D to list the last name, first name, number of matches, total number of points, for players who have played more than 10 matches and scored more than 330. A portion …

Greetings - I need your help. I have an SSIS package with a [icode]Data Flow Task[/icode] which has the following Data Flow tasks: [icode]Excel Source[/icode] -> [icode]Data Conversion[/icode] -> [icode]SQL Server Destination[/icode]. The data in my Excel worksheet contains strings as well as numbers. (Also has some blank cells.) I'm …

Hello Forum, I am new to SQL Server and have inherited a database from another developer. I have a Stored Procedure that I'm trying to use in my vb.net program to fill a form with multiple datagrids. The Stored Proc looks like this: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go …

Hello guys. I'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when …

Hello I'm working a website that is going to be very,very critical. For now, there is one MSSQL 2005 database online. I'm trying to figure out how to setup mirroring for two MSSQL Servers. (Like two mirrored servers) I understand that you can setup a mirroring like "Server", "Server backup" …

Hi, im trying to populate each datagrid with an individual record from a table by using a loop - ideally id like something like this below [code] using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.IO; using System.Data; using System.Data.SqlClient; public partial class Default2 : …

Hi, im learning ASP.net and SQL Server and im verrrry new! i have followed an excellent tutorial (and besides some authentication issues with SQL Server it has gone swimmingly) :) ([url]http://www.aspsnippets.com/Articles/Display-images-from-SQL-Server-Database-in-ASP.Net-GridView-control.aspx[/url]) however im struggling to understand exactly what i have done in this tutorial (obviously following a tutorial is easy …

Hi everyone, Wondering if anyone can assist me with this; I've done some googling but haven't come across anything. We have a dedicated server running SQL Server 2005, express edition. I recently set up the server to allow remote connections to the DB engine and everything is working just fine. …

hi guys. its been a long time but sincerely, am happy to be back. now i've got a problem on my mind and that is; am trying to develop a database application but i want it to be a console application. the major issue is that i dont know how …

hi guys i need help with date time picker.What i am trying to do is to select data from table according to teh date selected by the user .My code looks like this but it doesnt work, it doesnt pull anything, can anyone help me with where am i going …

Hi there! I´m with some difficult to do this query. I have this: [CODE]SELECT IDReport AS [ID Report], IDHardware AS [ID Hardware], DataHoraReport AS [Último Report], Versao AS Versão, DataInstalacao AS Instalação, DataUltimaActualizacao AS [Última Actualização] FROM Report[/CODE] in which result this: [URL="http://img189.imageshack.us/img189/6872/26352213.png"]http://img189.imageshack.us/img189/6872/26352213.png[/URL] How can i query those results to …

Dear Members, I am developing a desktop application on “Attendance and Payroll Management System”. To develop this I am using [B]C# and MS SQL Server 2005[/B]. I would like to build this based on [B]Unicode characters so that all the data from user interface can be stored in the database …

Hi Buddies, Can anybody give me the sample to do sql connection through windows authentication through asp.net? I was tried lot of ways. but it throughs empty value for the username and access denied. Please help me to solve this issue.

Hi, Everybody, I wrote the program to connect to the Microsoft Sql server 2000. I have also defined constrains and triggers on Tables of SQL. Now I want to catch the error message generated by the triggers or constraints in c prog and want to show it to user. Can …

Hi, I've got a DropDown list which is populated here. with the use of a break in the code there is a value of 4 for shippingInfo.ShippingID.ToString() [code] if (addressOK) //&& cardOK { int shippingRegionId = int.Parse(Profile.ShippingRegion); List<ShippingInfo> shippingInfoData = CommerceLibAccess.GetShippingInfo(shippingRegionId); foreach (ShippingInfo shippingInfo in shippingInfoData) { shippingSelection.Items.Add( new ListItem(shippingInfo.ShippingType, …

Hi I have zero knowledge about sql,databases,mssql etc etc. I have installed MSSQL 2005 express edition. What i need i have two access files say data1.mdb and data2.mdb. i need to create a database database1 which has tables from both data1.mdb and data2.mdb. Please tell me how i can do …

[COLOR="Red"]I can't login on the server giving error: 17892. I want to drop the trigger but , as soon as I tried to login, the trigger(Tr_ServerLogon) get executed and login failed.[/COLOR] [CODE] CREATE TRIGGER Tr_ServerLogon ON ALL SERVER FOR LOGON AS BEGIN INSERT INTO AuditDb.dbo.ServerLogonHistory SELECT SYSTEM_USER,USER,@@SPID,GETDATE() END GO /*Where …

Hello again I have 1 well working function and one working stored procedure which counts the quantity of rows in table. Now I've created special table which has only two rows 1. Id (int null)(!++) 2. Rows(int not null) In Rows I want to store the quantity of rows from …

Hi, I am having a table which contains emp_name, basic_pay, PF, other_info. Now i want to display as, emp_name1 basic_pay emp_name1 PF emp_name1 Other_info Like this, Instead of displaying in single row, i want to display in different row based on that emp_name. How Can I achieve this.

Hi Folks: The following is the complete coding for an application which I wrote to move data from sql 2000 to MS Access 2003. The coding looks fine to me but I am still getting an error. Could someone tell me what I am doing wrong. Thanks in advance Bob …

Can someone help with with a script to find broken links in the url column of a sql database and set it as broken in the status column?

I have an mssql database that I need to migrate to mysql. For some reason though any queries to any columns of type datetime are returned in French in the following format: 7/avr/2004 14:00 This also includes all the text of an SQL dump which not surprisingly makes mysql unable …

This is a logic question (or at least I think it is). What happens when the select term and group by term do not match? Why? The sample code is here: [CODE] SELECT [B]Name[/B], max(Age) FROM People GROUP BY [B]Name[/B][/CODE] So what happens if those two bolded field names do …

Hello All, I am new to SQL Server 2008.I was just wondering if there is any way to add a user as an admin in SQL Server 2008? Is it possible to do using SQL Server Management Studio? Thanks.

Hi i am using c# as my language & sql server as my database .. My question is there is no key ward called [CODE]limit[/CODE] in sqlserver....how i solve this type of question... the example is ---> the sql server data table has 25 rows & i want to retrieve …

I have a dynamic SQL statement to insert data into a memory table from a source table. The problem is, one of my variables, when run, evaluates out to a name of a column in the table I'm selecting from. I need it to be the column name, not whats …

I have a table having shop details where shop opening and closing time are available. My need is to find shops that are open in a time range supplied. For Example: Shop1 opens at 9 pm and closes next day at 4 am. Shop2 opens at 1 pm and closes …

Hello, I have looked over many examples of how to populate a dropdown with rows like [code=php] $sql="SELECT id, thing FROM table"; $result=sqlsrv_query($conn,$sql) or die("Couldn't execut query"); while ($data=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){ $id=$row["id"]; $thing=$row["thing"]; $options.="<option value=\"$id\">".$thing "</option>"; } [/code] But i need to populate this list with tables and will need to …

Hi , I need help with select staement.I am trying to to look for a word in column word .If i find that word then then show a message box that this word exist in databse.Can anyone help me with this.my code is something like this [code]private void dataGridView2_CellContentClick(object sender, …

hi there, i have a mask textbox in C# which saves $9999999999.99 as the mask, i have a database field should take the value and save it. the database feield is in money .but when i am writing the C# method to insert it into the data i convert the …

Hi, I am trying to learn how to create relations I got a sample from a web site and it works great, but when I tried to make one; it is not working. Can some one tell me what I am doing wrong. It gets down to the last relation …

Hi I have installed Microsoft SQL SERVER 2005. This consists of the Configuration tools(SQL server configuration manager,SQL Error and usage Reporting, Sql Sever Surface area configuration, Reporting Services configuration) and SQL Server Management Studio. However I dont find SQL Server Business Intelligence Development Studio. Can anybody tell me how to …

Hi, I am a c# learner and I have got a problem - I have not much clue, please help. I have a windows form with two text boxes and a button called 'save'. If I click the save button - It should connect to the sql server express then …

can naybody help me how can i get data from sql database and display it in a listbox or combobox? thanks for the help.

I've seen a few posts on here talking about "databases" as if they were just files and using fstream to manipulate the file pointer, etc. I'm familiar with SQL, so it would be nice to simply be able to execute sql command (as can be done from vb.net) such as: …

im making a ASP.NET web application using a serverside database. Hi :), im making a ASP.net web application with a sqlserver backend database. i have been requested to provide both UML and ERD/Normalization i can do both of these techniques individually to a reasonable standard, however i am unsure about …

Evening, I have built a program with full SQL functionality (from pulling to adding etc). I am using stored proceedures for the SQL queries. I seem to have a problem when adding / updating a SQL VARCHAR column when the item being added / updated has a space (ie 'Add …

I have exported data from sql server to access but the views are exported as tables can you pls tell me how to convert sql server views to ms access 2003 queries please help...urgent

I have a timer that runs a SQL query every 30 seconds to retrieve updated information. Unfortunately every time the query runs the vertical scroll bar resets to the top most part of the form. I tried [CODE=c#] int scrollPosition = this.VerticalScroll.Value; [/CODE] at the beginning of the timer code …

:unsure: I dont know y this happens...i try a lot of times but....anyways, the problem is that, the crystal report does not show the actual result when an sql query is being used to extract data, even from a single table...while it runs correcty in MS Access where i have …

hi guys i am trying to fill datagrid from database.I using the following code.Can anyone tell me what am i doing wrong. [code] public Form1() { InitializeComponent(); richTextBox1.Text = "Word: I \nDefinition:"; richTextBox3.Text = "Word: I \nDefinition:"; label2.Text = "Hindi"; dateTimePicker1.Visible = false; SqlDataAdapter dtadp = new SqlDataAdapter(); DataTable dtbl …

I have tried to upload the xml file into a column with xml type of the database table I use sql statement like: [COde=sql]USE xml_tbl go INSERT INTO xml_tbl(Filename,DATA) SELECT 'file1' a,* FROM OPENROWSET( BULK 'C:\XML\file1.xml' ,SINGLE_CLOB) as a [/COde] or into the existing column: [COde=sql]update tbl_xml set data = …

Hello I want to move pictures vertically in ASp page. I will take the pictures from sql data base. but I don't know how I can display them. please help

Hi, i'm using .Net framework 1.0 & MS Access 2003 database. Using ODBC connection, I want to list all tables in ms access database in a listbox....Please help me.... very urgent...

Hello, I have a website (in development) with sql express 2005 db, and I want to upgrade to express R2 2008 version (mainly because of 10gb vs 4gb max db size), how do I do that?, I have win xp os do I need to upgrade to win7? Also I …

When I edit the information from a database table from my program I have made, I get this error: [COLOR="Red"]Cannot update identity column 'ID'.[/COLOR] How do I [COLOR="Red"]SET IDENTITY_INSERT[/COLOR] To ON?

hey, how can i update the database of SQL server 2008 while using win application as front end thanks prajaktaran