I saw reference to the "Personal Edition" of SQL Server but can't find pricing or system requirements on the MS website. I am running Windows XP and have some simple requirements - provide automatic quotes for customers from a website, process a simple order for a customer, allow customers to ...more >>

Hello, does anyone know if there is a way to output a DTS package on SQL Server 2000 to its VBScript? I have seen the option to save as a .bas VB6 file but not one for a full activex script with VBScript. Does anyone know if this is possible. I would like to see the generated code for the tra...more >>

What are some good books that will bring me up to speed really quick on the specifics of installation, configuration and maintenance of SQL Server 2000? ...more >>

I'm new to SQL Server, just viewing my tables with Enterprise Manager. There doesn't seem to be a way to sort on a field. I'm used to access where you just rigth clicked on the field name at the top of the table and you could then sort ascending and descending on that field. The data in sql doesn...more >>

Hi all, What is the best way for the completion of a process on an Oracle database to send a message to SQL Server which triggers another process? I know there are probably ten ways to skin this cat, but I'm looking for something that is out of the box and can be applied in other situations; l...more >>

I'm calculating the AVGERAGE # of days between two dates. This is the code I'm using. CAST(AVG(Datediff(dd,[ST_DATE],[COMP_DATE]))As Float) AS CycleTime It seems to work fine, But here's my problem. I converted this process from MS ACCESS and the old code was simply: Avg([COMP_DATE]-[S...more >>

Hello, and thank the gods for this news group! I have a SQL 2k SP3 backend for an A2k front end; merge replication is also being used. The sql server is running on a win2k adv. serv SP3. One of my users has experienced a record deletion problem where approx. 1 minute after entering the new ...more >>

Hi all, I was wondering if there was a way to prevent server admins from seeing the source code of the stored procedures. Can the source code be precompiled and then removed? Is there an obfuscator software? Thanks. -Oleg. ...more >>

Greetings all, This should be an easy task, and Im sure it is, but as many times as I have tried, I cant seem to get this to work properly. We changed ISPs recently from a shared host to a co-located server, and our former host was nice enough to send us a backup of our old SQL2000 database ...more >>

Hi I'm new to SQL and I can't find how to solve my problem. I created two tables. The first table has a primary key field (UserID) and some other field about the user. The other table stores information which products this user has bought (there is a UserID field and Product field). How can I c...more >>

I created a query using the SQL 2000 Query Builder. It has a LIKE statement. This is the resulting query: SELECT Inventory.InvID, Inventory.YearMod, Inventory.VIN, Inventory.TagNum, Inventory.Make, InvMake.Make AS Make, InvModel.Model, CustName.NameType, CustName.Fnam...more >>

Hi, We've migrated from SQL 7 to SQL 2K. We've moved all tables, but i've noticed that the old db has a lot mor _WA_Sys indexes than I have in my new SQL 2K. Not sure if this slows down performance of our ASP pages... How to create these _WA_Sys indexes to improve performance? Thnks!...more >>

Hello, Is there any way to copy indexes from one database to another? I have a 2 databases, one is in sql 7 and the other is sql 2000. We've moved all the tables from sql 7 into sql 2000, we've made changes to some of the tables and now we'd like to copy the indexes on sql 7 to the new databa...more >>

Howdy, Heres a question, first person whom can answer this, so as i can get around this problem, will receive a bottle of Bundaberg Rum in the post. No Shit. I have a client with 1000's of records currently residing in large Excel files. they are needing importation into an SQL database [MySQ...more >>

I created a view which is queried by and asp page, when the view is called and returns the data I would like to highlight incorrect data by surrounding the incorrect data with <B> </B> on the returned query data. I would like to do this "If then else" processing on the SQL server rather that in t...more >>

Hi , I used the Web Assistant Wizard in SQL Server 7.0. After upgrade, I can't find it anymore in my Enterprise Manager. Now, I need to change the path for a HTML report. Any ideas how I can do it ? Thanks....more >>

I have a question regarding login modes in sql server. I know that there is: Windows authentication and SQL + Win authentication mode but I don't understand how come there isn't such a third auth mode: SQL auth only. Are there any good reasons for this? Is there a way to protect the database...more >>

Oracle has a personal edition of its database (free downloadable) that I have on a WindowsME system and use for self training and experimenting. Is there anything like that for SQL Server? ...more >>

Could you clarify the following. We are looking to buy a quad xeon box (ie 8 virtual processors). From reading MS documentation it looks like W2K Server won't cut it - we will need to move to W2K Advanced Server, correct? Secondly, will Sql Server 7 support 8 virtual processors under such a...more >>

I have to migrate a single server SBS 4.5 installation to a 2 server installation. The second server will be running SQL Server 2000 exclusively. The first server will be running exchange and providing fax services for the network. Essentially I am splitting the SBS functions over two servers...more >>

I found chapter questions at the chapter end but don't know the answers: 1) Microsoft specification for API for universal data access ? ADO, SQL-DMO, OLE DB or named pipes ? 2)What is associated with SQLMail and SQLAgentMail to configure them to send and receive email ? Windows login accoun...more >>

In win2k sql , "query analyzer", executed a "stored procedure". Checked the "write result to file". It created a ".rpt" file. Then, in Crystal Report 9, tried to open the rpt file, got "Can not open document", "Invalid report schema". -- Sent by msg_2222 from yahoo part of com ...more >>

running sql server on win2k. how do i use crystal report to access its fields without VB programming (preferred)?. Rick -- Sent by msg_2222 from yahoo part from com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/...more >>

I'm wondering if it is possilbe to have a relationship between 2 tables accross databases, same machine. If so how do you implement this? Jason ...more >>

I've recently been developing using Terminal Services to first connect to our server before writing any DTS packages. Obviously this allows me to pick (local) under Servername in various areas such as logging or in an Execute Package task. Now when I open the DTS package on my desktop machine ...more >>

Hi All, I have a stored proc with an in statement. The in will be smallints. My question is twofold. 1. In the sproc the variable should be declared as a smallint? 2. From my vb.net app, how do I build the in variable? Your help will be, and is, appreciated, Roy ...more >>

Fifteen years ago when databases were primarily used in the context of transaction-intensive applications, triggers were a nice feature of a DBMS system that did not get used because of performance concerns. Fast forward 15 years, it seems to me that 95% of database usage is for non-transacti...more >>

I'm new to DTS so forgive me if this question might sound silly to you guys. I just created a DTS package that copies all order information into another database on a different server (using SQL Server 2000 BTW). So I'm using a Select statement to grab the necessary information and then dump int...more >>