I have a Windows 2003 server with SQL Server 2000 running on it. The server is performing dual roles as both a database server and a Primary Domain Controller. When attempting to add logins for the server, I see the domain listed twice. This causes any attempt to add a user to fail. I get ...more >>

In access: select (1+2) as T1, (T1*2) as T2, (T2 *3) as T3 from abc : OK But why it can not be run at mssql 2000. How can I achieve this in mssql 2000?...more >>

Our student system based in SQL Server 2000 contains pictures of our Students. Our Student System Application (FoxPro) displays the pictures but does not have the ability to print ID cards with the Student pictures. I want to use Access 2000 (the verison that the schools are on) to create Stud...more >>

Hi, Recently, i convert the database from access 2000 to mssql 2000. After that, i find access sql function ' iif( , , ) ' can not be run on mssql 2000. So, my question is that any function can replace 'iif' in mssql 2000? Please give an example. Remark: If.. then..else can not be used in vie...more >>

I have a SQL database which I would like to use in Access2003 program. How do I establish a connection for Access to utilize this data? Thanks Paul...more >>

select first 1 sum(gesamtpunkte) from spielerserie where StartJournalID=12 order by gesamtpunkte desc; obviously does not work. ...more >>

declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'SRVDB1@mydomain.com', @TO = N'gmatteson@mydomain', @priority = N'HIGH', @subject = N'Process Success', @message = N'Database Backup Succeeded.', - Rather than putting Database Backup Succeeded, I would like to put "@...more >>

I have a client who accidently deleted the MDF file for a SQL Server 2000 database. They restored the file from tape but now the log file shows the database continuously restarting: 2005-02-24 10:09:42.24 spid55 Starting up database 'downs_IR'. 2005-02-24 10:10:17.24 spid55 Starting u...more >>

Running Windows 2003 Server with SQL Server 2000 w/SP3a This is the message I recieve when I go to add the profile to the server and click Test. Any ideas? Thanks, - Gabe xp_test_mapi_profile failed with mail error 0x80040111 ...more >>

I have followed all the instructions to setup a linked server, yet when I try to use the link I get the error: Exception occured in Microsoft OLE DB Provider for SQL Server, Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.. ADO Error Code: -214...more >>

Hi, Can anyone point me in the direction of, or recommend a good beginners SQL Server tutorial site? Thanks in advance David K ...more >>

Fundamental question this but is there any set law when choosing the right data type as applied to characters. I have a list of names which I’ve imported into sql 2000 from an excel file. It defaults to 255 nchar is this correct? Should I leave it? Many thanks Sam ...more >>

hi!! I am writing sql stored procedures and am stuck on this design issue as follows I have a procedure named InsertIntoTbl for doing inserts. However i need to do 2 validation steps before i can do the insert 1 step 1 check if record already exists 2 step 2 some other validation using an...more >>

Hi We are new users of SQL 2000, running it on a 2003 Server on our LAN. At the moment, if I want to run queries or administer the db, I am VNCing to the server - which, apart from being slow, is not ideal. Can anyone tell me, please, if it is possible to add Enterprise Manager and Que...more >>

I have been trying to connect to a remote server using the "CONNECT TO" statement and I keep getting an error. I have followed the docs to the letter I have seen but still cannot. How would I do this? Paul...more >>

OK ... maybe I am being dumb but for the life of me I cannot figure this out. I have two servers both running 2003 and SQL Server 2k. I need to backup a database across the network from server A to server B. I need to do this without creating a share on either server. I have tried mapping ...more >>

Hi Everyone, I am new to SQL and really am finding it a great product, but I want to do something that I think would be simple but can't find anything on Technet and wondered if anyone here can point me in the right direction:- I am wanting to import data from a legacy database still in us...more >>

Does somebody know about how many transactions can SQL server run at the same time?...more >>

Yes, believe this if you will. Today I was told a customer table disapeared with all the contract tables still there. CustomerID is the PK in customerTbl and is a FK in all contractTbls - a 1:N relationship. Apparently alll the contract tables were still there and if one looked in them th...more >>

Hi, for generating high volume stresstest data, I created a UDF that generates a variable lenght string variable for usage in load processes. This is my script: create function f_generate_string (@length int) RETURNS varchar(4000) as BEGIN DECLARE @i int DECLARE @str varchar(4000) S...more >>

In SQL Server 2000, Developer Edition, is there a way to track logins, both successful and unsuccessful, after the fact. Eg, is there a way, for example, to view all login attempts for a previous date? Many thanks Mike Thomas ...more >>

I'm a programmer rather than a DBA and have been having trouble with using a second computer to access and test some applications on SQL server. I am using SQL Server 2000 Developer's Edition. I have an SQL Server instance on Computer1 to which I am connecting to from Computer2. The S...more >>

Hello, I have trouble connecting to the MSDE databsae via my laptop computer that is connected to my home network. I have MS SQL Server (MSDE) running on my main computer. I created a C# application to connect to the database from both computers. When I try to connect from the laptop, I ...more >>

I am new to SQL and am needing some guidance on how to enter data into an SQL database. When using Access I had a form to enter data or entered directly in the table. Is there a way to get the Access forms to transfer to SQL or a program to make the forms? Thanks Jeff ...more >>

Hi all, I am fairly new at the SQL game, but I have a situation that I wish someone could help me with. I have a data feed from a PABX that sends call records out into the real world. I need to be able to capture that data ("|" delimited and ended with CRLF) and put it into a table that I...more >>

I am looking for a way to find all the tables in my database that are empty. I know how to do it on each one individually but that would take too long. How can I do a mass find of all empty tables in my database? Thanks ...more >>

...more >>

Basically I want to know if a certain value exists for a certain column in the table. I don't care how many rows may contain that value, I just to need to know if any row contains that value. Since it is a large table I don't want to search the whole table. I want the query to stop as soon as it ...more >>

Platform: Windows 2003. SQL Server 2k sp3a, already with a default instance We are planning to install a named instance on the server that already has default instance installed. We will follow the instruction from books online( How to install a named instance of SQL Server 2000 (Setup)). ...more >>

I am in the process of developing a web site for my company and would like to use SQL Server. Our hosting company Crystaltech.com offers SQL DB's in their hosting packages. Our company does not own SQL 2000. My question is: Can we purchase SQL Developer Edition to design the DB and maintai...more >>

This is probably such a bonehead question so forgive me. I have an existing database that I need to import CSV files into it . That part I can do. Where I am having my problem is when I have two items that are the same, instead of updating the existing row it creates a new row. How would I...more >>

I am a programmer, not a database admin or sysadmin, hence my stupidity when it comes to SQL Server. I have been asked to try and retrieve alll transactions enetered into a certain table yesterday. There is no date field in the table that will help, and nothing else either. A wrong amoun...more >>

Ok, this is stupid, I know I should know this but... I've got the following SELECT ID, Name + ': ' + SerialNo AS Name FROM Products ORDER BY Name This always orders by the Products.Name field. I notice that if I change the AS Name to something that isn't in the Products table and change ...more >>

What does database integration mean? I assume it means "integrating databases" but what does that translate as in a real life example. I'm hoping someone can give a helpful definition and an explanation of what that means in the real world. Does it mean merging 2 different kinds of databa...more >>

Hi, I'm trying to copy a live database onto a test server so that I can do some work without messing up the live. I seem to of sorted out the Logins, i'm using windows authenticaition and have the same user that I have logged in with set up as the service logon within SQL (had lots of fa...more >>

I need to run ASP pages on laptops without internet connections. The laptops are setup as master and client using SQL Server. Does SQL only server databases? Can IIS or PWS and SQL co-exist on the same machine? I know nothing about server technology. Thanks, TM ...more >>

Hi all I am using Asp with SQL Server. When I want to insert a value (ex. 0,20) into db with the data type int. But it doesnt work. What is the problem and how can I solve this -- Murat Demir HEKÝMOÐLU have a nice day ...more >>

Hi, Need some help here... Table1 collums number - name Table 2 collums number1 - number2 - other Need to get 'name' from Table 1 , considering that number1 = number and number2 = number. They are not the same number, and number1 and number2 are not related. Just need to get 2 differ...more >>

Hello, As part of Active Directory migration (from NT 4.0 to Server 2003 Enterprise), we will be replacing our current SQL server hardware with a newer server which will be running windows 2003. Can anyone point me to any document on how to go about doing this please. I am very new to SQL ...more >>

Hi, how can i create a new table from a select statement? i use select into, but my select query has case columns and query analyzer says that i did not specified a column for them. how do i do it? thanks in advance for your help ...more >>

I have created a batch file in Visual Studio .NET. It's like this: osql -S %1 -d %2 -U %3 -P %4 -b -i "dbo.Sun_Report.prc" Sun_Report.prc is a UNICODE file. When I run the batch it throws this error 1> 432> Msg 170, Level 15, State 1, Server PLWIL-ARCHIBUS, Procedure Sun_Report, Line 18...more >>

I am working on creating a function to modify my Calendar Date Format. SQL have several Date formats but not the one I need. The date format I need is 01-AUG-2005 but I can not seem to get it fully working. The date format I am converting from is 08/01/2005 and converting to 01-AUG-2005. ...more >>

How do I found what jobs have previously been scheduled for a database. I see the Tools - Job Scheduling option, but now an option that shows me what has been created and scheduled. Thanks....more >>

I have a txt file with about 400,000 rows of data. I need to import this data into SQL 2000. Is BCP the way to go? Is there any special format the file should be in. Is there a sort of BCP for Dummies documentation to help me? Paul...more >>

Hi, how can i prevent the access to my tables in sql 2000. ...more >>

Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it ...more >>

Hello kindly tell me that is there any way to update a table in a user defined function I want to execute a Update Command in the Function . Plz help me as soon as possible Thanks ...more >>

I'm having trouble trying to get a Select Statement working, my current statement is attached below. I have two tables: Table one (tblProducts) is product description & Table two (tblExtraProd) is a list of ingredients for each product. I need to be able to select and ingredient that needs t...more >>

There are two servers. One local second linked but SQL Server. In local server linked server is registered. From enterprise manager we can access tables on this linked servers. Also from Query Analyzer we can access table of given database on linked server. Local login 'sa' is mapped for this l...more >>

Hi all, I want my application's Installer to automatically install the SQL Connectivity on machine in which the Connectivity does not exist. For this i require a Stand-Alone installer (to be called from my Installer if connectivity is not found). Do you know if there exists a Stand-Alone C...more >>