I did an upgrade of a site system, computers and servers from NT4 server and workstation to Win2K server and XP workstations. I made a backup of the datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a change DB owner and then preformed another backup from the PDC to move to...more >>

hi, I have this scenario : My log is full, and nobody can writte into the db, how can I clean it ? (recovery model is full and I have a backup of log before this problem) Do you know the steps ? regards, -- ritta_rex...more >>

Hello All - I have two physical drives attached to my local machine (C: (40GB) & E: (250GB) ) I have a large .mdf & .ldf that I detached from C: and (using windows explorer) moved to my E: drive. Now I want to re-attach these files, but SQL SERVER only see's the C: drive. I was able to...more >>

I currently have SQL 2000 w/sp4 on my server. Can anyone tell me how I can create a new instance? I'm looking to install WSUS and so far, because I've installed it without creating a new instance, backing up the database is a bit difficult for me....more >>

I am very new to SQL 2000 and I created an operator. Can anyone guide me on how can I delete this newly created operator?...more >>

Hi I need to upgrade an access app to sql server, for the first time. In the first phase I would like to upgrade only the backend to save time. Are there any pointers for a newbie to help in the upgraded? I need to give a time/cost estimate to client for the upgrade (backend & frontend)....more >>

I have a table that has a units column that is varchar because some of the units have text in them. I'm attempting to update the units into a new field that is called Fxd_Units. Update Tbl_MyTable Set Fxd_Units = Cast(TxnUnits as Numeric) Where TxnUnits not like '%M%' This throws the er...more >>

Hi There, I have a table with a branch code, pay date, hours & description. within the description field the options are either Actual or budget. id like to create a query to add to my reporting services dataset that works out the differnce between the budget & actual for each pay period/bran...more >>

Hi All, Could anybody tell me why is better have an ERP with SQL Server than other with Visual Fox Pro databases?. My boss are evaluating two software one in Visual Fox and other in with Visual Basic or ASP but both with SQL Server database. I understand why is better SQL Server if I have 50 ...more >>

We are moving to a new ERP system next year based upon a SQL database. Max 100 users, generally between 50-60 users. I've tried to find out what the recommendations are for running SQL on a different server to the actual ERP system, but there don't seem to be any. Would anybody have any commen...more >>

Hi all, NooB questions: What's the difference between a login user and a database user? Thanks! ...more >>

In SQL Server 2000, I have a field that is datetime. It stores it in this format: 7/27/2005 8:32:44 PM When I retrieve data from this field, I'd like to display it in the same format, but in 24 hour time: 7/27/2005 16:32:44 I was trying to manipulate it with ASP, but am getting errors. I...more >>

Hi, I am currently trying to develope a reporting system through Enterprise Manager. The origional Database was an Access Database. I tried the upsizing wizard to put the Database onto the SQL Server which didn't work. I now have to re-type all my queries in SQL through Query Analyzer. ...more >>

hi guys, i have a pb usine the convert and cast function from nvarchar to decimal when i run for erxample this script declare @TT as nvarchar(6) set @TT = '2,2' select cast(@TT as INT) i got this message Server: Msg 8114, Level 16, State 5, Line 3 Error converting data type nvarchar ...more >>

Hi, I have a database in MS Access, and I want to copy the table structures and data over to a SQLExpress database. Could someone please advise what the best way of doing this would be? Do I need to create all the tables manually, then copy the data, or can I do it all in one fell swoop? ...more >>

Hello, I am trying to upsize a table from Access to SQL Server and get this message: CREATE UNIQUE INDEX PHONE ON Contacts(PHONE) Server Error 1505: CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 5. Most significant primary key is '<NULL>'. Server Error 362...more >>

I am attempting to restore the master database in SQL Server 2000. However, I continually receive the message: "You are attempting to overwrite an existing database. Check the force restore over existing database option to overwrite the existing database." I have started SQL Server...more >>

I know the number of rows returned compared to the number of rows that exist---a percentage-- determines the selectivity of the data. Is there a commonly accepted percentage that determines, 'yes, this data is hightly selective'? Returning 90 of 100 is 90%, definitely not selective. Returni...more >>

I am having trouble with getting a networked computer to find an instance of the SQL server on my network....more >>

I am trying to import data to an SQL Database from Access. I tried importing using the Enterprise manager, importing into a project connected to the Database, and using the Access upsizing wizard. The Enterprise Manager gives me this error: Error at destination for Row number 516. Errors enc...more >>

When calling multi select statements in a stored procedure how do you set the namespace to each select statement? Thanks Chris ...more >>

In a datetime field, my app forces users to use the 7/25/2005 10:58:39 AM format. If users end up typing in 24-hour times, will it break anything? ...more >>

How can I copy data from a varchar field into an integer field, obviously copying only the values that can be an integer? For instance, I have data in a field like this: 1 2 A1034 432 B876 and I want to create a new field and copy over only those values that can be numeric, i.e., 1,...more >>

Hello, I am considering moving a company's Access App to SQL Server. I am confused about what I need to accomplish this in the way of Server Software. The pricing on the Microsoft website says, Standard Edition: $2249 with 10 Cals. The SQL Server would be running on one network server,...more >>

Does anyone know where I could find comprehensive information (on the net) on how to intepret SQL server's execution plans? For example: Hatch Match/Left semi join - Cost: 41%; Sort/Distinct Sort - Cost:100%; Merge join/Inner join - Cost: 0% Thanks in advance ...more >>

Hello, in my app I've a constraint like constraint sales_fk foreign key (salesman) references members (member) What is the use of the keyname "sales_fk"? My idea is only to remove (or edit) the constraint. May bee, there is also other use, please could any one tell me more or other...more >>

Hi there I have a table with three fields, viz. EmployeeNo, WorkDate, Company. Records for a particular employee (viz. 660) are given as follows: EmpNo WEDate Company 660 19990530 SA Cargo 660 19990606 SA Cargo 660 19990613 SA Cargo 660 ...more >>

Hi there I have two tables, T and U, that look something like this: Table T EmpNo EmpName ---------- --------------- 1 Larry 2 Lawrence 3 Laurence 4 Laurent 5 Laurel .... T...more >>

Hi, I have SQL 2000 runninh on a 2-node cluster running Server 2k3. When I start Enterprise Manager from my PC, a huge SQL.log file is created (or gets appended) and each action afterwards takes quite long time to do. This happens only from my own PC. Other admins' PCs do not have the same ...more >>

I'm creating a vb.net web form that connects to an access database. I just need clarification on a SQL statement. Basically, I do a record update like so: UPDATE TClaimTrak SET resolved = True WHERE id = 40 Now I need to not only do an update of a field, but also do update another fie...more >>

I have inherited a SQL 2000 SP3 system running on W2K SP4. We have a table load process that uses BCP to insert data and build a temporary table. I then have a stored procedure that appends two system parameters onto each row. The procedure then selects all the rows from the temporary table...more >>

I've a project to work on that needs to be done in Visual Studio 2003 .net and MySql 2000. But the machine I'm on currently has the VS 2005 beta and SQL Server 2005. I've already figured out that VS 2003 and 2005 can be installed side by side, but I can't seem to determine if SQL Server 2005 a...more >>

I upgraded my server from 2 processors to 4 processors. Is there any tuning or adjustements in SQL that need to be done in order to take advantage of the new hardware? It is SQL 2000 SP4 Enterprise Edition. Any help would be appreciated and thank you in advance. ...more >>

my sql server is too slow, like an example - if i want to open an table or like if i want to open any section of sql server or like i i want to go to stored procedure section, any where i want to go, i taking time to open it was fast before but from last few days is slow can any one please te...more >>

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

Hi all, The Win2000 server in my office starting running slow and find that the SQL2000 server eat up many cpu usage.... I'm thinking it may be caused by a query in an in-house application which doing a Select Max query before insert a history record, the history table probably the biggest ...more >>

Is there an easy way to construct a query that would calculate year to date totals? My original table is as follows: Category Month Class Amount 1234 01 Rate 10 1234 02 Rate 100 5678 01 Vol 20 5678 ...more >>

I am running distributed transactions via linked servers. All the SQL servers involved are on SQL Server 2000 and on Window 2000 professional. I am receiving distributed transaction failure error messages when trying to run distributed queries. The error message is ------------------------...more >>

Hello Wath type of SQL Data Type should I use to store this file ? You'll notice that there's some problem with the Ascii #13 and Ascii #0 How can I do this ? Thanks Olivier (sorry for my poor english (:-/) ...more >>

Is there such a beast or is Microsoft going right from SQL Server 2000 to SQL Server 2005? TIA, -Tom ...more >>

I can't remember the default password that accompanies the sa login id. Can anyone help me out with this? ...more >>

I am running SQL Server 2000, still pretty new to this. I ran the DTS Import/Export Wizard to create my table and insert the data 150,000 records. The data was only suppose to be changed occassionally, a record at a time. Now I need to insert another 50,000 records, not quite sure how to do ...more >>

I am a SQL novice and would very much appreciate your assistance with a restore problem. I am trying to restore a db from a backup location and am getting the following error message: "the media set for database "SEItoDDA" has 2 family memebrs but only 1 are provided. All memebers must be...more >>

Hello I'm a newb. I'd love some help solving this apparently simple query. table one contains email sender addresses table two contains emails From table two I wish to SELECT all emails whose sender address is not in table one. Can anyone suggest how this might be done? Thanks in a...more >>

Does the upgrade from per seat license in sql server 2000 to processor based licensing requires reinstallation of sql server?Is there an easier way of upgradation. Tanks in Advance Darshan Ahuja Quark...more >>

Hi all! I'm reading Sybex book, Mastering SQL 2000, and I'm having problems with two queryes. 1------------------------------------------------------------- USE pubs BEGIN TRANSACTION DECLARE @newprice money UPDATE titles SET @newprice = price = price * 1.1 WHERE title LIKE 'suschi%' P...more >>

I am new to SQL and I would like to create a small database application where I can store the data on a network drive and have about 10 users access the data from their desktop. I want to use SQL Express to do this, any ideas / examples of how to get this done, especially dealing with conflict...more >>

Hi, I have a database that stores a number. I need to have a built in function that will apply a function to the number and then return the number that produces the largest number. How can i do this? eg. id - name - number 003 trade 45 345 var 77 45...more >>

Hi! I am practicing SQL and just using the MSDE (free version of SQL). Is there a way that I may access the database thru a free query analyzer just like in MS SQL? regards, Me ...more >>

I'm trying to duplicate a set of values in a table for a second user. The table only has 2 columns one containing a username and the other containing a code. Given the following, how would I insert new rows with a different username using the same values of another username from the same table...more >>