I'll give it a try

Hi,

Works just fine from a different machine.

Hi there,

Windows 7, SQL Server 2008 standard (10.0.5500)

I have tried a repair, various registry tweaks, checked the memory, complete uninstall and reinstall. Trying to avoid rebuilding the PC if...

Looks like it was an error in the stored proc that processed the restore.

Thanks for the help.

Hello, I am jsut checking the backup process to ensure it is all working as expected.

Frustratingly, having had this problem for the last few days, I have just run the process again and all the indexes exist.

Hello, thank you for the responses. I have edited the original posting as requested.

This process is contained in a stored procedure, it is used to copy selected production databases...

Very nice, but I think this is a bit quicker

SELECT *

FROM OPENROWSET('SQLOLEDB', 'server=[Your Server Name];trusted_connection=yes',

'set fmtonly off exec xp_readerrorlog') a

Where ([Text] Like '%Fatal error%'

OR [Text] Like '%Query...

Thanks for the reply,

I have tried reinistialising the subscriptions etc, this is failing. It appears that the agents are attemping to connect to the now dead server.

Hi,

The statement

SELECT SUBSTRING(Name,40,100) AS Files

FROM #DBAZ

Does not seem to work for me, but

SELECT ltrim(rtrim(reverse(SUBSTRING(reverse(Name), 1,charindex(char(32),reverse(Name))-1)))) AS Files

FROM #DBAZ

Does the trick

You could try =format(now(), "dd MMM yyyy")

I've done some more digging, it seems that even if opening a stored proc using "Modify", then closing, if repeated 100+ times, same result. If this is indeed a...

Sorry, I'm a bit old school, should be management studio, I refer to QA on the grounds that it looks, walks and quacks like a duck!

Why 100 connections, a developer...

Manju

Thanks for the code snippet, but as Jeff Moden stated "there's a whole bunch of places where "AS" can be used in a stored procedure ", for example in a...

Many thanks for the suggestions, still working on a solution, will let you know how it goes.