Error running Index Tuning Wizard
Anyone know the following error... Error Analyzing workload (60) Thanks Scott Edited by - scottsanpedro on 02/13/2002 09:59:53 AM
2002-02-13
career
DTS and ODBC connections
I want to read data from a table using DTS. The data source is the "Microsoft ODBC Driver for SQL". But I can't find where to specify the actual "connectoid" I want to use! TIA, Bill
2002-02-12
2 reads
Newbie Needs Help with Trigger
Here is the situation: -User updates a record. -Before the record is updated, I need to insert a 'before' record to the HISTORY table. -Then I need to go ahead with the update. Can anyone provide basic code to do this? I know this much: CREATE TRIGGER Ticket_Update ON [dbo].[CSDTicket_Info] FOR UPDATE, DELETE AS And […]
2002-02-08
1 reads
Date Problem
When using the convert function in SQL 6.5 , i use the style property of 106 to get dd-mm-yy format. This works for some tables but with other tables the output comes out as mm-dd-yy. Any ideas why this inconsistency??
2002-02-08
Server Name Differences
What are the issues with Restoring a Master + User DB's to a Standby Server with a Different Name ? (Standby Server NT name: SQLST1 Standby Server: Master..sysservers - the field for Server Name is SQLProd)
2002-02-04
1 reads
Help, Cannot restore Translogs correctly!
SQL 2000 (no Sp) running on WinNT4 SP6a I am having trouble restoring by translogs to my test server. I can restore fine when I do the backups both (full and translog) manually. But the jobs that I have setup to run automatically do not allow me to restore as I get the error-> The […]
2002-02-04
PK Trim ?
Hi , Can any one tell me if there is a way to tell sql server that 1 space != 2 spaces ? I try this in isqlw : create table T ( PK varchar (5) NOT NULL primary key ) Insert Into T Values(' ') Insert Into T Values(' ') and i get : […]
2002-02-04
4 reads
2002-02-02
1 reads
2002-02-01
Is there a trial version of SQL Personal Edition
In another posting, I received advise on installing SQL Server on a Laptop running OS ME. I appreciate the advise. I am learning SQL and would find it convenient to have SQL on my Laptop. Is there a trial version of the SQL Server 2000 Personal Edition? If yes, where can I download it? There […]
2002-01-31
10 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers