Viewing 15 posts - 16 through 30 (of 117 total)
We use CLRs (have for some times) with custom C# code. Previously, it ran on all of our customer-facing SQL servers (non-SSRS report servers), now only one server uses it...
February 21, 2014 at 7:14 am
You could write a script to BCP out the data?
Here is something I run to generate data from a table to convert it into a SELECT statement:
USE MyDatabase
Go
DECLARE...
August 28, 2013 at 6:14 am
I know this is an older post, but we just ran into a similar problem and "googling" the issue, this was only one of two responses that came up.
We...
April 3, 2013 at 1:09 pm
I totally agree about blindly accepting missing index recommendations! 🙂
We run a process weekly that checks the server uptime (3 days or greater is our criteria), then capture all of...
March 14, 2013 at 1:02 pm
Sorry for any confusion... I believe there are a few levels of "ownership" (http://qa.sqlservercentral.com/articles/SQL+Jobs/68764/) per my understanding?
1) The account that is configured to run SQL Server Agent...
February 11, 2013 at 11:59 am
Not what you may want to hear, but have you may have to convert the process (temporarily) to use a different methodology, if it is that important?
- Are you...
February 11, 2013 at 8:29 am
Nope. No proxies.
The job is actually run with a custom higher level account with full permissions in every database. Yes, it has full SA permissions... again, please no discussions...
February 11, 2013 at 7:54 am
Sorry for taking so long to response back on this... I know I personally do not like it when a thread suddenly "quits" without any resolution, especially when I am...
February 11, 2013 at 7:32 am
Did you check to see if Network Service has permissions in the new instance?
USE Master
GO
select left(name,25) name, type, type_desc
from sys.server_principals AS log
WHERE (log.type in ('U', 'G',...
February 4, 2013 at 9:48 am
Ok... I was finally able to jump back on this problem and get it resolved:
1) Did a full backup this AM.
2) Detached the database.
3) Renamed the LDF...
January 7, 2013 at 1:54 pm
Gail,
Thanks for the response! I am worried that a restore may be in order, but that usually takes 2-3 days, due to the size of the database (853 GB...
January 2, 2013 at 2:04 pm
LOL. Sorry... problem with being at work with a cold? Not enough coffee yet? Actually, I ran both DBCC CheckDB (last week) and CHKDSK (today), no errors with either.
I...
January 2, 2013 at 10:26 am
Even though this is an older post, some (like me) researching this might find this useful:
Apparently, setting the "Tablix properties" is only good for a Matrix and not a...
September 14, 2012 at 12:53 pm
I had a similar issue (tried to install Replication after the initial install/patch of SP). Trying to run via the Media (Setup.exe) and adding replication failed (version issue error messages)....
July 19, 2012 at 9:33 am
That said, if you are fortunate enough to have a complete lineage-impact matrix of your entire solution and can accommodate all downstream dependencies, a suitable script would be a valuable...
July 11, 2012 at 5:39 am
Viewing 15 posts - 16 through 30 (of 117 total)