TheSQLGuru (7/22/2013)

---

For me the biggest limitation in Standard Edition is the RIDICULOUSLY LOW maximum memory. Fortunately you can supplant that with SSD storage to some degree, although I will...

Using your script, your backup went to folder E:\ and is in file "Report"

I think that what you want is something like:

use master

backup database bharti_test

to disk=N'E:\Reports\bharti_test.bak'

with copy_only;

Worse still, many developers have their queries return data in a particular order without specifying "ORDER BY" and then get upset when told that SQL Server does not guarantee the...

In a single instance of reporting services, there is one and only one ReportServer database and one ReportServerTempDB database.

The reports definitions are stored in the ReportServer database.

The data...

Where did you install the Oracle client software ? For it to used as a linked server, it will need to be installed onto the Windows server that you...

A single SQL Server instance can be used for multiple reporting services instances. The reporting services database (ReportServer, ReportServerTEMPDB) will include the reporting services instance name.

e.g. I have a reporting...

1. Backing up files that are in use is not an option. SQL Server caches data and that may mean that, even though your queries are showing a record,...

Instead of generating a snapshot, you could use a database backup. You can initialise a subscription using a backup instead of a snapshot.

If you need to have the replicas...

Firstly, yes Express can be the witness (see http://msdn.microsoft.com/en-us/library/cc645993.aspx)

This may be a configuration issue with the Express instance. Not sure whether this is the correct suggestion, but -...

Have you tried putting your code in a stored procedure and using the "EXECUTE AS" option in that stored procedure so that it executes as a user who is permitted...

premkuttan (6/14/2013)

---

I had given db owner , targetserverrole access to MSDB database so he is able to view the jobs when he tries to connect from enterprise manager(sql 2000...

I used http://underthefold.org/2011/06/13/exam-70-448-study-guide-part-1/ as my primary study reference. This (and the other 5 pages that are part of this study guide) have links to topics in various places...

Let me start by saying that I have read up on this but haven't actually implemented SSIS on a cluster.

SSIS is not a cluster aware service and MS do not...

awesome - congratulations

I used the info etc from the website as the basis for my study. A lot of the links also have other related references and I also went to...