Hi krypto69,

I understand your query, it appears that you are handling medical claims and claim lines with procedure codes. I have worked extensively in these type of tables,

and I know...

Hi xxjhxx2

I recommend that you check first whether the client's data is already isolated in its own tables or partitions. That would be lovely if they do, If so, SWITCH...

• This reply was modified 3 hours, 48 minutes ago by Portes Ysaias.

Instead of ADODB, you should try to use OLEDB Provider which supports a new feature if your database is SQL 2005 or above called "MARS", Multiple Active Resultsets.

With MARS you...

If you are using an SQLDatareader Class to read the data, you need must pass either the name of the column or the column order index.

DECLARE @result VARCHAR(50)

SET @result...

Hi bhavika,

First your T-SQL statement is wrong and your question does not explain exactly what you want to accomplish.

Please elaborate a little more so we can understand your need and...

You can use DBCC SHOWCONTIG

Here is the script that we use, it was developed by Microsoft and you can find it here

http://msdn.microsoft.com/en-us/library/ms175008.aspx

T-SQL:

/*Perform a 'USE <database name>' to select the database...

Look into this folder:

C:\Program Files\Microsoft SQL Server\MSRS10_50.SSRSBI\Reporting Services\LogFiles

MSRS10_50.SSRSBI = The name of your SSRS instance Name

Just Stop the [Windows Time] Service so it stops synchronizing with your Domain Controller.

You DO NOT need to disjoin your server from your Domain.

Once you are done testing, Start the...

Use this SQL 2005+ query:

SELECT OBJECT_NAME(object_id) AS TableName ,

name AS ColumnName ,

TYPE_NAME(system_type_id) AS...

If the files are not corrupted, then yes you may attach them to another SQL instance.

The reason why the OS says they are in used is because you have SQL...

Create a separate table in SQL that stores the names of the files processed.

create table LoadedFiles(fID int identity not null, fileName varchar(25) not null,

loadDate datetime not null default getdate(), fileCreateDate...

Thanks for your input, but "SC.EXE" does not query instances, it queries Servers and enumerates all its services.

My Script lists all the services installed on a particular computer or server...

You must make the package entirely Dynamic, meaning that every possible changeable configuration must be stored either in variables or in an SSIS XML or SQL Configuration.

Then you can either...

This will work just perfectly for you.

I have tested it in 2008 and 2005.

-- To allow advanced options to be changed.

EXEC sp_configure 'show advanced options', 1

GO

-- To update the currently...

On SQL 2008 they are stored here:

C:\Program Files\Microsoft SQL Server\100\DTS\Packages "If you installed it on C:\"

Check your Integration Services Service Path to get to the package path.