Yes - this is possible on a single PC. The trick is that you need to set the primary DNS suffix for your PC for mirroring to work.

Normally, your...

I suggest that you have a look at the syntax for "CREATE LOGIN" - it has some info in SID

SID is short for security identifier (or at least that...

You will need to create the login and grant it permissions in the database before you create the snapshot. The "content" of the snapshot never changes, so if the...

I used this http://underthefold.org/2011/06/13/exam-70-448-study-guide-part-1/ (along with parts 2, 3, 4, 5 and 6) to prepare for this exam. These web pages have a list of relevant references that cover...

You can definitely do what you are wanting to do.

A single report services instances can be used to run reports that access databases on pretty much any server you want...

This sounds like you want to make the value(s) available in param 5 and 6 dependent on the values selected in param 4 - is this correct ?

i.e. if you...

Using the IIF statement should work for you. The expression for BackgroundColor is the one to use. A value something like the following should work

=IIF(Fields!Year.Value = Year(Now()), "Green",...

When you read data from Excel using SSIS, the OLEDB provider reads the first few rows of the worksheet and tries to guess what the data type is for each...

What you are describing is "Data Driven Subscriptions" which is available with Enterprise Edition.

mohammed moinudheen (4/14/2013)

---

happycat59 (4/14/2013)

---

You could try using "sp_addsubscription" and specifying the name of the article that contains the new table. Follow that with running the snapshot agent for the...

You could try using "sp_addsubscription" and specifying the name of the article that contains the new table. Follow that with running the snapshot agent for the publication and the...

Assuming that the values for the "Regions" parameter come from a dataset, you can use the count function to get the number of records that are in the dataset and...

Use a foreach loop container. This can be used to iterate through files in a folder. In each iteration of the loop, the foreach loop container will assign...

First things first - "uniqueidentifier" is a data type. A column in a table may contain the same value for each and every row in the table (e.g. it...

I think that the ADO.Net provider does an implicit conversion from varchar to nvarchar. If you need to use the ADO.net provider then you will need to convert the...