[microsoft:sql-server] Forum Topics

[COLOR=black]I cannot login in the system. it gives this error. i m using sql server 2000. do i need to make changes in sql? plz help me. :sad: [/COLOR] [COLOR=black][/COLOR] [COLOR=black] [/COLOR] [COLOR=black]Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) Login failed for user 'Administrator'. Reason: Not associated …

Hi guys, Need some help in some query processing... Here goes,this is the results i have obtained so far |id |cat | name | 1 .....a apple 1 .....b banana 2 .....a austria 2 .....b brazil 2 .....c china 3 .....a abraham 3 .....c clinton Column cat can have at …

Hi guys, Let me describe the situation I am in. I have a table of 2000 objects and each object has a range of different prices associated with it, stored in another table. I have created a view which serves to list the objects as well as their average price. …

Hi, Is there any way of finding the modal (most frequent) occurrence of a value. I know that mode doesn't exist in the same way that count, avg and max do but is there any way to combine count and max in such a way to find the most frequent …

Primary responsibilities include providing technical and creative solutions for service delivery by visiting customer problems sites, while ensuring customer satisfaction with Microsoft SQL, Networking, BackOffice and Desktop software. The successful candidate will be capable of performing on-site support of on-going support activities including but not limited to Premier Support, supportability …

Am using VB.NET and SQL SERVER as the Backend. I used a text box and in the property window i set it to Multiline ie i made it to true and in the database for this field i put the data type as nvarchar and made it to 4000( ie …

From last two days i am searching for the answer of this querry. I want to know how can i access the rows of tables in stored procedures using loops(Without cursor). We don't want to use cursor for that because of the performance issues.

Hi..... i create a new user in mssql... user is --- kumar now i login to mssql by using the above user... now i login to mssql with another console by using administrator account..... now i try to delete the account(@ present in administrator account) -- kumar .... then the …

The server already had MSDE on it and another install of MSDE was done on the server, now the old database of WSUS don't work(unable to open managment console for WSUS). How do I check and reattach the old database? There where no errors when the new install was done. …

hi, My Problem is when am deleting a row from the SQL Server Database....I need to check two conditions. For eg: While deleting a row from the database,i need to check based upon the Name of the Employee and The Employee Number. Because there might be Employees with the same …

Anybody famliar with 04cg0ryk.dll. I get an error when I start my computer. The computer can get to it but[I] I found it in the regestry. So I ran Hijack which is for dll problems. This are my results. [/I] 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\svchost.exe C:\Program Files\Windows Defender\MsMpEng.exe …

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\svchost.exe C:\Program Files\Windows Defender\MsMpEng.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\brsvc01a.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\brss01a.exe C:\PROGRA~1\COMMON~1\AOL\ACS\acsd.exe C:\Program Files\Symantec\LiveUpdate\ALUSchedulerSvc.exe C:\WINDOWS\system32\Brmfrmps.exe C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Binn\sqlservr.exe C:\Program Files\Norton AntiVirus\SAVScan.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\wanmpsvc.exe C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Common Files\Symantec Shared\ccApp.exe C:\WINDOWS\system32\carpserv.exe C:\Program Files\Synaptics\SynTP\SynTPLpr.exe C:\Program Files\Synaptics\SynTP\SynTPEnh.exe C:\Program Files\ATI Technologies\ATI Control Panel\atiptaxx.exe …

i hv using vb.net create the form to insert the data to ms Sql server database... now i want to get data from database base on the ID key in by user.... [COLOR=#0000ff]Dim[/COLOR] sqlCommand [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlCommand("Select * form NewPatient Where PID = '"& txtPID.Text &"'", SqlConnection1) [COLOR=#0000ff]Dim[/COLOR] myReader [COLOR=#0000ff]As[/COLOR] …

im a trainee in asp i want to connect my asp withsql , can anyone help me.. or send coding or site adrresses mail me

Hi, The input parameter for the stored procedure is a collection. Without using loops how the iteration can be done. I think inspite of using loop i can get the records at one sort by using "IN". But in the where condition the left parameter is the number, how this …

[B]please help me how to check with database(SQL Server) whether the entered username and password is valid.i want the code for it.please be quick.[/B]

how do i set the permission for read and write into a database? i'm creating a program to view what is in the database(which is a different database application altogether) and reading from it using SQL. Error message shows "No read permission". i looked into the security settings of the …

Hi guys, I have this situation.. The Min funcition in SQL returns lowest value in query but I what to return is the 2nd lowest instead. Take this table for example col=Pay(3000,2300,1000,1900,1200) Min(pay)=$1000 but I want to return Min2ndlowest(pay)=1200 Is there a way to solve this problem. Thanks for help …

Hi, I am using MSSQL (Microsoft SQL)to liase with python via third party driver. Well here goes... I have created two instances of SQL registration in my Enterprise manager. It is under i)Console Root->Microsoft SQL Servers->SQL Server Group->(LOCAL)(Windows NT) and ii)Console Root->Microsoft SQL Servers->SQL Server Group-> INTEL\FR6EnterpriseDB (Windows NT) Btw …

First of all Hello to this forum. I have the follwoing problem. When I am runnig an UpdateCommand with codebehind : sqldatasource1.Update() I get the following error. (I want this command to CompareAllValues) [COLOR=#000000][B][I]You have specified that your update command compares all values on SqlDataSource 'SqlDataSource1', but the dictionary passed …

hi, how can i find out that what number of record(row) my cursor focused on in database? thanks label1.text= active row`s number ????? example : [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] baglanti [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]New[/COLOR][COLOR=#000000] SqlClient.SqlConnection()[/COLOR] [COLOR=#0000ff]Dim[/COLOR] command [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlClient.SqlCommand() [COLOR=#0000ff]Dim[/COLOR] kisiler [COLOR=#0000ff]As[/COLOR] SqlClient.SqlDataReader [COLOR=#0000ff] [/COLOR]baglanti.ConnectionString = [COLOR=#800000]"data source=instance2000;"[/COLOR] & [COLOR=#800000]"initial catalog=dbf;"[/COLOR] & [COLOR=#800000]"integrated security= …

Guys i need your help with this problem. I want to check if a record in my database is available or not? My database is stored in microsoft access file. ok. I used the data control that comes in the default tool box and i set up the databasename property …

I've been recently having troubles opening a few files. BearShare, Morpheus and Limewire to be exact. I regularly used Bearshare, then one day it kept closing on me. So I downloaded Limewire. Same deal. Now with Morpheus, same deal. Here's my Hijackthis log. Any and all help is appreciated. [QUOTE]Logfile …

Hello, I recently deleted some columns from a table with the statement DROP and I saw that database size doesn't change, it remains exactly the same(very big by the way). So I suposse DROP only take away the logical references but the COLUMN is still physically there. The question is: …

I am trying to migrate my MS Access database to MS SQL. My coding pattern is simple. Like this '--------------------- Data1.Database.Close Data1.DatabaseName = App.Path & "\Status.mdb" Data1.RecordSource = "Performance" Data1.Refresh C1 = "SlNo = 1" Data1.Recordset.FindFirst C1 If Data1.Recordset.NoMatch = False Then Data1.Recordset.Edit Data1.Recordset.Fields("Amount") = Format(mamt, "##,##0.00") Data1.Recordset.Fields("Upd") = Now …

I am going to write a log-in script to a MS SQL database where once the user is logged in, he or she will have certain capabilities given the roll assigned (student, admin, or volunteer), but not others. My question is how to make the login secure, to have timeouts, …

Dear all, I am getting this error and its not getting resolved at all: Syntax error (missing operator) in query expression 'OrderNo='. On line:RS.Open query, objConn This is my code where i am pulling records on the orderno and after i have pulled the records ,i am trying to insert …

i want to write an application in c# that check that either MSDE installs on current machine or not if not then install MSDE to current machine and copy SQL Server2000 database files(mdf and ldf) files to a specific location so that my another c# application use that database.could anybody …

Hi, Ny name is Ignacio Jorge and I'm migrating my databases from DB4 to SQL Express 2005. This experience is being great so far, but I have some doubts that I would like you to help me, people. Thanks in advance Love Nacho

Hi i having a few problems what i need to do is find duplicate rows in a mssql database i can do from one table but i need it to run across 2 tables this is the code i useing to do one table SELECT COUNT(*), sID1, sID2, sID3 FROM …

Hi can anyone help me on how to get the names of the tables from a DB - MSSQL 2k server? i need to list them or add them into a combobox, but i also need to select them by owner, or by type. user defned or system. thx in …

product transaction date -------------------------------------- 1 06/07/2006 2 06/05/2006 2 06/10/2006 3 06/09/2006 I have a table like above, now I want to retrieve the latest transaction date for each product, so the result should be: product transaction date -------------------------------------- 1 06/07/2006 2 06/10/2006 3 06/09/2006 I try to use statement: …

bottom here is my asp coding, for connecting to mssql2005 i know how to connect to mssql by vb using the com+. but i want to try using the database connection on asp page. [code] <%@ LANGUAGE="VBScript" %> <% Option Explicit Dim UID, SQLStmt, Connection, FirstName, LastName Dim RS, SSN, …

i have made a database application in c# which is using SQL Server 2000.Now i want to send my application setup to client.i want to make a setup that not only install my application but also MSDE to the client machine.can anybody tell me how will i make a setup.

Hi, I'm using a GridView Control in which I wish to show thumbnail versions of images saved as binary data on a SQL DB. I have a page that accepts an ID parameter to use in finding the image on the database. The page uses the [inlinecode]Response.BinaryWrite()[/inlinecode] method to display …

Can't change our home page and need help. HJT scan is below. please help! John Logfile of HijackThis v1.99.1 Scan saved at 2:48:32 AM, on 7/23/2006 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106) 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\spoolsv.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe …

Hi, I am in the need of tree control which i am going to use in aspx or asp page, that can loaded by SQL database at the first time. After that I need functionally of Expand All", "Collapse All", "Submit", "Clear", "Cancel". it would be great help for me …

I am attempting to apply an SSL certificate on a per client basis in SQL 2000 (Windows 2000). I have read a number of MS Knowledgebase articles on the subject, and followed their directions, none of which seem to be working. After installing the certificate, the directions say to export …

We are getting frequent error in display while processing through web, we are having higher end hardware , ML350G SERVER,with 4GM Ram, duel processer capable, 145x3 hard disk, We are having 30 GB Space in C: Drive and 240GB in D:Drive, we have sql database upto 17 GB, the process …

Hi all, Please help me in solving following query. Can we define in sql server the same parameter as input and output? How to do it? Thanks and regards, Swapnil.

I currently have a form that i have created using html, (can create in another language if makes it easier) however, i can't seem to find how to send the information from that form to my database. I have searched over the internet and asked some people that I know, …

Hi !!! I m Jai and pursuing engineering in IT. We have to do a mini project in DBMS. I have decided to do a project for mainting Insurance policies. Pls help me out for its case study. Also suggest me any other new topic if possible. Thank you.

Hello, I backup my databases like this: [I][B]dump database MYDATABASE to disk='c:\temp\MYDATABASE.bak' with init[/B][/I] [B][/B] This saves the structure and data to the bak-file. Now, for some DB's I want to save the structure only, can someone tell me how to do this? THX pakko

I have a GridView and a DetailsView on the same page which work together allowing you to Insert or Edit data records read by the GridView from the DetailsView. My ASP.NET book explains how to do this...assuming you aren't using any template rows. I happen to be using several template …

Hello, i'm currently working on an online game (browser based), and obviously, since all of the contents is meta-data, I have loads of DB-related work. Recently I came into a brick wall while trying to figure out how to make one of the more important features of my game to …

hello frinnds, i am new to this forum.........afte seeing this i feel it is gonna helpme..... right now my problem is-> i am usin msql, here i am using a table in a database..inside this table i have field called [B]ID, i[/B] want autoincrement feature for this field......... i don …

I own a small web site / hosting company and I had a hard drive failure and my back-ups didn't work perfectly. I have a complete back-up of my C drive from May 2006, but I can't figure out how to restore my MS SQL. Can anyone help? thanks, Marc

I'm not sure if this is a Server 2003 issue or an MSSQL issue, so pardon the cross-post. I have created a local user called "sql-daemon" to run MSSQL 2005. At the onset, everything works fine: I can reboot the server and all SQL processes start as expected. Then, one …

Hi, I'm creating a page that has an ASP button that should delete a row of data from an SQL database. I want a javascript confirm window to appear to make sure the user [I]really [/I]wants to delete the information. I can set the button's OnClientClick property to "javascript:confirm('Are you …

Hi, I have a GridView that displays data from a MS SQL database (duh!). I know the GridView allows you to have a command column with such functions as Edit, Update, Delete, etc., which I wish to use. The problem is that I only want these functions to be available …