Let me ask you one question. What I can see from your result that, once you get 'Trl' from Substring([Column 0], 4, 3), every thing else below that will be...

You can try deny CONTROL permission on the database or VIEW DEFINITION permission to role.

not sure, whether will work with db_owner or not.

Lowell, he has mentioned in first post that The primary key combination for the destination table is "ROBumber + ROTime" .

I was able to replicate exact same issue in my environment if the CTE name & name of table is same, so I do not see any reason that it...

So, if already exists, it will not return anything from the second sql. Because you are checking for not exists?

I thought that you want the path for Master DB only...

Do you already have Database named Test_Restore?

You are doing it right. What issue you are facing?

Instaed of if exists use "If NOT EXISTS"

Check for DB from sys. sysdatabases then get path from sys.master_files.

I would recommend to read through this. As Jeff & Oliiii said there may be numerous factors which maybe affecting it.

http://www.brentozar.com/sql/virtualization-best-practices/

I think it may be stuck on a certain dependency on something external to SQL Server or it may be a bug.

Check this out.

http://connect.microsoft.com/SQLServer/feedback/details/696484/unable-to-disable-server-audit-on-sql-server-2008-r2-sp1

Look at he Memory Manager. First Section.

VM Reserved

VM Committed

Have you given the ‘Lock pages in memory’ right to the account used by the SQL Server instance?

Also the task manager is not a right place to look for how...

You can also get that info from default trace file which SQL server maintains.

Open .trc file from your ...\MSSQL\LOG folder and search for the stored procedure which you are looking...

Have you tried it?

What version of SQL Server you are in?

It is a known issue SQL Server 2005 SP2. There is a ptch out to fix this issue.

But if you are in...

So could you be more specific? 2 servers- DO they have same databases/ different databases?

Which DB you are using to to create snapshot & where?

Have to tried replication instead of...