Viewing 15 posts - 1 through 15 (of 33 total)
On your link provided it is stating something different.
http://msdn.microsoft.com/en-us/library/hh479588.aspx
The objects that are stored in the SSISDB catalog include projects, packages, parameters, environments, and operational history.
June 4, 2012 at 12:48 am
The default group is alterable but it cannot be moved out of the default pool.
Straight from BOL.
Please can I have my point now!!!
Let see how many responses we have before...
October 20, 2011 at 1:00 am
Like all the others I knew what the question was trying to demonstrate but the answer was incorrect as second select statement returns 1 and not 2. Should really test...
September 14, 2011 at 1:00 am
Answer and explanation do not match up come QOTD get it sorted.
June 29, 2011 at 3:11 am
Question and answer don't match up, I answered 4 based on the question to only find out that I was wrong but sure that I was right. Entering the forum...
April 8, 2011 at 1:09 am
Sorry but the answer to the question you have provided is wrong, or you are confusing the question
BOL has the following,
The first index created on a view must be a...
March 30, 2011 at 12:25 am
First thing first why is your log at 137GB?
What is the size of the DB?
If you have no need for a point in time recovery look at resetting the DB...
February 25, 2011 at 1:36 am
Looking at the error message I have picked out the following
The account name is invalid or does not exist, or the password is invalid for the account name specified.
Check...
February 11, 2011 at 6:37 am
It really depends why you want to clone the instance. I was working on a implementation of a new system and when I stated we would require a non-prod system...
January 20, 2011 at 5:09 am
Not sure if you were able to resolve the issue but I got the same error and it turned out to be a issue with the Linked server and what...
December 23, 2010 at 2:52 am
Northwind is normally associated with SQL Server 2000 and below. For sys.syscomments only came around in SQL Server 2005 and above where Northwind no longer was provided. Based on the...
December 2, 2010 at 3:56 am
Good question learned something new today.
November 4, 2010 at 2:16 am
Another Good question, one which I needed to read up about as we do not use the Service Broker where I work.
October 26, 2010 at 12:33 am
Very good question and made me aware of a option that I was not aware of.
October 25, 2010 at 12:23 am
The misspelling is
TRUNCATE TABLE CustomerMast
The table is called CustomerMaster there is no reference to the table you are looking for in the SQL. This was yet again a misspelling...
October 21, 2010 at 5:51 am
Viewing 15 posts - 1 through 15 (of 33 total)