Search results for query: *

Good Morning. This one has me really, really, confused. (and frustrated !) This "mdb" is to track warranty claims received. Table 1: tblClaimNumber, one field: ClaimNumber. Integer - defined as four (4) digits: 0001, 0002, etc Table 2: tblWarrClaimLog 5 fields: LogNumber (text)...

Good Afternoon. This one has me scratching my head. I have a Sybase data server running on a HP-UNIX host. I've created a script that backups up the databases on the Sybase server. When executed MANUALLY, the script runs fine. Before doing the backups, the script deletes the earliest backup from...

Good Afternoon As part of a SSIS package, I have a task that exports a table to a text file. One of the fields is a datetime data type. When exported, the datatime data is being stored as "YYYY-MM-DD HH:MM:SS.SSSSSSSSS" That's correct; nine decimal seconds. I need to import this text file...

I have a DTS package that has an ActiveX task that uses the FileSystemObject to create a FTP batch file. I'm now trying to run this package from SQL Server 2005. Because of this and other tasks that won't migrate, I'm running this DTS package from a "Execute DTS Package Task" in SSIS. The task...

Good Afternoon This one has me stumped.. I installed SQL Server Books Online (Server 2000) The left-hand pane displays the contents, etc. However, the right-hand pane displays the IE error "The page cannot be display" The error message ends "Cannot find sever or DNS Error Internet Explorer"...

Good Afternoon I'm having a problem with an application written by a developer. The developer wrote an Access app in VBA. The dll was written in VB 6.0. I've installed the MDE. Problem - When I click on a button to run a procedure in the program, I get the following error: "The expression On...

Good Afternoon We are using DB2 version 7.1 for zOS, versin 1.2.1 How can I determine the "sevice pack"/maintenance level of DB2 ?

Good Afternoon I altered the collation of a database to become case insensitive. (ALTER DATABASE X COLLATE SQL_Latin....) This altering updated SOME of the values of syscolumns.collation However, running an UPDATE script to change the remaining non-null column names to my new collate value...

Using DB2 for OS/390, is there a way to keep the same OBID for a table that needs to be dropped and recreated? I'm getting a -736 sqlcode when trying to recreate a table with it's initial OBID. No other object in the database has that id assigned. Thanks for any help.

Good Afternoon What are the advantages/disadvantages of using REBUILD INDEX vs. REORG INDEX ??

Good Morning I have a package that is being "called" by a stored procedure. I have set the package property "Fail package on first error" to true. ? - Is there a way to pass the results of whether the package ran sucessfully or failed back to the calling stored procedure ? JRW

Good Evening This one has me baffled. I've developed a simple DTS package (called Copy Table) that establishes an ODBC connection with a Sybase Server/Database, and copies a table to a table on my MS SQL Server Server/Database. My intent is that a Powerbuilder client will associate a button...

Good Afternoon I need to EXECUTE a DTS package from a stored procedure. I'm using the DTSRun Utility Advanced feature to create the run script. If I check the "Encrypt the command" box, the generated script is too long. Is it possible to create a script with just some of the parameters (like...

Good Morning I would like to EXEC stored procedures as a result of flow control. My code: SELECT CASE WHEN Count(*) = 0 THEN EXEC Proc1 WHEN Count(*) > 0 THEN EXEC Proc2 END FROM Table1 WHERE Table1.flag = 'Y' Any Ideas ?

I would like to import data to a SQL Server 2000 table. I have the source data in a text file, tab-delimited and as an Excel 2000 file. The data is sorted. When I import, using eirther the Excel file or the text file, the data rows get "scrabbled". Any ideas why this is happening ?? Thanks

This one has me baffled.... When I use Enterprise Manager to show (query) records from a table, Nulls are displayed as <null> and the fields are undefined. O.K. so far so good But when I use SQL Query Analyzer to show (query) the same records from the same table, Nulls are now displayed as...

Good Morning In SQL Server 2000, I'm attempting to edit a ntext field. I'm getting an error message saying &quot;Cannot edit this cell&quot; I'm logged on as sa, so permissions should not be an issue. I can't change the field type for fear of losing data. Help!

Hello. My laptop runs Windows 2K Pro. It was setup by an intern in my department. Unfortunately, he misspelled (sic?) my name (rather badly I might add). So under the General tab of System Properties, the name is wrong under &quot;Registered to:&quot; ? - Is it possible to change this...

In a data entry form, I would like to have a control with the default value be =Now() WITHOUT the time stamp. =Date() gives a #Name? result. The control source is a field defined as a short date. Any ideas ? Thanks