Forum Replies Created

Viewing 15 posts - 496 through 510 (of 2,612 total)

  • RE: how t orun JOB continuosly

    You should look up "Service Broker" in books online.

  • RE: SSIS Data Transfer Rate Question

    It is probably Access having trouble feeding up the records. Did you use an OLEDB source and select the table, or did you specify a query? Did you...

  • RE: using MAX function

    You will only get that message if there are NULL values. Empty strings in a character field will not give you that message.

    It can be from the date column...

  • RE: Linking tables

    The closest thing to a linked table in SQL is a Synonym. You should look these up. However, I would suggest you do not have 4 different databases...

  • RE: Intermittant error on SP2 jobs

    I assume the packages are stored in MSDB on your server - have you run a checkdb on MSDB? The error looks like it is indicating a problem getting...

  • RE: Which one is better CTE or using Subquery in the from clause?

    If the CTE and the sub-query are the same, they will get the same execution plan and have the same performance. There is no special performance benefit to a...

  • RE: Transactions in SSIS

    On the package properties, set the transaction level to required.

    Unless you have changed the transaction level of any of the components you have added, they will all have defaulted to...

  • RE: MDX error: The 'Fiscal' hierarchy appears more than once in the tuple

    enclose it in a set:

    ({[Time].[Fiscal].[FYTD], [Time].[Fiscal].[Fiscal Year].&[2009]}) ON COLUMNS,

  • RE: VB6 ADO SQL2005 StoredProcedure adDecimal

    Welcome to the forums - and to the 21st century. What's up with using VB6? Perhaps a programming language from this decade would be a better choice.

    First, you...

  • RE: Cluster

    Correct.

    Think of it as two completely independant clusters. At least one of them must be a named instance (because your passive server cannot have two default instances) and they...

  • RE: Cluster

    SQL Server Active/Active and Active/Active/Passive clustering is somewhat mislabeled.

    SQL Clustering is not a load balancing solution. In an Active/Active cluster, you actually set up two named instances on both...

  • RE: Package Fails, but returns Success Code???

    Components have a fail package on failure property. Make sure these are true. Also, by your post it sounds like you may have a task in your event...

  • RE: Is it possible to downgrade databases from 2008 EE to 2000 EE?

    "It sounds like there's no good way to evaluate SQL 2008 in a production environment with the hopes of going back to SQL 2000."

    That's not a great approach to testing...

  • RE: Replication on triggers and constraints

    On each article you have selected (each table) you have a number of different options. In these options, you can choose to include indexes, constraints, and triggers that are...

  • RE: Graphs in SQL 2005

    If you right-click on a database (or pretty much anything in object explorer) you can select from a number of built-in reports.

    Some of them have some charts and graphs.

    You can...

Viewing 15 posts - 496 through 510 (of 2,612 total)