Search results for query: *

In your query when you join the tables you have 3 choices for the tpyes of joins. When you join the tables right click the line that joins the tables and click "join properties". You will have to specify include all records from tblForms and only those records from tblRoute that are...

Will try. It's SQL2K

SUBSTRING ( expression , start , length ) - retrive a portion of the string. LEN ( string_expression ) - tells you length of the string -- use this when you need to obtain a substring combined with CHARINDEX to find the postion the space is in the string. CHARINDEX ( expression1 ...

will post another one after relizing you wanted to keep first character upercase.. in a few minutes

Syntax LOWER ( character_expression ) Arguments character_expression Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to...

Scenario: I have one backup scheduled that always e-mails me when finished. This has never failed sending hte e-mail. Later on in the night I have a report that is generated from a Oracle DB linked server. The DTS packaged runs find and sends the e-mail. The package has never failed but every...

ignore last post I totaly screwed it up

SELECT Orders.CustomerID FROM Orders GROUP BY Orders.CustomerID; query will be something liek this for the combo box correct? Example: your other query will be like this. SELECT [Orders].[CompanyID] FROM Orders GROUP BY [Orders].[CompanyID]; the query to run for the command_click event would...

I think you will probably need SQL 6.x and then export the data and script out the table structure. I am not sure if there is a utility from MS -- doughtful.

Have you deleted the tables and "Re-Link" them? If new DB's work just fine with that DSN then that should do it.

I have not worked with SQL 7 but this is the way to in SQL2K: Create multiple backupdevices and create a backup routine that uses each device. This will allow you to backup to multiple files/tapes. Let me know if the same feature exists in SQL7.

The transaction log.

Read up on it's trace monitors. Run a trace for a day on the server. This will monitor all transactions to the server. You can then use this file in a performance wizard and SQL will give you suggestions on maintaing performance and also key you in on proper indexing for hte tables to increase...

Oracle V7.3.4 DB setup as a linked server. When I try to run the query select * from tsserver...witems I receive this: OLE DB provider 'tsserver' does not contain table 'witems'. The table either does not exist or the current user does not have permissions on that table. I have the correct...