[microsoft:sql-server] Forum Topics

Hi all, I now have four server SERVER A is acted as distribution server SERVER B, C is acted as publication server SERVER D is acted as subscription server A is located with same network segment with B and C. D is located with different network segment. Server B and …

please help me on how to search using vb 2005 to sql server 2005 and how to load and save an image to the database tnx.

hey i jsut have small question it might be silly but i am new to database and don`t know anything about SQL first is SQl the same thing as SQL server? second i have MS visual studio installed on my PC how can i start using SQL!!! like what is …

Im Using MS Visual Studio 2005 Profesional Edition with C#. I have a page that has two(2) drop down lists. The first drop down contains info that when selected will influence the results in the second drop down list. When the info from the second drop down list is clicked …

I am tryig to match records from a query in access to records stored in a table. I have a littel problem which i am trying to solve? Table1 -manufacturer -model (primary key) -picture Table2 -Deal -price Query1 -Model (this is in a query as it has been split from …

I am tryig to match records from a query in access to records stored in a table. I have a littel problem which i am trying to solve? Table1 -manufacturer -model (primary key) -picture Query1 -Model (this is in a query as it has been split from other data using …

Hello. I'll get to the point. I need to add new rows to table2 depending on the data found in table1. I've tried a small query I wrote up myself but I doubt it will work and can't risk screwing this database up. Note: These tables are extremely long, one …

Hello. I'm running an client installer for a program which populates a database running in a MSSQL instance over the internet using a system DSN ODBC connection. The ODBC connection tests work but the installer fails at a certain point with the error "RPC server unavailable". I've posted this on …

hi i am displaying DATA retreived from the backend sql in table format. select col1,col2,col3..... from table1. Now i want to store col2,col3 in an array .and i want to add col2 and col3 values and display the result in col4. col1,col2,col3 are retrived from the database. please give me …

I have a page.. call it page1. it has a button_click event that fires some sql stuff and the does a response.redirect("page2.aspx?ID=1") page2.aspx we do some things and then click a button and that button does a response.redirect("page1.aspx?ID=1") now.. when page1 comes back up, and i try to click on …

hi i am displaying the data retrived from the database in table format. say col1 col2 col3 col4 12 15 15 13 15 16 the data displayed in col1,col2,col3 are retrieved from the database. now the problem is now i have to compute value for col4 (i.e col4= (15+15)/4) using …

I am trying to come up with a SQL query that will read timestamps from a table cross-referenced with the groups and individuals. What I want is results for each person on any given day with the first and last (min/max) EventTime. With the tables below, for example, an entry …

Hello All, first time post here and really stuck on this issue. I have 4 Tables that i am Joining Across. Each one of the tables has around 800,000 Rows in it. I am Joining them all on a field Called MDRReport Key. my query looks like this SELECT Mdrfoit.MDRReportKey, …

how to write a query to insert a row that is deleted from one table to another table using sql server 2000 at the same time

Hi you wonderful helpers who generously give your time away to help the less competent :) I thought this would be an easy task but I'm not an advanced SQL guy and don't know how to use an inner join, which apparently I need to use. I have two tables …

Hi I have the following code which generates an error 'Data Type mismatch in criteria expression' The purpose of the code is to write a value to a database at a specific row. [CODE] Dim IntSid As String Dim Sid As String Dim I As Integer IntSid = Me.TTIn.Text Sid …

When i try to install MS SQL 2000 on Windows XP machine it says that server component is not supported by this OS.What should i do get it run on this machine?

Hello Dani, I want Your help,How to Insert,Delete,Update,Edit using Vb.net(Windows Application) BackEnd(Sql Server 2005) Can U send Me Coding Example: 1.Login Form 2.Registration Form

I was wondering if anyone could offer a solution to this database design problem. I have very little experience with relational databases in Access. I have only used databases just to get easy data, but now it is starting to get complicated. I read a little on relational database design, …

I'm in the process of making a searchable database for the company I work at, and have run into a few problems. I've googled this stuff and had problems either understanding what I found or finding anything at all.. A. Sorting the table in my form I'm able to sort …

Hello all I am new in asp . I have write a pagging code in it connected with sql server database . But problem is that it show the record at multiple pages. suppose name of user one is show at page one , Its again show in page two …

hi every one, i want to know about configuring sql mail.i have sql server on my computer and i want to configure it to send sql mail.i want to know which account i have to use as local system account is not being accepted.when i try to create seperate account,i …

When i m strating the sql server 2005 , it asks me the server name.. What is the server name that i have to enter for the connection.. thanx.

How can i copy Tables from mssql server from my computer to oder /from my server to oder/. The Data Bases are ready created i must put only the Tables to oder DB. Please can you tell me how?

I am using VS 2005 to connect to my MS SQL server. I dont have remote access or anyother way of getting into the box. I am missing Object Explorer in the vs. I need this in order to set some contraints on the database. Is there a way to …

I am trying to do some constraints on a database. Since I dont have the object explorer option. What is the command line syntax for a constraint

hi, does anybody know how to update garbled characters that are being stored in the database..i am storing vietnamese characters in my db and found out that it some characters are garbled appeared as ? or squares... any help is grately appreciated..thanks in advance.. :):)

How do you check free space or space used within an MDF? The "Percent Log Used" performance condition alert doesn't check MDF files. The sp_spaceused is close, but combines all files, and sp_helpfile shows current file sizes and growth specs, but not free/used. How do you programatically get the same …

Hi, Im having a nightmare trying to install SQL server Evaluation Version onto Windows XP Pro. In the installation, at the service accounts section, it just wouldnt recognise any of the Windows Accounts that are on my machine, therefore i using a Local System Account so i could come back …

Hey everyone I want a where clause based off a variable input and I'm having some trouble with the syntax. My current code(incorrect) is below but it shows what I am aiming for. Does anyone have any suggestions? [CODE](CASE WHEN @inIndustry = 'ALL' THEN WHERE EXISTS (SELECT 1 FROM sysdba.C_PROJECTREVENUE …

I'm trying to migrate some code to generate an rss feed from classic ASP to .NET (because its cleaner). I've got it working perfectly for the first feed I try, but when I tried to modify the code for the next feed I get a [B] [I]Specified cast is not …

Hi, I've installed: Microsoft Visual C# 2005 Express Microsoft Visual Web Developer SQL Server 2005 Express How am I supposed to use sql server? Can I use it from both C# 2005 Express and VWD? I haven't got a clue whats going on, I can't even uninstall sql server. Is …

I need to filter the results from a database by year, and so far I have tried several different things, I will list a couple of examples below, I would like to use this one: [code] ServiceAndTeamContributionsBindingSource.Filter = String.Format("WHERE datePart('YYYY',BeginYear) <= '" & endDateBox.Text & "' AND datePart('YYYY',BeginYear) >= '" …

Hi all, I am using GetChunk() and AppendChunk() in Vb 6.0 methods to retirve the data from image fields in MS SQL 2000, I hav a question , weather the same Methods can be used for retriving or saving the data to the "Text or Numeric or Date " etc …

I have 2 problems I need your help please: 1- How can I map the result of a select query? let's say that I have a table named "Item" and I need to delete a specific item record from this table. So the user first needs to see the information …

Hi, Can anyone send me the Stored Procedure for "sp_validateUser" for login page using asp.net 1.1 Thanks.

hi every one, iam a newbie in .net,i have a application in which i have to send email using triggers.can any one plz help, on how to configure sql mail .my application needs to delete rows on completion of expiry date and send the administrator email notifying it. ok waiting …

Hi, Can anyone send me the Stored Procedure for "sp_validateUser" for login page using asp.net 1.1 Thanks.

am making a CMS solution and need help to get out an article list. The reason why this is a bit tricky is because articles does not have the same fields stored in one static article-table. In tblArticle all standard information about each article is stored. In tblArticleAttribute all different …

is there any body who know coding for Save and Load Picture on Database (SQL 2000) thnx Yasir

Greetings, I have a trigger created for table ABC to delete records from other tables connected to table ABC's key. When I run the query from the SQL Server Management, it works without error. However, when I call sqlDataSource's Delete(), it seems like it's not firing the triggers. Is it …

Hi All, I'm unable to install MS SQL Server 2000 Developer on Windows XP. Windows XP service pack 2 is installed. When I start setup, it does something for 2-3 seconds and nothing happens. When start setup again it shows that setup already running. But it does nothing. Please help …

I need to write a query that pulls out Zip codes by the first three characters, so I started with this: [code] SELECT SUBSTRING(Zip, 1, 3) FROM AvailHomeZips AS tZip [/code] But I would also like to query out the zips by those substrings I pulled out, so that would …

Hi there I want to display information regarding product with product pictures. information is saved in sql server and images are save in harddrive director Images/Pc100 where Pc100 is product code and image name in directory. can any one help me how to do in datarepeater/ or gridview. Senerio: when …

Hi, I created to data tables to hold information provided through peer reviews in the company that I work for. One table has 5 different levels of quality (unsatisfactory, meets some requirements, meets requirements, exceeds expectations greatly exceeds expectations), and another table that holds the data for each peer review …

Hey there! I'm a 43 year old who develops software for a large insurance company. I started developing in Foxpro 15 years ago. Since then I've delved into VB.Net, PHP, Java, C++ and now C#. I've worn numerous hats - developer, manager, business analyst, dba etc... I'm currently doing ASP.NET …

hello everyone, i m trying to add row in database through this code: [COLOR=green]Private[/COLOR][COLOR=green]Sub[/COLOR][COLOR=green] btnadd_Click([/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] sender [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.Object, [/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] e [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.EventArgs) [/COLOR][COLOR=green]Handles[/COLOR][COLOR=green] btnadd.Click[/COLOR] [COLOR=green]Dim[/COLOR] rowNew [COLOR=green]As[/COLOR] System.Data.DataRow = DataSet31.Tables(0).NewRow [COLOR=green]Dim[/COLOR] temp [COLOR=green]As[/COLOR] Random rowNew.Item(4) = temp Response.Write(rowNew.Item(4)) '** DataSet31.Tables(0).Rows.Add(rowNew) DataGrid1.EditItemIndex = DataGrid1.Items.Count DataGrid1.DataSource = DataSet31 DataGrid1.DataBind() [COLOR=green]End[/COLOR] [COLOR=green]Sub[/COLOR] [COLOR=green]but …

I am new to VB.net and i am not able to make the code for connection in VB.net. So any body can give the code for connection from sql server

I am working in ms access database2000 and my frontend is vb 6.0. I have three tables namely:- AREA:- areaid,areaname ROUTE:-routeid,routeno,routename,areaids PARTY:-partyid,lastname,firstname,address,areaid The field areaids in ROUTE table consists of chain of areaids belonging to that particular route in this format '12,23,65,67,' The problem is that i want to derive …

This 64 emulator written in Java has the ability to save! The author has patched it into an SQL database. Check it out!! [url]http://www.dreamfabric.com/c64/gotm/basicprogrammer.php[/url] I am gonna create a program and save it for others to run :) (I love commodore basic!)