But if his log is getting physically larger then something is taking up the...

Perry Whittle (12/6/2016)

---

There shouldnt be any reason why you...

Hi Thom,

thanks for clarifying; that was my thought as well. The link I will be checking out.

Looks like I'll be relying on inefficient ETL in the meantime.....

Ed Wagner (12/10/2016)

---

kevaburg (12/10/2016)

---

Ed Wagner (12/10/2016)

---

kevaburg (12/9/2016)

---

Try a shrinkdatabase:

exec sp_msforeachdb 'DBCC SHRINKDATABASE [?]';

It is far from ideal and you will most likely experience performance problems during the run (do it...

Ed Wagner (12/10/2016)

---

kevaburg (12/10/2016)

---

From my point of view you quite simply don't have the permissions to perform the installation.

Have you tried starting the Installation with elevated privileges (Run As Administrator)?

The...

Ed Wagner (12/10/2016)

---

kevaburg (12/9/2016)

---

Try a shrinkdatabase:

exec sp_msforeachdb 'DBCC SHRINKDATABASE [?]';

It is far from ideal and you will most likely experience performance problems during the run (do it in a maintenance...

How do you measure database complexity?

Ideally a solution will be as simple as possible, but does not necessarily mean it will be simple.

Very rarely will a developer be able to...

HanShi (12/9/2016)

---

Have you read this article? Fix: Windows...

From my point of view you quite simply don't have the permissions to perform the installation.

Have you tried starting the Installation with elevated privileges (Run As Administrator)?

The Red Cross though...

Saurabh.D (12/9/2016)

---

Very less information I found on xp_readerrorlog

Exec sp_helpextendedproc 'xp_ReadErrorLog' gives "xpstar.dll" as source.

there is no page even on MSDN Library

Here is...

When I understand the procedure properly...

R.KU.PA_DBA (12/8/2016)

---

Hi Guys,

I have two node windows server 2012 cluster with SQL installed in cluster, I need to add the another two nodes into the same cluster.

Is this possible to...

sal-295209 (12/8/2016)

---

Hi Everyone,

I have 2 servers running SQL Server 2014 which are in different location. Server 1 does not see Server 2 and vice versa. I have a shared drive...

Try a shrinkdatabase:

exec sp_msforeachdb 'DBCC SHRINKDATABASE [?]';

It is far from ideal and you will most likely experience performance problems during the run (do it in a maintenance window) but if...

Here is a solution that might suit your purposes:

create procedure sp_readerrors

as

declare @string1 nvarchar(64) = null;

declare @string2 nvarchar(64) = null;

declare @logNum int = 0;

declare @logtype int = 1;

declare...