[microsoft:sql-server] Forum Topics

Our server has several roles at the moment. 1. Web server so offsite employees can use a Flash application. 2. A few folks remote in using RDP (admin mode, so it's not a TS server). 3. SQL server. Some offsite employees use a Windows client to connect to the database. …

Hello, I hope my question falls in the right forum. I have a content web 2.0 website with ms sql database. As most content websites, every file has Title, description and tags added by uploaders. I would like to know if there is any standard algorithm for SQL search based …

Hi..by the way i'm mark...a newbie in visual basic and my question is this... How or what is the codes used to connect from visual basic to "SQLyog"...just like visual basic to ms access?...

Hi, I don't know why the server I recently get to manage, has the SQL Server 2005 installed but with the Management Studio Express!... I need to upgrade it with the Dev version, but when I put the DVD of the SQL Server installer, It won't show my actual installation …

Hi, I have 2 instances of SQL Server running on one machine (One 2K -default- and one 2K5), I have no problem connecting from a PC on LAN to the 2K5 instance, but when I try to connect to the 2K instance, it fails (it gives me an error: "Named …

I have a SP (sp_test_procedure) created from a SQL Server Project in my SQL Server 2005 database, inside this SP I have a call to another SP which inside calls to a SP in another Database Server (SQL 2000) through a cross-linked connection. When I execute it from the Management …

Hi all, I have a Stored Procedure without an output parameter but it returns one row always, this SP is called by another SP, so I need to store some of those columns in a variables of the first SP. How can I do that? Please help. P.D.: I have …

I have two "entity" tables: Company and Agency. Both Company and Agency can have multiple addresses (shipping, billing, etc.) and multiple contacts with titles (president, sales rep, etc.). Rather then put address and contact information in each entity table, I want to create a table that is common to both …

Hi everybody, I've got a big pb, and I need help..... I have to use MS SQL Server 2005 SP2 Enterprise Edition instead of MSSQL Server 2000 Enterprise Edution and I don't know how to use the old SQL 2000 db. Any sugestions? Thanks for your time. Eddysonys

Hello everyone, I am querying an MS Access database to find duplicate records and list the results in descending order. I am using a 'while' loop to read through the records but I'm finding it difficult to store the results in separate variables, i.e. the query finds three results where …

Hello! I'd like to ask for some help. I'm using Visual Web Developer to create a web site, in which members can log in. It has the default aspnetdb.mdf database, in the app_data folder to store the member's data. This works quite good offline. My only problem is that I'd …

I have to implement session management in an asp.net application and with mode as sql server. Any inputs on how to implement and test this? I was trying for instructions on the following web site, but i am lost [url]http://idunno.org/articles/277.aspx[/url]

How to add any user to System Admin role Programmatically in ASP.net 2.0 using SQL Server 2000 ?

Hi everyone, my name is toritereju Ejegi, you can call me toju. I presently work as an IT manager at my company being in charge of IT procument, content management of for the company,s website, LAN administration and application software administration. i have done a little programming with java , …

I m using asp.net 3.5(visual studio 2008) and sql server 2005/2000. I want code for validation of Account number and password. i.e. when user enter the Accountno and password and click submit button it should check the data with that enter in database. If it is correct it should go …

hello. my question is , when we store an image or a picture in sql server in which format it is stored and why it is stored in that format.???

Can any one tell me how should i generate report on the basis of groupwise since right know i placed department,job centre,cost centre ,requested by, delivery point, delivery date req, suggested vendor on the detail section1. but it is comming two times kindly see the attachment if not understand. here …

--query of a very large table SELECT abc AS 'productname', xyz AS 'quantity' INTO #tmptable FROM dfg WHERE blah -- --content of #tmptable: --productname quantity --product1 5 --product2 3 --product1 2 --product2 8 --product1 5 -- how does a query on #tmptable look like, if I want to receive the …

I'm using SQL Server 2008, the SQL Server Management Studio. I'm trying to import from a flat text file into my mssql database, but it inevitably fails, resulting in the error: The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for …

I’m using Visual Studio 2005, ASP.Net 2.0 and SQLServer 2005. I can save .doc files into a binary column in the database. I can open .doc files from the database and view/edit them in Word. I want my customers to have free access to their Word documents. If they want …

I am attempting to use a sql query to update a record using the following: cmd.CommandText = "UPDATE ScannerData Set DateReceived = " & Date.Now & " WHERE ScanNumber = " + TheReaderData.Text + "" I receive a parse error at the Date.Now portion of the statement. Is there a …

Hi Friends, I'm a web developer bit a new to asp.net. I want to access my remote Ms Sql database through [B]Visual Web Developer[/B] or [B]Sql management studio[/B] but despite of spending so much time and googling I'm not able to do that. My [B]database( [url]www.peclive.com)[/url][/B] is on a server …

Hello, What is the purpose of putting an MDF file in the "app_data" folder? is it a way to avoid using microsoft sql server? currently i'm paying a lot of extra money (more than hosting fees) to my hosting company for mssq database. can i use an mdf file like …

Dear all, I have created an SQL Server 2005 Express database using the database explorer of VB.Net 2005, and selected to copy the database to the application folder. I can successfully connect and update the tables using Visual Basic ready tools (such as datagrid). But when I try to connect …

Hi all, I am just trying to get the information i collect from the pc's hostname and pass it into a db. All the db passwords, location etc are correct but i am getting nothing. [CODE]Imports System Imports Microsoft.Win32 Imports System.Data Imports System.Data.SqlClient Public Class Form1 Private Sub DB() 'Your …

Hi Friends, I am trying to Call a exe or DLL from sql server trigger using xp_cmdshell. Trigger is for an external application and for inserting a record. exe is executed successfully but trigger is not completed succefully and my external application is also not complted and it sows some …

Hi, I am trying to do a search function on my GridView. However when I tried using ( LIKE '%' + @ea_name2 + '%' ), it would only return me values if "ea_name2" is not null. I would like that SQL statement to execute even when "ea_name2" is null. Any …

Hello I try pass data from a table in Firebird to SQL server Mobile. I'm using c# in vs2005, and I have problems with transactions. At the end, if I want to rollback transaction, I would like to undo changes, but in the code I show you, Changes allways saves …

hi to every one, i have made two data base projects in vb.net using sql server2000 the first project is of student information and the other one is a bank project. now i want to colabrate these two projects when i enter the account number of student in student information …

Hi I am trying to insert data into 1 of my table and I get this error: Microsoft Access can't append all the records in the append query. Microsoft Access set 0 fields to Null due to type conversion failure, and it didn't add 1 records to the table due …

Hi all, I am new to sql programming, How can we copy a database from a local system to server? Thanks in advance, karthik.

Hello, I'm making a phone book application (ASP.NET, C#). I store general information of people such as name etc on one table called "people", and I've another table called "relatedInformation" which has 5 columns (ID, Name, Info, PersonID, Type). In this table I store all other information regarding people, because …

Hi Friends I am using asp.net & sqlserver,I have an gridview,in which i am using inbuild insert,update,delete code,but when i click on edit button so textboxes shows there, But i want dropdowns there & when I click on update button so the selected value must be save on database ,but …

Hi, I would like to know if it's possible to create a procedure, where we pass 2 arguments (the databases where the search must be done) and how to use those parameters in select clause What I would like to know is if it's possible something like: [CODE]create proc dbo.uspMySearch …

[code]SELECT * INTO [supplierexp] FROM [supplier] IN '' [ODBC;Driver={SQLServer};Server=(local);Database=sh op;user name='shop';password='abc123';Trusted_ Connection=yes];"[/code] For above code im getting error like ODBC--connection to '{SQLServer}(local)' failed.Im using the valid username and password only

Hi all, I have a bit of an issue with an application that i am currently developing. The application logs passed and failure information for a production line. Each production lineis broken down into operations, each operation has a task group and then each task group has a bunch of …

:-/ hey friends i need a help urgently.... i'm doing a project where i use listbox...i'm facing problem with this firstly i'm populating a listbox with particular field...then on clicking particular item in listbox the corresponding records from database should get displayed in all the textboxes of the form...here's a …

Hi all, I have a query which is driving me nuts. I am using asp.net 2005 and sql server 2005. I created a report using the reporting services. This report has two parameters year and month. My query is after selecting the parameters I have to click the View Report …

I'm working with SQL 7 on a Windows Server 2003 R2 Ent. Things will be working just fine and then we will for some unknowen reason start getting this error message and then we have to restore the DB to resolve it? This has now happened twice within the last …

I'm new to datasets, and trying to update a SQL Server database with one. I'm having trouble understanding how to correctly write the dataset info to the server db and preserve the relationship keys. When I write to the main table in the server database, it will assign the new …

hi every body, plz someone explain in detail "Sql Command Builder" in Vb.net. Also i need a Code to develop "SMTP server" i mean that i want to send an email from my own project , how can i do that, plz explain.

I have two fields in a table(dept_code and DEPT_name) in SQL.In my form iam having two comboboxs. one for dept_name and the other for Dept_code.What i want is that when i select a particular dept_name from the combobox its associated dept_code should come in the other combobox????

I'm trying to write application run as service in vb6. I have two barcode printers (ZEBRA) with print servers connected to centronics port (D-LINK DP-301P+). In my service i connect to SQL server and get information about destination printer and source code (ZPL) to print. Now i must send my …

I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure …

Hi, I am currently trying to develop my system that would send an email reminder to a user when the deadline for a particular matter is approaching. I did a bit of a research online and I realised that I will need to do some sort of a cron job. …

Hi, we are shifting our data-setup from SQL Server 2000 to SQL Server 2005. With regard to this, I am facing an issue with replication of the databases. We have a database with over 600 articles that are published. The procedure that we followed with SQL Server 2000 in order …

How would I select everything from last month in a sql statment my cell has a time stamp in it [CODE]SELECT DateTimeStamp from Get_estimates[/CODE] Ouput [DateTimeStamp] 2008-02-28 11:39:35.247 2008-03-09 13:15:12.513 2008-03-09 13:16:53.700 2008-03-26 13:30:20.077 2008-03-26 13:30:51.810

Hi there, I'm completely lost. I have 3 tables: - work (workID, description) - machine (machineID, name) - work_machine (machineID, workID, hours) What I want is to obtain a result similar to: work, machine1, machine2 A , 1 , B , 3 , 5 The problem is that the number …

here the code i've try....but still not working....please help me.. <page_load> id = 6 dbconn = [COLOR=#0000ff]New[/COLOR] SqlClient.SqlConnection("workstation id=HOME-5F227C8500;packet size=4096;user id=sa;initial catalog=pubs;persist security info=False") dbconn.Open() sql = "select * from NEWS Where NewsID='" & id & "'" dbcomm = [COLOR=#0000ff]New[/COLOR] SqlClient.SqlCommand(sql, dbconn) [COLOR=#0000ff]Try [/COLOR]dbread = dbcomm.ExecuteReader(CommandBehavior.CloseConnection) [COLOR=#0000ff]While[/COLOR] dbread.Read() lbl1.Text = …

Hi all, I have managed to get my average using cross tabs but only if I have grouped it by their categories. If I remove the GROUP BY clause, the cross tabbing doesn't seem to work. Can anyone help me? I would need to get something like:- [CODE]Year | Month …