[microsoft:sql-server] Forum Topics

Hello all, I'm having the following problem, I have three tables, Person, Income, Outcome Person has the primary key : ID Income has two fields : PersonID [Foreign] and IncomeAmount Outcome has two fields : PersonID [foreign] and OutcomeAmount I need to make a query that gets the summation of …

hi friends I am new to SQL SERVER I am using sql server 2005 enterprise for server and express for client m/cs. Having issue while connecting from client to server. i have read some tutorials on net. while connecting to server from my client machine, i usually get error: 18452. …

hi, i have 3 cols in my db col 1 ( unique identifier ) col2 ( varchar ) col 3 ( integer ) how can i retrive the 3 greatest values from the database on the basis of col 3..

Hi guys, I am struggling to discover what the right syntax for my code would be. I use VWebDeveloper Express 2005 and I have a web form .On the Web form I have three dropdowns that are bound through datasets and a textbox.Dropdowns are linked to display only the info …

I have 2 tables Details,Mstr. Mstr table contains(PSNO,NAME,DOB,DOJ)=>PSNO- PK Details(PSNO,NAME,PH,SAL_ACC,ADV,DT_PREP)PSNO-FK In Grid i need to display SAL_ACC NAME ADV DT_PREP 12345 abc 150 5/25/2009 12345 abc 300 5/30/2009 12345 abc 200 6/11/2009 how do i do ths,please help

I need some help creating a query that will pull a series of record that falls with a date range with specific interval. for example: I would like pass in a date like getdate() - 10 for start date and getdate() for the end date. However, the dates in between …

I am trying to make an application that sorts a database with user input and returns a form. This form then accepts some user input, and then needs to be sorted in another event. I am using ado.net, and am attempting to complete this task by cloning a dataset and …

I am exporting a product table. I am exporting to a txt, tab delimited. I got the following error; Error 0xc020802e: Data Flow Task: The data type for "input column "ProductLink" (262)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT …

Has anyone moved their SQL Server's into a virtual environment using VMware? If so, what has your experience been like? thanks, GM

I made a small program for a Doctor's office, but I had to manually install SQL Server on the PC and manually create the Database and Tables. How do professionals make a program dynamically create a database? Do they even [B]use[/B] databases? Thank you for the info dudes.

I'm starting to learn SQL Server. As part of that effort, I'm experimenting with accessing AdventureWorks sample databases. In database AdventureWorks, I've been accessing table Person.Contact. Although in that table there are columns for a phone number and an email address, there are no columns for a postal address. I …

I’m trying to learn how to connect to an SQL Server database (I’m using the AdventureWorks sample database), but I’m having problems. Here’s the code I’m using: [code] // define connection string for database server string connectionString = "server=<server name>; database=AdventureWorks; uid=<user name>; pwd=;"; // no password // define SqlConnection …

i couldnt find the server explorer, where is it, i need to connect to sql express database.

Hi Friends! I have started building my first professional project(actually a web portal). that is kind of business project. I need full membership features. now what you think? If SqlMembership Povider in asp.net is enough for a professional application or not. should i create a custom membership provider. which one …

How can I uninstall the AdventureWorks sample databases? They're not an application, so I can't do it via Add / Remove Programs or a downloaded uninstaller. They're apparently corrupt, and they've been trouble from the git-go. The machine crashed when installing them. When I try to access them via SQL …

Logfile of HijackThis v1.99.1 Scan saved at 13:55, on 2009-03-13 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16791) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\system32\LEXBCES.EXE C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\LEXPPS.EXE C:\Program Files\Broadcom\ASFIPMon\AsfIpMon.exe C:\Program Files\Seagate\Basics\Service\SyncServicesBasics.exe C:\PROGRA~1\DIRECT~1\DUService.exe C:\PROGRA~1\McAfee\MSC\mcmscsvc.exe c:\PROGRA~1\COMMON~1\mcafee\mna\mcnasvc.exe c:\PROGRA~1\COMMON~1\mcafee\mcproxy\mcproxy.exe C:\PROGRA~1\McAfee\VIRUSS~1\mcshield.exe C:\Program Files\McAfee\MPF\MPFSrv.exe C:\Program Files\Microsoft SQL Server\MSSQL$ALAMODE\Binn\sqlservr.exe C:\Program …

I am getting the following error sometimes. When the user load gets heavy I'll receive the following error. Would puting cftransaction around my update statements work? ODBC Error Code = 40001 (Serialization failure) DiagnosticsODBC Error Code = 40001 (Serialization failure Microsoft ODBC SQL Server Driver SQL Server Transaction (Process ID …

hi, i have a table with customer information(name, date of birth etc) i have created a windows form in c# and binded it with the database. the thing i want is retrieve the DOB from database and calculate the customers current age n display in a label in the form;; …

Hi, I am trying to send the userId (which is a uniqueidentifier in the db) in a querystring. The receiving masterpage will then show data based on the user id. However, i am getting the error 'Conversion failed when converting from a character string to uniqueidentifier' I thought converting guid …

I am trying to select data from a database in the based on a condition....Its just a simple select SQL query [QUOTE]SELECT playerid FROM player WHERE username = 'John'[/QUOTE] Therefore, from this I would like to store John's playerid to a variable and then use this variable. Below is my …

HI I installed Visual Studio 2008,but I only installed C#.I want to create new database connection,so what I did is in Database connection->Add connection->select Data source But MS Sql server compact 3.5 and MS sql server database File are avaliable in here I cant find the sql native client,only MS …

Assuming it can be done (as I've been told): How do I import ".mdb" (MS Access / OleDb) files (specifically, Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)?

I am trying to select data from a database in the based on a condition....Its just a simple select SQL query [CODE]SELECT playerid FROM player WHERE username = 'John'[/CODE] Therefore, from this I would like to store John's playerid to a variable and then use this variable. Below is my …

I've installed SQL Server 2008 Express with Advanced Features, but I've been having so-far insurmountable problems installing the AdventureWorks sample databases. However, I've successfully installed the Northwind sample databases, and I've downloaded the installer for the Pubs sample databases, so: Can SQL Server 2008 access Northwind or Pubs databases?

Hi, I have finished coding a VB.Net application that has connection to SQL Express 2008 database. My question is, what steps do I have to take to make this a multi user application. FYI: There are 3 tables in the database of which two tables contain data to be viewed …

Good Morning Friends, I have a SP that is Supposed to Restore a Database from a Backup. In some Clients this works well but in those particular client its a Problem. The version is SQL 2005. Here is the Code that fails [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go …

hi I have got a table for internet accesswith user ID, it has 3 column user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet. can anyone please help me... thanks kaz

After some initial problems with the prerequisite installation of SQL Server Express with Advanced Features, I tried to install AdventureWorks sample databases. Upon launch of the installer, Windows cited Microsoft as AdventureWorks' publisher. I confirmed to the installer that it should run. A dialog box then came up saying something …

I am working on an ASP.Net website with SQL Server database and C# 2005 as the programming language. In my database I have two fields namely RDate and RTime. RDate stores the date of the record and RTime stores a time like 09:00 AM, 09:15 AM, 09:30 AM etc. The …

Hi Guys, I’m not a professional programmer so maybe you can help me out please… I am using Visual Studio 2005, Visual Basic and a SQL 2005 Database. Everything seems to be going ok but I do need 2 things. 1. How do I “Find” a record. Let’s say there’s …

hey guys, im having a little problem here. here's my code so far: [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con = New SqlConnection("Data Source=.\SQLExpress;Integrated Security=true; AttachDbFilename=C:\Users\Carlo\Documents\Visual Studio 2008\Projects\OTTO Payroll System\OTTO Payroll System\OTTOdBase.mdf;User Instance=true") con.Open() Try If CType(Me.ACCESSTableAdapter.ScalarQuery1(Me.UserBox.Text, _ Me.PassBox.Text, Me.PosBox.SelectedItem), Integer) > 0 Then …

I'm not a developer so I won't even pretend to know what I'm talking about. I just loaded CF 8.0 & DWCS3 and i'm trying to load an existing website that uses CF. I'm trying to set a data source and was sucessful with one of the sites that uses …

Hi there, I know that .net comes with an encapsulated control for both logging in and creating a new profile. These seem to work great on my local server but Im not shure how to deploy it to a remote server. WHERE IS THE CONNECTION STRING??? Its not in the …

Can I copy data from one database to another by a sql script? I have an active database we'll call dbo.active and a temp database we'll call dbo.temp both are a customer list and all the customers in dbo.temp exist in dbo.active. I want to copy the notes from dbo.temp …

I heard of a sample database called Pub. Does anyone know about it? Is it an SQL Server sample database that, unlike AdventureWorks, doesn't require SQL Server's Full-text Search capability to install? That's what I need.

djodjo1989 Hello everybody, First sorry for my english because i'm French, here it goes, i'd like to add a new user, for example HelpDesktop to the localgroup Administrators, for example. But i disabled xp_cmdshell for security reasons and i renamed the xplog70.dll DLL. I know the easiest would be to …

I have an ASP.net 2.0 website with SQL Server as database and C# 2005 as the language. On my webpage I have a calender from which I choose a date and display only the date part in a textbox (readonly) in the format dd/mm/yyyy. But internally SQL Server uses m/d/y …

I am developing a windows based application in vb.net 2005 and data base is SQL2000 I have database named new base and table name is Trick and fields are ItId, ItName, ItPrice, ItQuantity, itstock Problem is that I want to populate data gridview through search data from text box but …

hey frnds,I have imports namespace System.Data.SqlClient.I just create object of SqlConnection,But error is there- 'SqlConnection' is ambiguous in the namespace 'System.Data.SqlClient'. .I know its a silly Question i m asking,But its not working..Plz help me out.. [code] Imports System.Data.SqlClient Public Class Form1 Dim conn As New SqlConnection End Class [/code]

Dear all I am asking about the MS SQL server certificates type & which of them I need as a web developer & what I need to study for passing MS Exam I wish an perfect answer & recommended tutorial I found a tutorial on for MS SQL server 2008 …

Hi, I hope I am in the right place for this... I am looking for some help with a query. Basically, I am using a shopping cart which has option groups and I have created 2 new option groups. I now need to add these option group id's to all …

all i want is change all the record in my table if the pcarrier="Credit" but my problem is only one data have been changes. . [code] Set rs = New ADODB.Recordset rs.Open "Select * from Soldto where cno='" & Combo1.Text & "'", cn, adOpenKeyset, adLockPessimistic If rs!pcarrier = "Credit" Then …

I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem. Then I attempted to install AdventureWorks Sample Databases for SQL Server 2008 (SQL2008.AdventureWorks_All_Databases.x86.msi). This attempt failed because SQL Server 2008 Express, basic edition doesn’t support Full-text Search, which AdventureWorks requires. So I uninstalled SQL Server 2008 …

I am developing ASP.net 2.0 website with SQL Server as database and C# 2005 as the programming language. In one of my tables, I have a filed named RTime of char datatype to store times. The values of this particular field are like 09:00 AM, 09:15 AM, 09:30 AM, ------ …

hello...hi im using VB.NET...can u guys teach me how to convert an Access database to a SQL server database? i really hope u all can help me.. thank you...

Can anyone tell me .why i am getting error item cannot be found in the collection corresponding to the requested name or ordinal.error is generating on bold line.Here is the code what i have written. [code=vb] Private Sub Command1_Click() y = MsgBox("do you add this record", vbYesNo + vbQuestion, "message") …

I have a stored procedure which returns a parameter @quotenum when run in sql but I'm having trouble getting a return value in my C# form. I'm trying to get the message box to show the @quoteno parameter but im failing misserably. The connection is working an the parameter @estnum …

Hiii I am developing one window application in c# and .net with sql server 2005 as database. now, i have Four questions: 1] I have one dropdownlist in form and i want to fetch the content/data of table category in to this dropdownlist and when I run this form on …

Hello Experts, I am fairly new to MS SQL Server 2005. I am trying to create a table where a column has the restriction of allowing alphas only. I know how to achieve this in Oracle using String functions. But am not able to do so in MSSql. The replace() …

I have created and tested a stored procedure that works in sql. This stored procedure has one parameter that it requires to run "quoteno" . I already have the database attached to the form. Can anyone help me with the code for this. The name of my stored procedure is …