Search results for query: *

Hi all, Since the new version of DTS (Integration Services) for SQL Server 2005 does not support the Dynamic Properties Task, does anyone have a suggestion for an alternative? I am trying to soft code values using both INI file entries and SQL Server table values. The Dynamic Properties Task...

I'm looking for a viable replacement to SQL Mail(xp_sendmail) on the 64 bit version of SQL Server 2000. Microsofts 64bit BOL is quick to point out that SQL Mail is not supported in the 64 bit version but suggests no alternatives other that using SQL Agent mail which is useless when scripting...

Hi, I'm looking for the most efficient method for moving a clustered index from the primary key (single IDENTITY field) to an existing index containing Date, Store and Associate. The table currently has about 91 million rows and takes up about 12 Gig of disk space. Here are my questions: 1...

Hi, We have been running VB 6 DLL's in COM+ on Windows 2000 for a couple of years now but have recently run into a problem with a single DLL. When instantiated from a website using Windows 2000 IIS 5.0, the component works perfectly in COM+. We have an executable vb6 program that we run on...

Hi, We are trying to improve performance with COM+ components we are currently using. I've read that you should always close ADODB recordsets prior to setting them to nothing. We currently use ADOMD.Cellset's to connect to SQL Server Analysis Services. What we are trying to determine is if...

Hi, We are currently running VB 6.0 components that do not require transactions because there are no database updates being performed, or only a single update is being performed. My question is this: Is there any additional overhead in COM+ if the MTSTransactionMode is set to...

Has anyone tried calling a SQL Server 2000 User Defined Function (UDF) using the ADO object model? I would like to execute this function from within a VB6 application passing a couple of parameters and returning a char(1) value. I have tried researching this through MSDN but had no success. I...

I ran into a situation this morning that I didn't know was possible. I executed a stored procedure which contained cursor processing. During the process, I trapped for a situation and exited the stored procedure without closing and deallocating the cursor. When I called the stored procedure...

I am trying to execute a DTSRUN command from SQL Server Agent for a user that does not have sysadmin rights. Here is the message I receive when I view the job history for this job: "Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed." I've heard that...

I have a DTS package created in SQL 2000 that has a Execute SQL Task which in turn calls a Stored Procedure. In the Stored Procedure, I'm trying to delete a record from a table that could have foreign keys constraints if the employee has transactional history. I am trapping the error in the...

We are trying to determine what is the best way to open a connection for an ADOMD.Cellset. I have seen sample code that uses ADODB.Connection on several occasions. We are using SQL Server 2000 Analysis Services with Visual Basic 6.0 DLL's in COM+. We currently use the ADOMD.Catalog class which...

I am currently calling a DTS package from within another DTS package using the Execute Package Task. I also have "On Success" and "On Failure" workflows attached to this step. If the (child) package errors out, the parent package shows an "X" on that step noting the failure, but follows the...

I am trying to give individual users the ability to execute SQL Agent jobs from within Enterprise Manger without granting them Sysadmin rights. I thought processadmin would do the trick but it doesn't. Does anyone have another resolution to this problem. Thanks in advance!

Has anyone found a proper way to set a declared variable in an "Execute SQL Task" to an incoming Global Variable parameter? If I use the following script: Declare @var1 as varchar(10) SET @var1 = ? I get a "Syntax error or access violation" error when trying to open the parameters window. If...

Does anyone know how to retrieve the index information (clustered and non-clustered) for a table using INFORMATION_SCHEMA? I know that Microsoft wants you to stay away from system tables such as sysindexes but I cannot determine how to retrieve this information through the schemas.