Viewing 15 posts - 781 through 795 (of 1,138 total)
ramyours2003 (9/11/2009)
one of th ejob failed due to unable to connect sql server , can u calrify any one of how to resolve the issue ?
Can you give me...
September 11, 2009 at 8:57 am
Ian Scarlett (9/11/2009)
Trooper (9/11/2009)
So will I not be able to restored the transactional...
September 11, 2009 at 8:52 am
Swirl80 (9/11/2009)
i've posted a link to another post on another forum instead re-itterating the text...http://www.red-gate.com/MessageBoard/viewtopic.php?p=34568#34568
Any ideas?
ta
MSQL_XP is the wait type that occurs when a task is executing an extended stored...
September 11, 2009 at 8:43 am
There is a trace flag you can use, so you can backup to network. But it not good practise and you will enounter continual I/O and potential data loss issues....
September 11, 2009 at 8:35 am
Ian Scarlett (9/11/2009)
September 11, 2009 at 8:23 am
Trooper (9/11/2009)
I have a job that does the index rebuild on one of our prod databases and once the job has completed I see a failure on transactional log backups...
September 11, 2009 at 8:16 am
Stuart Davies (9/11/2009)
If
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE
allows use of xp_cmdshell
does
EXEC master.dbo.sp_configure 'show advanced options',...
September 11, 2009 at 8:03 am
mjarsaniya (9/11/2009)
sorry.......I have mistake.actually i have two servers one have 8 GB and another one at 16 GB RAM.
so,please forgot...
You can take Paul suggestion, which is a good one, for...
September 11, 2009 at 7:55 am
Mel Harbour (9/9/2009)
The syncing from...
September 11, 2009 at 5:58 am
Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says exactly the same as what...
September 11, 2009 at 5:09 am
Paul White (9/11/2009)
SELECT client_net_address
FROM sys.dm_exec_connections
WHERE session_id = @@SPID
AND net_transport = N'TCP'
nice, but only works for spids that are still active....
September 11, 2009 at 4:59 am
Paul White (9/11/2009)
Silverfox (9/11/2009)
...any new MVP's are always welcome.
So long as they have at least the first clue 😛
BTW that bloody pigeon story made it on to the local radio[/url]...
September 11, 2009 at 4:49 am
mjarsaniya (9/11/2009)
September 11, 2009 at 4:38 am
Paul White (9/11/2009)
Not everyone has immediate access to BOL locally, and...
September 11, 2009 at 4:34 am
Viewing 15 posts - 781 through 795 (of 1,138 total)