Hi, i have several questions, because i'm quite new to SQL-Server and Access Projects. Till now i only worked with Access.MDB's i created a new access project and have my database on SQL-Server. I see all tables in my access-project and can work with them. Now i need data from 1 excel file ...more >>

I have 2 tables, with 2 columns each: Seq# and Client I need the syntax of a query to compare count(Client) by Seq#, between Table1 and Table2 Something like this (although this doesn't work) Select Table1.Seq from Table1 inner join Table2 on Table1.Seq# = Table2.Seq where count (table1.Client...more >>

Is it ok for me to add a column while the database is in use? My users received a message when I added the first column to an existing table. Is there a way to stop them from receiving messages if I add a column?...more >>

When I run Visual Basic Application With Back hand Is SQL SERVER DataBAse I Had Connect database with ODBC But its very Slow What can i do...more >>

I have around 5 items in my database. It takes me about 1- 2 minutes to show up all the result. How can I make my query result faster? I try to select everything on my product table....more >>

I'm having a major problem trying to figure out how to set up an online application for my visitors. I know that the security issue is something I have to look at with the server, but that's pretty much all I know. I need an online application for visitors to complete. It will consist of personal...more >>

I want to know the name of tables in which there are more than 200,000 records ? how can I Thanks Noor ...more >>

SQL .mdf file import. How can i import a .mdf file(291MB in size) into a txt file? a step by step guide - as i know nothign about SQL 2000 thanks / Regards, Jeff...more >>

I run the DBCC for a particular database in Query Analyzer, and it takes 3 minutes. I take the same SQL script and place it in a job to be scheduled in Enterprise Manager, and it takes 1 hour. Why? Please help....more >>

Hi all: Hope you can shed some light on this. we have a Vb6 app connecting to a slq server database using ado 2.6. when each client is started they initialize a connection object which is kept open for the life cycle of the client (i know this not recommended but it is an inherited problem)...more >>

Hello! I'm using ASPAccessEditor (http://aspaccesseditor.aspit.net) with an MS Access database... Is there a tool similar to this for MS SQL databases? Thanks in advance -- Mauricio Freitas MS MVP Mobile Devices Bluetooth Guides: http://www.geekzone.co.nz/content.asp?contentid=449 Per...more >>

Hello, We are a small/medium sized manufacturing facility that uses a home grown data collector on our shop floor to communicate with our SQL server that we do our logistics off of. Now I haven't been with the company all that long, I just maintain the current data collector now, and these ...more >>

Dear Guys How to Reduce the log file size in SQL2000. I have used DBCC Shrinkfile(db_log,filesize) but it doesn't work. The Log file size still the same And my HD Size will be full. Have any suggestion. thanks ...more >>

I am looking at attempting to create a deployable installation of the SQL client tools only. anyone know an easy way to do this?? Steve...more >>

Hello.. As I remember I ran across a set statement that could control the dataformat on the server For instance print cast(getdate as varchar) it returns current date and time in am/pm format, but in Denmark we're not using this format, we're using 24hour format. Obviously I could use CONVERT, b...more >>

How can I set the password on my database backup file.. I don't wanna use zip options... Any idea about encryption? Thanks NOOR ...more >>

Hi all, I'm using Enterprise Manager to connect to several remote SQL Server Databases (in different locations). It works fine for all servers except the one that shows "No items" when I click on "databases". After "refresh" it successfully receives list of databases but after a few hours... ...more >>

Hi everyone, I'm using Access adp and I would like to know how to format the date anyway I like. The problem is this: My SQL server is configured to use the mm/dd/yyyy format, the network server also uses this format. The problem is that some workstations are configured to use the dd/m...more >>

Dear Sir, I had install application on client computer which is made in vb6.0 and sqlserver 2000 & Crystal 8.5. While I am trying to access the data for employee table it takes very long time to display the data in combo box. The client computer is far away from the server. I.e. it is c...more >>

Hello All I am experiencing unusual behaviour with a number of desktops (3 of 20) running the BDE and the SQL connectivity option from the sql cd. For reasons unknown the BDE suddenly stops connecting to the database and cant be fixed without a reimage. Appears to be a key or dll that is causing ...more >>

I have Win9x clients. For them to be able to write to a SQL database (2000), I think I would need to install MDAC. However, many of these clients are connected with an extremely slow WAN connection (56K) which makes MDAC install via login script difficult or impossible. I don't need the co...more >>

When we do Insert or Update How SQL optimizer when optimizer lock the table and when optimizer lock the row? I know we can force these using Hints. TIA ...more >>

Hi, i have problem. When I restart DNS server I also have to restart my application becouse it can't fint MS SQL server. I connect to MS SQL via TCP/IP with IP number. What is wrong? Is it clients bug? Regards, clint ...more >>

Is there someway to prevent SQL2000 users seeing other databases in the list, when they connect using enterprising manager. The login-security prevents them from modifying other db & tables, but is there some way list only the database the user has access too. Somewhat like this utility at http:...more >>

Hi All, I am selecting a table and getting some data from it. Then by using Cursor i try to Insert it into a new table(The new table = is already created). But it says Error while Insert The Code is written below. ////////// 1st Approach//////////////// DECLARE cursor1 CURSOR=20 For Se...more >>

in the queries IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'OldDatabase) DROP DATABASE [OldDatabase] exec sp_dboption N'DatabaseName', N'single', N'false' What is the N for? Thanks, Brad. ...more >>

SQL Server 2000 I have one temp table which has Start_date and this temp table has around 5000 rows. I am joining this temp table with view in following query Select l.* from table_1 l ,#Temp Table t where t.employee_number = isNull(employee_number1,employee_number2) and l.end_...more >>

Hi all, I need to give remote access to a SQL Server 2000 (MSDE) dabatase, meaning that a developer must be able to upload/dowload via FTP the mdf and ldf files. This isn't a production database, so there is no active connection to it except for the said developer. The system doesn't eve...more >>

id name 1 Noor 1 Ali 2 Hamsan 2 Guy I want the data like this. 1 Noor Ali 2 Hamsan Guy Can any body tell me thanks NOOR ...more >>

We upgraded some of our SQL Server 7 machines to 2000. Some users still have SQL 7 client (Enterprise Manager, etc.) on their machine. Should this cause a problem when viewing a SQL 2000 Server through a 7.0 client? Or is it better to upgrade the client to 2000 and then have to view t...more >>

Je travail sur une base SQL dont je ne suis qu'utilisateur. Le problème est que l'ensemble des dates ont été transformées en valeur représentant des secondes par rapport à une date d'origine qui est le 01/01/1970 00:00:00. Je ne parvient pas avec SQL à trouver comment faire se calcul !? si ...more >>

I would like to know how to go about doing this. I have a table ClientInfo in SQL 2k. I want the customer service dept to be able to add new clients and search for ones to edit. I want other groups to be able to only view client info read-only. 1. I assume creating a webpage is probab...more >>

Client: WinXP arabic Server: win2k server and SQL Server 2000 when i enter the data in the client it is showing perfect in arabic, once if i stored in the database server and retrieve again, it is showing garbage character. How to store the data in arabic on the sql server. ...more >>

Hi, We have a number of developers who write applications that connect to our SQL Server databases. They wanted to install the SQL Sever client tools (Enterprise Manager, SQL Analyzer, etc...). Does anyone know if I need to purchase separate licenses to install these tools on multiple workst...more >>

How can I make the following query as a correlated sub query. select PA_VPatientID, -- From Patient table PA_FirstName, -- From Patient table PA_LastName, -- From Patient table PP_IsActive -- From Patient Personnel table from Patient inner join PatientPersonnel on PA_VPatientID = PP...more >>

Can you tell me which one is optimized ? 1) SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) 2) SELECT distinct au_lname, au_fname FROM authors inner join titleauthor on titleauthor.au_ID = author...more >>

I've been converting a large Access 97 app to use SQL 2000 for the BE. I have solved pretty much all of the performance scenarios except this one: updating a server table and joining it to a local table, e.g.: UPDATE server_table INNER JOIN local_table ON server_table.field1 = local_table.fiel...more >>

I am trying to install SQL-DMO using the instruction to register the SQL-DMO components on a client computer. I am using the SQL-DMO components to find all the SQL servers on the network. This list is used by the user in making their connection. When I execute the REGSVR32 SQLDMO.DLL command the f...more >>

I have a database running on MSDE it was working fine. Recently when I try to select from the database I am getting the following error after a few records have been returned. All of the tables are giving this problem. Not sure what to do [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionChec...more >>

Hello, I am new to SQL server but not to databases. I am looking for a step by step tutorial on how to install and setup SQL server. Any ideas please? Cheers ...more >>

I get the following message when I try to register a SQL Server in EM. Warning - The client and server codepages do not match. Some ANSI character mappings may not be possible. This is not an issue that is going affect my work, but just want to know how to fix it. Using rebuildm I changed the C...more >>

can i use this method -- inserting a new row into table!...more >>

in work , I usually use full backup . i think file backup will be more useful ,but the information of it is rare if anyone use it before ....more >>

Dear Professional I want to export the stored procedures, functions and tables into textfiles.sql Like if there are 100 tables then it will create 100 sql files and if there are 200 stored procedures then it will create 200 sql files, how can I do this task. Thanks NOOR ...more >>

How can we share any folder from MS DOS command, can any body tell me regarding this Thanks NOOR ...more >>

This is the first time I will be using SQL server although I have good experience in FoxPro and ACCESS database, I have limited knowledge of SQL server. We have installed SQL server 2000 on WIN2K. Our IT people has installed Enterprise Manager on my win2000 workstation. How do I find I am in a...more >>

Hi, I have a stored procedure : CREATE PROCEDURE sp_MySelect @ID int, @city varchar(6), @ccountry varchar(6) AS SELECT * FROM MyTable WHERE (ID = @ID or (@ID is null)) AND (City = @city or (@city is null)) ...more >>

I have a client that is migrating to SQL Server as the D/B for their POS software. The software uses a Pool Manager to exchange data with the D/B. The pool maintains 3 active connections to the D/B per module instance. The POS clients connect to the Pool Manager. Considering that their are only ...more >>

Hi, I have a stored procedure and one of the parameters is of format smalldatetime. What is the format of the parameter when I call the SP ? CREATE PROCEDURE sp_My_Insert @org int, @aDate smalldatetime, AS INSERT INTO MyTable(Org, ADate) VALUES (@org, @aDate) GO How do I call this S...more >>

Hi All, I have the following table structure=20 CREATE TABLE [test]=20 ([dd] [datetime] NULL) I have a stored procedure to insert values to the above table. The SP is = invoked from a .NET application written in C#.=20 I have to store date time in UTC format.I am able to convert local da...more >>