Viewing 15 posts - 1 through 15 (of 60 total)
I'll give it a try
October 4, 2013 at 6:50 am
Works just fine from a different machine.
October 4, 2013 at 4:33 am
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...
October 4, 2013 at 4:03 am
Looks like it was an error in the stored proc that processed the restore.
Thanks for the help.
September 25, 2013 at 9:18 am
Hello, I am jsut checking the backup process to ensure it is all working as expected.
September 25, 2013 at 5:08 am
Frustratingly, having had this problem for the last few days, I have just run the process again and all the indexes exist.
September 25, 2013 at 3:44 am
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...
September 25, 2013 at 3:39 am
Very nice, but I think this is a bit quicker
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...
July 7, 2011 at 1:57 am
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.
May 12, 2011 at 2:56 am
SELECT SUBSTRING(Name,40,100) AS Files
Does not seem to work for me, but
SELECT ltrim(rtrim(reverse(SUBSTRING(reverse(Name), 1,charindex(char(32),reverse(Name))-1)))) AS Files
Does the trick
September 15, 2010 at 2:34 am
You could try =format(now(), "dd MMM yyyy")
September 13, 2010 at 10:07 am
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...
March 25, 2010 at 7:31 am
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...
March 25, 2010 at 4:17 am
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...
February 2, 2010 at 7:52 am
Many thanks for the suggestions, still working on a solution, will let you know how it goes.
February 1, 2010 at 4:04 am