Viewing 15 posts - 496 through 510 (of 2,612 total)
You should look up "Service Broker" in books online.
October 21, 2008 at 6:03 am
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...
October 20, 2008 at 8:59 am
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...
October 20, 2008 at 7:37 am
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...
October 20, 2008 at 7:33 am
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...
October 20, 2008 at 5:00 am
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...
October 20, 2008 at 4:52 am
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...
October 20, 2008 at 4:48 am
enclose it in a set:
({[Time].[Fiscal].[FYTD], [Time].[Fiscal].[Fiscal Year].&[2009]}) ON COLUMNS,
October 16, 2008 at 11:49 am
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...
October 16, 2008 at 11:20 am
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...
October 16, 2008 at 7:41 am
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...
October 16, 2008 at 7:03 am
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...
October 15, 2008 at 7:49 am
"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...
October 15, 2008 at 7:35 am
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...
October 15, 2008 at 7:28 am
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...
October 14, 2008 at 12:48 pm
Viewing 15 posts - 496 through 510 (of 2,612 total)