Hi everybody, my question is: is it possible hide a column in my sql table?? i don't want show this column for anybody with access to my server because contains critical information Please help me -- Juan Carlos Linares Webmaster Comya Global - Public Relations Network Communicat...more >>

Hi... I need as soon as posible to find a dba checklist for MSQL Server 2000 Administration Thanks in advance for your great help.... Regards Patrick...more >>

Hi, I had installed SQL server with instance name. Now I want to rename the instance name. For example the sql server name is server\inst1. I want to rename it as server. I am using windows 2k server and sql2k. Window server name is 'server'...more >>

Hello Gentlemen when I try to creat a new SQL sever it says Sever does not exist or acces denied please help me...more >>

I have a query in Access that calls a VBA function that in turn can call up to 7 other functions depending on the arguments fed into it. I would like to convert the query into SQL Server. Naturally, the query would become a view but I cannot figure out how I am going to mimic the VBA functio...more >>

When running the setup for this the installer stops and says to refer to the setup log. The log reads as follows 2005-01-27 07:06:36.26 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windo...more >>

In access you are able to have a field type hyperlink so that you can connect to somting. I have created a sql database that contain pictures I store them outside of SQL when I run the ASP page The Data comes in Picture Name and then next to it the correct picture ...more >>

I'm fairly new to running SQL Server 2000 in a business environment. We currently have multiple application servers that each have their own SQL 2000 installation and databases stored locally. More application servers on the way, more installs of SQL server on each server. I always thought ...more >>

I have 3 related tables, one "parent", a child table and a "grandchild" table. I want to return a list of child records and also a count of the number of records in the grandchild table. I have a query that does this BUT it will not return a record if there are no records in the grandchild ...more >>

Is it possible to run a query or report from the SQL Sever scheduler? If not, thanks..........If so, can you give me an example. Thanks, Chris ...more >>

I need to search on and replace paragraph characters within a query. Does anyone know how to do this? I've tried Replace(expression, chr(13), '') but sql doesn't recognize the char(13). I've also tried it with vbCrLf and chr(10). Am I missing something? Thanks. ...more >>

Hi all, I'm a new user to SQL Server, hence the post here. I am trying to migrate a database from Sybase Adaptive Server Anywhere version 8.0.2 to SQL Server 2000 SP3. So far I have: Created a new database in SQL Server Created a new linked server, using ODBC, to the Sybase DB Copied ...more >>

BlankA SQL Server book suggested that I should think of a trigger as being like an Access "before update" event process. I need a triggered procedure to run "after" an add, delete or update. Can such a thing be done? Thanks Jim ...more >>

I've recently added a second computer to my Windows XP Pro (S pack 2) work group. On my main computer is SQL Server 2000 Developer Edition. On the second computer, I am trying to log on with Query Analyzer (and also create an ODBC connection). Whenever I open Query Analyzer and try to con...more >>

After running: SELECT [total size KB], B.rows, O.name FROM (select sum(convert(decimal(10,0),dpages)*8129/1024) [total size KB], id FROM sysindexes group by id) A INNER JOIN sysindexes B ON A.id = B.id and B.indid in (0,1) INNER JOIN sysobjects O ON B.id = O.id WHERE B.rows <> 0 ...more >>

BlankApparently there is no Boolean or similar logical data type in SQL Server 2000. Amazing! What do I use in its place? I guess choices might be 'bit', "byte' and/or 'tinyint'? I plan to interact with the database with three types of front-end apps: Access/2002, C#, and Sun Java and I wi...more >>

I have SQL Server 2000 and Visual Basic. Net. Can I use reporting services with this set-up or do I need the entire Visual Studio Package?...more >>

Hi there, I have a database design problem and I don't know how to go about this. Any help would be greatly welcome! I've simplified my tables for the sake of understanding. I've created a fictional scenario that is exactly the same as my more complex one. My example involves the sell...more >>

This is for the Northwind database: select count(customerId), country from customers group by country order by 1+3 How come this works? What does it mean to include an arithmetic operation in the Order By clause? Thanks Amit ...more >>

How would I lock a record or a set of records for an UPDATE query set FIELD1 to "UNAVAILABLE". I want to insure users cannot modify or read the record while I am updating the record. Once I UPDATE the record, it should not show up in clients SELECT * WHERE FIELD1="AVAILABLE" query and I am wo...more >>

Hi, I am trying to restore a SQL Server 2000 database that is backeup up on a different machine. I am getting the following error while restoring: ODBC SQLState: 42000 The media set for database 'xxxxxx' has 2 family members but only 1 are provided. All members must be provided. RESTORE D...more >>

Not sure whether this forum is for people new to SQL Server, or for adding new users to SQL Server - either would be relevant. I set up a new computer, installed XP Office SP2. I was logged on as the Windows XP user "Administrator". I then installed SQL Server 2000 Developers Edition, and...more >>

Hi, The transaction log on our dev database is huge (1.5gig), it doesn't really need to be that big because its a dev database. How can I reduce the size of this file? Thanks amit ...more >>

Hi, I have a query that uses Group By and Having to retrieve records. The query is working fine and I want to get the Row Count of that Query. How will I do that. Thanks Kiran ...more >>

Hi Every one! I want to add programming newsgroup in my outlook and some other how do i do that.... Thanking you in advance.... -- -Permood ...more >>

In order to install MSDE 2000 I need to change my SA password. So at the command prompt I'm typing: "osql -U sa" and pressing ENTER. But I get this error message: 'osql' is not recognized as internal or external command, operable program or batch file. Can anyone please help me change ...more >>

Hi, I'm trying to build a contact management system from scratch and for free. I started using MS Access 2002 but heard I could use MSDE 2000 (free desktop version of SQL Server). The only problem is my PC is Windows XP home edition. And I don't think MSDE 2000 runs on it. Why hasn't MS...more >>

Hi! i recently installed SQL 2000 and i have the following problem. When i select a table from any database and try to open it an error message occurs that says "The query cannot be executed because some files are missing or not registered" I tried to reinstall SQL, to install SP3 and nothin...more >>

A remote office developed a PC-based app that writes its data to a text file. We want to maintain this data at the main office, and in SQL Server, due to the significance of the data. A typical day's file may have a couple hundred records, written over an eight hour shift. Rather than changing...more >>

Hi, I am writing an application that uses SQLServer 2000 as its backend, I have two questions: 1. I have a script file that creates the database, tables, stored procs, triggers, and inserts any default data. I would like to break the file up into separate files (db creation, table creation...more >>

I need to display 2 columns on the same row that have different criteria as follows: CustName 2003TotalSold 2004TotalSold Can you help me with the syntax of my statement; it is something like: select cust.name, sum(orders1.amount) as Total2003, sum(orders2.amount) ...more >>

I get this error Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17055 Date: 1/19/2005 Time: 11:08:14 PM User: N/A Computer: TGKW001 Description: 19012 : SuperSocket Info: Bind failed on TCP port 1433. For more information, see Help and Support Center a...more >>

What is a sql command to list all primary keys in a database in 2k? Ryan ...more >>

I inherited a SQL-Server db with PDF images stored in an "image"-typed field. I've experimented with ReadBLOB and WriteBLOB as a possible way to have MS Office-tools users display the PDFs, to no avail. Any leads on how I could give users (of MS Excel or MS Access) a "button-click" way to d...more >>

Hello out there, I've read somewhere that you can do multiple "SELECT WHERE field<><somevalue> by using joins with a NOT EQUAL condition. Is this syntax correct for removing values in t2 from t1? select t1.id, t1.name, from t1 INNER JOIN t2 ON t1.id<>t2.id The above query sti...more >>

Hello, We are trying to add a user to MSDE that can backup but thats it. sp_addrolemember, sp_addserverrole has me confused. Does someone have the sql commands to add such a user? Thanks! Matt ...more >>

Hey all... I am trying to import all my access tables into sql server... While using the data import wizard I am getting a "DB_TYPE DBTIMESTAMP Data Overflow invalid character set" error I know this is all to do with the way that the dates are formatted but even changing the tables dir...more >>

Hi, Is there a way to get the current Row number. If get this as a result of select statement, 12 as 56 yu 89 gh I need like this 1 12 as 2 56 yu 3 89 gh I saw some eg.s using temporary tables. But Is there a straight forward way to get this. Thanks Kiran ...more >>

Dear Sir, I have some problem about user that run report slow. Example User A is System Administrator in SQL Database and User B is not System Administrator. I test by change user B to System Administrator in SQL Database and test run report, it slow (more than 3 minute:=slow, about...more >>

Hi, I need to copy over some values from table # 1 to table # 2 and I need a little help doing so, here is the info, maybe someone can help me out creating this query. Table # 1 field1 : attachment_id (int) field2: user_id (int) Table # 2 field1: attachment_id (int) field2: Object...more >>

Hi all Now I can connect and get data from SQL Server.(I can execute SELECT functions). But when I execute INSERT INTO ..... I get the error -2147217900. I couldnt find info on the web.. thanx all -- Murat Demir HEKÝMOÐLU have a nice day.. ...more >>

Hi, Lets say I have a table with these fields: ID, Category, Prod_Name. The first few rows look like this: 1 CatA ProdA 2 CatA ProdB 3 CatA ProdC 4 CatB ProdD 5 CatB ProdE 6 CatC ProdF 7 CatC ProdG From this table, I'm looking for a result ...more >>

Hello All I am a newbee at SQL Server. I have SQL Seerver 2000. I am connecting to the server with asp. Can you give me information about this two? How do they work together etc..? If you can send me any documentation that will be great ? Thanx everyone.. -- Murat Demir HEKÝMOÐLU Hav...more >>

I have a table 'orders' in my database with one of the column 'orderid'. Now when ever any one tries to delete any row with specified 'orderid' from the table 'orders' I want to insert a row in a table 'OrdersTriedToBeDeleted' with the 'orderid' as one column. ex:- if I execute delete from ...more >>

I have a table 'orders' in my database with one of the column 'orderid'. Now when ever any one tries to delete any row with specified 'orderid' from the table 'orders' I want to insert a row in a table 'OrdersTriedToBeDeleted' with the 'orderid' as one column. ex:- if I execute delete from ...more >>

My company sells a software application written in Access 2002 (FE/BE on network, Access Runtime). The usual number of users is 5-6, and after about a year of the app being used, the data file gets to about 90MB in size. I was instructed to investigate changing our database to SQL Server and ...more >>

Hello, Is there the possibility lo lock temporarya SQL server login so that access to the server is prevented? From EM it seems is possible to deny the access only when the autentication is performed from the Operating System.... But what if I wnat to lock a SQL server login? Any info ...more >>

Hi, Can I return two values from a stored procedure. Presently I am returning the data from the select statement. Is there a way, so that I can return someother value from the same stored procedure I am calling this stored procedure from .Net Thanks ...more >>

It is posible to sett in an photo in table or must I use a link? If it is, who do I it?? Many thanks Erik Gjertsen ...more >>

G'day, I'm migrating an Oracle database to SQL Server 2000. I'm using Visio to reverse engineer and generate the database creation scripts. I noticed in the generated script that in addition to creating a foreign key constraint using ALTER TABLE ... ADD CONSTRAINT the code is also generating a...more >>