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 >>