Hi,

Thanks for the verification...I hadn't explicitly looked for confirmation on the above...once I got the error and after googling I had seen some 'methods' that were reported to have worked...

Job History Error Message

Message

Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:19:36...

Whoops...sorry about that...will make a mental note in the future.

As for your comments about the internal snapshot, I have read through Paul's blog and do have an general understanding of...

Hi David,

I had figured as much...based on previous conversations with my co-workers...and I did see Paul's Blog (I visit it frequently)...

I will read up on that link you posted and...

Maybe someone has some info on what a transient database snapshot is and how it is either viewed, created, or deleted...

I cannot find any information regarding what a 'transient' db...

in the past we have migrated servers like this "the whole server" from physical to virtual.

We have had to do the following

Have a current production server (call it DBServer1)

Create new...

In our current process / product when you restore a database to the same server or another server you are prompted with a source and destination server, I haven't seen...

The hardware we have running our SAP implementation far surpasses anything else on our legacy systems so to try to compare wouldn't be fair.

I can tell you that we can...

For our SAP environment we are utilizing CommVault 8 with the SQL idata agent installed on the SQL machine.

The systems (SQL servers) are all running 2008 enterprise.

The CommVault 'system' is...

Jeffrey Williams-493691 (12/29/2009)

---

In the following article: http://msdn.microsoft.com/en-us/library/ms188783(SQL.90).aspx under the heading 'Required SET Options for Indexed Views' it clearly shows what values need to be defined when creating an indexed view.

There...

Thank you for the reply. I did see that kb article through my previous searches on my above issue...and I guess I was looking for a definitive answer regarding...

I am not sure if your problem was the EXACT same as mine...but I will describe my issue and eventual solution...

I wasn't able to use SSMS on my laptop to...

Here is one that I wrote after not finding what I was looking for online...

The following script has the code for the table creates, view creates, two stored procedures and...

The error message is as I stated in the title...the description is

[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

The...

are you sure about that?

Unless I am misunderstanding your post I think...