Viewing 15 posts - 286 through 300 (of 1,583 total)
Is there a transaction log backup or differential backup running hourly? Perhaps there is also be some IT-related process outside the server that's running on a schedule...
What jobs run...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 21, 2014 at 9:36 am
I think your reply is solid. "In theory they are not..." Sounds like a response from someone who has "read" a lot but is lacking experience in "doing" a...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 21, 2014 at 9:32 am
I have to ask "why" you would want to do this?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 20, 2014 at 7:55 pm
If you haven't done so already, Install Office 2007 Data Connectivity Components (http://www.microsoft.com/download/en/confirmation.aspx?id=23734) for the 64-bit
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 20, 2014 at 12:04 pm
There are many ways to do this, you could use a CTE and UNION ALL the counts between the different ACTL_PROC_CD codes. Also, assuming your SQL Server isn't case...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 20, 2014 at 9:33 am
Did you try the free software I recommended? It's does what you are asking...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 20, 2014 at 8:53 am
That was my thought Jeff 😉 But without knowing "why" or "how" it got that way...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2014 at 8:43 pm
What is the server 64/32 bit?
In either case, make sure the version matches the office install
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2014 at 11:51 am
BTW, DBA swears up and down they didn't alter the proc, just ran sp_recompile (they did alter the proc later, so I can't look at a modify date on the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2014 at 11:37 am
You can do this via TSQL or download the Idera SQL Permissions Extractor (makes it a lot easier)
You can get a decent TSQL script here:
http://stackoverflow.com/questions/5983676/t-sql-copy-logins-users-roles-permissions-etc
http://support.microsoft.com/kb/918992
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2014 at 11:26 am
I'm not sure where you got your "drill" information, but in my opinion that'd be the minimum. Ideally, ask the question "how much data am I willing to lose?"...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2014 at 11:05 am
IMHO, knowledge is good, but experience is better (and most often trumps it) - things from articles/books/etc can be learned, but I believe applied learning from an actual experiences is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2014 at 8:26 am
rajemessage 14195 (3/19/2014)
but following is quite complicated SP, which i can not change now.
So...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 19, 2014 at 8:22 am
No I don't think you can tell SSIS how to do this - but if I understand you correctly (you want to throttle the SSIS to do its thing, without...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 3:56 pm
Good catch. Are you certain you uploaded the exact copy of the working code in Production? As a test, open up the RDL file XML, add the missing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2014 at 9:57 am
Viewing 15 posts - 286 through 300 (of 1,583 total)