Hello Forum readers, Any advise on the following, will be much appreciated : I have a customer who tries to extract some columns (fields) from an existing SQL table or add more columns (fields) in order to define a different layout (from the current one) and create a new ascii file. I have t...more >>

When I am trying to delete the record from flat table it gave me following error and that record doesn't have a constraints / triggers so why it's giving me this error. --------------------------- SQL Server Enterprise Manager --------------------------- Key column information is insuffici...more >>

I write you because I have a big problem with request access : when I use a sql server wiev in access (attached view) and i join it with a local access table, the sql server trace say sql server send all the data of the view to a access . This view have 15 000 000 ...more >>

Does anyone know how to turn OFF Double Quoted Identifier Delimitation on SQL 2000 Developers Edition SP4 running on Windows XP SP2? All my packages in DTS seem to show Double-Quoted identifiers. ...more >>

I don’t know to write SQL command filter. m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = ’abc’ AND Col2 = ’abc’ AND ?????)" example: ODBC found 100 records. I need to delete first 90 records and to leave last 10 records. Thank you Joseph -- Posted using the http://www.dbf...more >>

Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0 Through OBDC (System DSN) I created a connection to the SQL db. Then on my laptop I opened up frontpage to create a page to view the db results. ...more >>

Hello All, I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication. I am using ASP.Net 2.0 (VS.Net 2005). Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Dir...more >>

is there any solution to use null values to the parameter my sql commandtext= "select * from info where name=@name and surname=@surname" in visual basic .net info table data= name surname _______ _______________ 1 null 2 null ...more >>

Please tell me what is the purpose of these DBCC Commands? DBCC memospy DBCC memobjlist DBCC memorymap DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE Can these commands be used to free the RAM which is occupied by SQL Server -- Regards Farhan Iqbal ...more >>

I have Enterprise Edition of SQL Server 2000 with 2 GB of physical RAM, this is in my observation that every day this server uses entire physical RAM and not releasing it, at last I have to restart the services of my server. Can any buddy help me in this regards how can I release the memory...more >>

I am setting up a development box which will mirror production. Both boxes need to have the SQL client tools installed. I know that production has SP3a installed, but I do not know if it has the post SP3a patch (SQL2000-KB815495-8.00.0818-ENU.exe) installed as well. How/where can I find out ...more >>

Hi, one of our .Net 1.1 (VB) applications uses SQLDMO.DLL methods to get a list of available SQL Servers and display this list to the user. I created a .Net installer project including the application (including also interop.SQLDMO.dll). The installer copies the SQLDMO.dll to the program ...more >>

i have a table name:NAMES Name Surname City Country ------------ ---------------- -------------- ------------------- 1 null null ...more >>

Hi, We are using SQL server at Factory and HeadOffice and both are not linked, We want to send some data from HO to Factory's Sql server and vice versa through CD/Floppy. How to do this ?. (Export/Import) . Can be do this using programming? Please reply back Please also let me know good ...more >>

I have my application installed on one server and SQL server installed another system, which my application uses to log the data and rerieve the data. I want to check for the physical mdf and ldf files, if they are present, i need to make sure that link is proper. I am using "dbcc checkdb" ...more >>

In this post I am going to try to simply a question that I posted earlier. Can I use VFP to access a SQL Database? If so what is the command? What is the best software for creating applications to work with SQL? I am just getting my feet wet with SQL so please take it easy on a rookie. ...more >>

I have Nvarchar column in which i am storing Series no and i increment it as max(DocNO)+1 to get next number in series but it has problem after 9 for 10 it also giving max as 9 what is the problem and solution. Do i need to use cast()? ...more >>

If I'm running a Legato Co-Standby or CA Brightstor failover setup, where only one server is accepting connections at a time. Do I need to purchase a full count of SQL and Server client licenses for both servers. I've heard that I can have for example; a fifty client and a zero client box but s...more >>

Is there any way to find out the stored procedure output paramters like I can findout the input params through following query but I want to findout the output params list.... SELECT Specific_Name, Parameter_Name FROM INFORMATION_SCHEMA.PARAMETERS thanks in advance. ...more >>

My database is in suspect mode and I want to recover it... what should I do? Thanks Noor ...more >>

When I open up SQL Enterprise Manager (SQL 7) I get the following error message ''Microsoft SQL-DMO error 340:General error'', i can press OK. Enterprise is launched but there are no Registered servers. when I go and try and register a new one this message appears ''Server registration inf...more >>

I develop computer-based training for intranet delivery. Along with the training files, I have always used Microsoft Access to store user data. The training files transmit user data to the database via ASP pages. Now, because of a very large client with 10,000 or more users, I would like ...more >>

Hello, I am new to SQL Server 2000, and trying to learn it. I have a small practice table with 5 records. One field is called "fldcustomerID" in which the customer records are numbered 1,2,3,4,5. OPEN TABLE Using Enterprise Manager when I right click the TABLE to open the table as a q...more >>

Hi I am in some confusion with regardes to licencing for our sql server and client software. I have Sql server 7 database installed on our server. Recently we purchased a couple label printers for our warehouse which came with software that can access a Sql database. This software can on...more >>

Is it possible to have SQL server notify an application upon a change in a table? I want to create an application that dispatches commands to subscribing applications. The heart of the entire system is the database. When the database changes, new commands will be generated and dispatched to...more >>

Is there any way I can use the following command like that ? BULK INSERT Northwind.dbo.[Order Details] FROM (select CSVTextFile from tblCSV) WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) Thanks in advance ...more >>

Can any one help me regarding the postal code. As we have seen in the website we put postal code and it will display the nearest distance.... can any one help me out regarding this .... like what would be the formula to calculate the distance.... I would highly appreciate. Thanks ...more >>

Can I save the CSV file into one column through any query? Thanks ...more >>

I do have a csv file and I want to save the file into log table but I wondernig that datatype would be text or image ? and after that I want to fetch the data from that file and save it into different table.. can any let me know what would be the best way to do this ? Thanks in advance ...more >>

TextCopy - Handling text and image data TextCopy is a Microsoft Foundation Class (MFC) C++ example that illustrates handling Microsoft® SQL ServerT text and image data types. The example moves data either to or from a single server column and row, and a user-specified operating system file. ...more >>

Production File Sizes: MDB File Size is :- 50944 KB Log File Size is :- 34443648 KB Recovery Model: Full I want to shrink the Log file .... can you tell me how can I do this ? should I put the simple recovery model so it will shrink automatically.... or give me some good advise as thi...more >>

Hi I want know if is possible installing SQl 6.5 on windwos 2003 server standard edition. Can tell me link or material about this possibility? Tia Pupo ...more >>

Is there any way to save the image data into one file..... basically I have one record in a table and I want to save that image data into one separate file... is that possible ? ...more >>

We're using MS-SQL Sever for a documentation database. One of the tables stores all the DOC, XLS and PPT documents fed by our users. We need to export all the files to certain directory and the rest of the table contents to a spreadsheet. We want to distribute the documents in a promotional...more >>

Hello, I just converted a website database from MS Access to SQL 2000, and many of the pages are not working because SQL now wants fields to be ref'd as "dbo.<<fieldname>>"... I've fixed this before, but cannot remember how... If I cannot fix it through the database / connection, I'll have...more >>