Viewing 15 posts - 4,816 through 4,830 (of 6,395 total)
Out of interest, why do you want to increament journal values, typically when a journal is saved it shouldnt be modified (well thats how finance systems I've worked with in...
May 31, 2012 at 2:21 am
does the account running the SSRS service have access to the SSRS Databases?
May 31, 2012 at 2:13 am
What authentication types do you have in the RSReportServer.config file under the <Authentication> xml node?
May 31, 2012 at 2:09 am
By default the only accounts permitted to connect to a fresh instance of SSRS is anyone in the administrators group of the server where SSRS is installed.
Does the account you...
May 31, 2012 at 1:56 am
I have to say I'm enjoying Crabbies alcoholic ginger beer at the moment, but my best thing to drink of late is Hoegaarden Rose
May 31, 2012 at 1:32 am
If you backup 2005 and restore over the 2008 RS DB's you will loose your 2008 reports so you wont want to do that.
Options you have are
use a tool...
May 31, 2012 at 1:25 am
duplicate post, replies here http://www.sqlservercentral.com/Forums/Topic1308723-150-1.aspx
May 31, 2012 at 1:17 am
It will stay in recovery until it has rolled back, rolled forward what it needs to do. Now depending how big the transactions and how long the transactions where...
May 31, 2012 at 1:11 am
BrainDonor (5/30/2012)
If your Log-Shipping is for Disaster Recovery then what happens if your 2005...
May 31, 2012 at 1:03 am
All three of the answers to them can be found on google.
Copy your questions, place them into google and you will get the answer. I have just...
May 30, 2012 at 5:51 am
you will need to build it into a variable then pass in that variable
declare @attach nvarchar(max)
set @attach = 'C:\fjnrfrgrjnjnfg'+CONVERT(NVARCHAR,GETDATE(),112)+'.xls'
sp_send_dbmail ......, @file_attachments = @attach
May 30, 2012 at 5:08 am
I take it the number of tasks and weeks can change?
If so your looking at a dynamic cross tab solution, there are 2 links in my signature by Jeff on...
May 30, 2012 at 4:43 am
You can do mirroring in Standard edition, just not Async mirroring. Standard edition mirroring is Single Threaded Syncronous
You can restore Alpha from ServerA to AlphaDML on ServerB the database...
May 30, 2012 at 4:21 am
Your using coding language as DT-WSTR is a SSIS data type not a T-SQL data type which is what sp_send_dbmail is expecting.
You need to look at something which is in...
May 30, 2012 at 4:10 am
1 - Can you not change the name of the alpha database you do your DML on to something different, eg AlphaDML and then you can logship as normal with...
May 30, 2012 at 4:04 am
Viewing 15 posts - 4,816 through 4,830 (of 6,395 total)