If you have to do this a lot - and it sounds like it, I would recommend you take a look at Melissa Data for this task. It will...

Changed how? Are the permissions disappearing - or are they different from what you originally set?

This article might help: http://support.microsoft.com/kb/19388

Also, you could try modifying the Recovery values for the service. Set the Restart Service for the First Failure and set the value to 2...

If you have enterprise edition, you could setup database mirroring and create a database snapshot from the mirrored database.

Or, you could setup replication and only replicate the tables you need...

Verify the version of the client tools - if they are not at SP2 or greater, the reports won't show up. Also, make sure you are connecting to an...

lmu92 (5/25/2010)

---

But...

wouldn't it be nice to have a SQL Server setting (like IDENTITY_INSERT), something like STRING_TRUNC with ON as a default (truncate strings, like it currently does...)? That would allow...

This is actually a rather simple issue to fix - but not intuitive. For the failure notify operator task, you probably have solid red lines connecting from each of...

As far as I know, this cannot be overwritten. The numbering is not just for the database engine, it also is defined for SSRS/SSAS and other components.

The value is...

You have to remove them from the db_datareader role which grants read access to all objects (tables and views). Then, you have to explicitly grant read access to each...

You can run the following to identify when the statistics were last updated:

SELECT *, stats_date(object_id, stats_id) FROM sys.stats;

To find out the sampling rate for the statistics, you can run the...

Yes, you are looking for trouble - especially if this is a production system. You really need to add storage to the system or figure out what can be...

Once you have SSRS installed, you can report from any ODBC/OLEDB source system. For example, I have reports where the source data is on Intersystems Cache and I have...

Okay - so, have you verified that the lock pages in memory policy has been set for the service account running SQL Server? If that is not set, AWE...

Sorry, but this isn't clear - are you running x64 or x86 versions of the OS and SQL Server?

Run the following in a query window on both servers: SELECT @@VERSION

If...

mike 57299 (5/21/2010)

---

Lamprey13 (5/21/2010)

---

I'm not sure if that is possible. But, even if it is possible, that sounds like a really bad idea.

Have you investigated using a "listener" app that...