Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,222 total)

  • RE: Log shipping 2

    I don't know what this error means either but I suspect that it is being caused because you are trying to use UNC names for the folders but do not...

  • RE: Creating a View with tables only.

    You could do something like

    Create View Clint AS

    SELECT CONVERT (CHAR(25), Null) AS Name ,

    CONVERT (INT, 0) AS Age

    WHERE...

  • RE: Checkpoint frequency: is it possible to configure at database level?

    First - is the migration of data occurring in a single database transaction or multiple ? If it is a single transaction then you should expect that your log...

  • RE: Upgrading SQL Server 6.5 database to SQL Server 2005

    I haven't migrated from SQL 6.5 to SQL 2000 or SQL 2005 but I have done it to SQL 7.

    A little background first...the physical structures used by SQL...

  • RE: configure the new box for reporting services?

    You can choose which server you wish to use for the ReportServer and ReportServerTempdb databases.

    You do not need to install SQL Server (database engine) on your 4th server...

  • RE: Multiple Excel files into a single table

    The "ForEach Loop" container is what you need to loop through the list of files. When you use this, the container gives you a variable which is the name...

  • RE: To check the consistency of the replicated tables

    This is out of the box functionality of replication. Replication will validate record counts and/or checksums of articles in a publication.

    Have a look at article "How to: Validate Data...

  • RE: SSIS

    The easiest way to do copy an existing package is to open the project that contains the package, copy the current package (using CTRL + C), click on the "SSIS...

  • RE: Cube generation failure

    You need to make your that the client components of Analysis Services are installed on the project server side of things.

  • RE: Is it possible to create 2005 SSIS Packages on a SQL 2000 Database?

    Jack is correct - there is no problems with a SSIS package being developed on your SQL 2005 server and run from that server but accessing (for reading or writing)...

  • RE: Corrupted SysIndexes

    I assume that by now you have tried fixing using DBCC without any useful result.

    If you have been able to determine which row is the problem, you should...

  • RE: How to schedule a package in SSIS?

    Any scheduling product that can run DTEXEC can be used to schedule a SSIS package. By far, the easiest is SQL Server Agent which knows a lot about SSIS...

  • RE: execute permission

    A user is normally allowed to start jobs that the user owns. This is the simplest option although it may not be an option if more than one non-admin...

  • RE: Passing Parameters

    You can use a dataset as the source for parameters. First create the dataset (e.g. SELECT ID, Label from yourtable) and then go to the report parameters and change...

  • RE: Can't connect to datasource in SSRS 2005

    When you reset the encryption key, you should have received a warning that encrypted data would be deleted. This means that you will have lost part of connection string...

Viewing 15 posts - 856 through 870 (of 1,222 total)