I develop intranet-based training that connects to a database. My training products are sold to customers. Because of a large customer, I am trying to replicate an Access database (used in the past) to SQL Server. I obtained the developer edition of SQL Server 2000 and have developed a new ...more >>

Hi, If anyone can explain why this is happening, it would be greatly = appreciated: Problem Description: 1. Within SQL SERVER ENTERPRISE QUERY ANALYSER, an SQL statement is = entered=20 and executed. No results are returned. SELECT ID FROM PRODUCT_TABLE WHERE=20 ID NOT IN (SELECT ...more >>

I develop computer-based training with a database for customers. The database works with the computer-based training piece to store user results. I am currently trying to replicate an Access database in SQL Server. For large customers, Access is no longer adequate. I obtained the devel...more >>

Is there a way to restore a dropped table??? ...more >>

Like a lot of people, I downloaded and installed the free Express versions of SQL Server 2005 and Visual Web Developer (for ASP.NET). I'm walking through one of the Walkthrough tutorials that came with the Web product, and in the beginning it tells me that the Northwind database is a prerequi...more >>

Been doing triggers for years in sql 2000 now I find I got triggers that = worked in a previous versions but I can no longer just pick up and = paste my code in sql 2005 triggers. One sample. I'm in mydb on myserver and have a table mytable with two fields = LastupdateOn and LastUpdateBy, I wan...more >>

Hi, Any help would be greatly appreciated Can anyone give me a detailed example?,I cant get this to work I have stored procedureA which has one input and one output variables. I also have stored procedureB which takes in the value of the output variable from stored procedureA and performs a ...more >>

How do I update a date field to reflect a specific date? My field is formatted at smalldatetime. I've tried: UPDATE dbo.Dealers SET dbo.Dealers.BillQ2 = 2005/11/14 FROM dbo.Dealers, aipdn.qtr2 WHERE dbo.Dealers.DealerCode = aipdn.qtr2.DealerCode And I've tried it as 11/14/2005 also. ...more >>

Had a create trigger button that was east to use in Enterprise manager, Don't see it in the standard buttons in the new 2005 management studio. Was that functionality removed? If not where is it. Thanks for any help, Bob ...more >>

Can anyone tell me how to remove a comma ',' from a text field? I am coping records to a csv and it is separating my text field into two columns when it finally reaches the CSV. SQL Server 2000 SP4. It is also wrapping some rows to 2 or 3 lines. My query I am using is: Select notes fro...more >>

is their a way in sql code to do jobs like copy files on disk, create folders ect...? ...more >>

Can anyone tell me how to remove a comma ',' from a text field? I am coping records to a csv and it is separating my text field into two columns when it finally reaches the CSV. SQL Server 2000 SP4. Txs. Select notes from rn_appointments results: Col 1 Col2 How do y...more >>

I have a field that is set to autonumber (identity type). As records have been deleted, i found that new inserted records does not reused the number (autonumber). Any way to solved it??? -- xxx...more >>

Hello. Please forgive me if this post is not relative to this newsgroup and if someone could advise which group I should post this in I would appreciate. Does anyone know or have any ideas on recommended software or methods in capturing data from scanned paper documents into a SQL Server 2000...more >>

Hi everyone! How can I do to copy the data and the indexes from an existing table on a database to a new table in another database? I've tried with select * into base1.table1 from base2.table2, but it only copy the data and not the indexes. Can I do it by code? I'm trying to avoid the use...more >>

is their any code for granting permissions to all objects? sam ...more >>

Hi Group I interest count the characters in the field (string), because, the result i need whit 2 characters i.e. ALCOCER = 7 I need ALCOCER = 07 If the name is has more than 10 characters. Tnks...more >>

I have one recordset with multiple values, I need to retreieve those values but instead of creating multiple recordsets I want to see if there is a way to retreieve all values in just one recordset. The queries are: Recordset 1: SELECT paramvalue FROM ParametersUsers WHERE paramname = 'do...more >>

I am new to sql, I am trying to run a job with type transact sql . But when I open the script it gives me an error saying that the sript is to large and will have to be truncated. Can anyone tell me if I can increase this space so that it accepts the script. Thanks...more >>

Hi all, I'm hoping that perhaps someone could help me with a question. I am running SQL Server 2000 standard edition. I have two databases, say A & B, what I would like to know is whether it is possible to call a stored procedure in database B from a stored procedure in database A? I've t...more >>