2,935 Topics
 | |
| | Since there is an OLE DB for Directory Services, can you do more than view AD objects? ADSI is an OLE DB provider and it can, so can you manipulate AD using SQL queries once you establish a linked server?  |
| | TITLE: Connect to Database Engine ------------------------------ Cannot connect to CHESF-HIMRIO\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. …  |
| | Hey, I am creating a recruitment database and will be using a managed hosted service. I have read MSSQL is more expensive, but does this matter if I am paying someone else for hosting? The site is going to be in .NET, and I initially was planning to use MySQL, …  |
| | I am programming in vb, I always get stuck on my sql select statement(I seem to have problems with my syntax,It takes me hours to get my syntax right) Can anyone suggest a good tutorial for sql with many examples and exact syntax |
 | I am creating a db that needs a very high security level. I have multiple users on the server, but I need to restrict the access to my db to only one of them. I tried setting the "Single User" option for my db, but then none of the users … |
| | Hello, I am trying to write a single query to run a report. I have it working for a single farm, but I need it to work for a list of farms. I am having trouble linking the farm number for the inner query to the farm number for the … |
| | Hi guys! I am developing a web based database for a company for my year work placement for university. As I'm still a student I am still learning so I am not 100% on what i am doing. I was wondering if someone could provide me with some help?...please! :) … |
| | I want to insert 2 table at the same time . There are relationship between them .My tables are: Topic : topicId, topicDate,topicInformation Reply: replyId,topicId, replyInformation |
| | Hi, I need to make a copy of a ms sql 2000 database and send it to another person. They are asking me to send the database schema. I would like help on this since is something I never done before. Thanks Javier |
| | I am installing SharpForge on my computer. I am getting error when i went through the intallation wizard. Error exception details System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the … |
| | Noob question - I have MSSQL 7 running on my machine, although I'm not sure how it got there. I have one DB program using it along with the UPS Worldship program. The latest version of Worldship (9)will not install unless it sees SQL 2000 or better. My DB people … |
| | Has anyone attempted virtualizing Microsoft SQL Server 2000/2005 using VMWare or MS Virtual Server? I've heard from others in the field that they wouldn't virtualize a database server relating to high availablity restrictions. We know for sure that we will virtualize our web servers, mail, and possibly domain controllers. Just … |
| | I am using rowcnt column in sysindexes to report some database statistics. I used the "max" to get a valid row count (as I found multiple records for many tables) for each table, and added status<>0 in the conditions to get valid results. All went OK except for some rare … |
| | I have a VB program that needs to count number of events between two datetime values. Something like this: SELECT COUNT(*) FROM Report WHERE WeigthTime BETWEEN "Time1" AND "Time2" Time1 is now. I get it with "SELECT GETDATE()" I need to calculate Time2 by decrementing it for X hours. X … |
| | It's me again...the newbie. I have a web application that I am developing for a school project. Quick overview; the user submits one of multiple different types of "requests" and then a technican begins work on the project. Anyway; with the help of others I have gotten the EXTREMELY long … |
| | [COLOR=midnightblue] HI all, I am very new to SQL server and have been working my way through a book to learn ASP.Net v2 and SQL by building a e-commerce site. There are 3 stored procedures which are used to implement paging from retrieving products from the catalog, which are either … |
| | Hi Guys, I've created a recordset which is saved in a txt file using following code [code] Private Sub Command0_Click() Dim Conn As ADODB.Connection Dim Rs As ADODB.Recordset Set Conn = New ADODB.Connection Conn.Open "DSN=movex" Set Rs = New ADODB.Recordset Rs.CursorLocation = adUseClient Rs.Open "Select * from PESALES", _ Conn, … |
| | This is code for retrieve data from table Results. The output must display to user via SMS. Now the problem is I cannot call all the data from table RESULTS. Dim da As New SqlDataAdapter("Select * From Results Where Metric_Number='" & content1 & "'", conn) Dim dst As New DataTable … |
| | Please Help me how to use FOR_XML_NULL_TREATMENT Can u please provide a sample code. |
| | Hi, I've installed Reporting services developer. When I browse Reports folder in IIS, I get: The request failed with HTTP status 400: Bad Request. error. What's the reason? Can anyone help me out? Regards, Shrinivas |
| | hye...im having difficulities to retrieve data from one table. i need to retrieve data from few columns and multiple rows in one table and display it the data. is there any way of doin it? urgent help need!! |
| | I can't find any DTS tool on MSSQL 2005 Express Edition Is there any tool that execute DTS tasks? I need to perform 2 tasks: - import a large Access file into MSSQL - deploy database to production environment Any help is welcome. []s  |
| | Customer: customerId, customerName Order: orderId,customerId,product, date, productDefinetion I want to display the order which is the latest order from the customer and I want to display all customer Name Example: customerName product productDefinetion John Video bla bla bla Maria ------ ----------- |
| | hye there...anyone can help me out here...im having problem in running sql command its shows error : "sqlConnection does not support parrallel transactions" trans = conn.BeginTransaction() Dim strs As New SqlCommand strs.Transaction = trans strs.Connection = conn strs.CommandText = "Insert into StudentSMS (RecipientCode,RecipientNumber) values ('" & RecipientCode & "' , … |
| | |
| | hi all, Very new this forum. i am using MSSQL 2005 and i want to create a backup script for a table [create and insert statements] without using mssql datapublishing wizard 2005. is it possible?? how can i do it Best Regard |
| | Hello All, I am deleting a database but I am not seeing any entry in server logs or in event viewer. and same thing is happens when I am deatching a database. Can any body tell me the way through which I can know when a particualr database was deleted … |
| | First, I consider myself a novice in Mssql. I've recently began the revision of a website that uses MS Sql Server 2000. In a effort to set up a working environment on my pc, I asked to get a copy of the sql server database. The response was something like …  |
| | Hi. Can anyone help me with this? If I have, for example, a MSSQL database named 'COUNTRIES' and an existing table in the database named 'COMPANIES', can anyone let me know how I can add an additional field name 'PEOPLE' with a string datatype (for example) to this existing table … |
| | select convert(decimal(5,2),(7058/7482)*100 ,0) is showing .00 value in sql server 2000. Why ? How to retrive value with decimal part, plz. guide me. Thanks & Regards Girish |
The End.