Viewing 15 posts - 421 through 435 (of 644 total)
PaulB-TheOneAndOnly (2/6/2012)
5 Gig database?Nighly?
The answer is: Full Backup and Restore.
As Paul said, write a stored procedure that will restore the database on reporting server by using production database backup. Scheduled...
February 6, 2012 at 7:10 am
Pin drop silence here from past 2 days !!! What happened ? Does Brandie's last post has something to do with it ?? :hehe: 😛
February 6, 2012 at 6:51 am
Duplicated the above post.
February 3, 2012 at 8:45 am
Pam Brisjar (2/3/2012)
rather than "E:\SQL_Data\db_file.mdf"?
I have three DB's out of 32 on my acceptance server with this oddity. All the files...
February 3, 2012 at 8:44 am
Subrata Bauri (2/1/2012)
<address>your mobile numbers</address>this will repeat on basis of how many Mobile number found.
With a little tweak in the above code you can achieve that. I can do that...
February 1, 2012 at 3:10 am
george sibbald (1/31/2012)
I think I should clarify what I mean by quiesced - make sure nothing or no-one else is trying to connect to the instance whilst you...
January 31, 2012 at 6:07 am
george sibbald (1/31/2012)
when I have had patching errors where the resource database has 'gone missing' it has been...
January 31, 2012 at 5:59 am
M.Kahn (1/31/2012)
You can installed SP with 3 or 30 instances, when you going to update with SP, it will ask you - which instances u want to update.
Before you start...
January 31, 2012 at 5:17 am
crazy4sql (1/31/2012)
I wanted to know that did you too faced the same error (i.e. upgrade process didn't update the MSSQLSystemResource files on some instance & you were not able to...
January 31, 2012 at 4:39 am
duggal.priyanka06 (1/31/2012)
Can you point me to some documents where I can know about execution plan and how query is actually executed.
Get the book SQL Server Internals for SQL Server 2008...
January 31, 2012 at 4:31 am
deepikamm (1/31/2012)
after seeing sp_executesql in sqlservercentral homepage,I started searching about it.
Seeing !!!? Didn't you read the article?
David shows the use of SP_ExecuteSQL when he executes this code in his article:
USE...
January 31, 2012 at 4:16 am
deepikamm (1/31/2012)
To be more precise,I am expecting blogs or articles on these topics.(plz don't direct me to microsoft blogs:w00t:)
Every msdn article has provided well written examples also so they are...
January 31, 2012 at 3:59 am
deepikamm (1/31/2012)
Thank you all for quick response.I am expecting layman explanation on these topics and I am tired of reading msdn.
I think we have provided the layman definition. If you...
January 31, 2012 at 3:54 am
deepikamm (1/31/2012)
EXEC
sp_executesql
dynamic sql
exec vs sp_executesql
I am not sure whether i can ask all the questions in a single thread.I am sorry if i have breached the posting...
January 31, 2012 at 3:44 am
I think you need something like this:
DECLARE @XMLStartTag VARCHAR(1000)
DECLARE @XMLBody VARCHAR(MAX)
DECLARE @XMLEndTag VARCHAR(1000)
DECLARE @CompleteXML VARCHAR(MAX)
SET @XMLBody = ''
SELECT @XMLStartTag = '<?xml version=”1.0” ?><BSMS version=1.0><request userid="yourUserId" password="yourPassword" pin="yourPin" type="push">'
SELECT...
January 31, 2012 at 3:28 am
Viewing 15 posts - 421 through 435 (of 644 total)