How are you executing packages on the SSIS execution server ..

--

SQLBuddy

Jeff Moden (2/26/2014)

---

sankepalli (2/26/2014)

---

Hello Folks,

Suppose, there are 1 million records, if we insert all these records in the log file, it will become full & DB will become read only....

Nice to know that. Did you finish your installation ..

--

SQLBuddy

You are welcome, Oracle_91 🙂

--

SQLBuddy

You are welcome Dajon .. 🙂

--

SQLBuddy

Oracle_91 (2/26/2014)

---

Hi Team,

Can anybody help me knowing what versions can I have replication for Publisher , Subscriber and Distributor.

Do I need to have all 3 servers as same sql...

sankepalli (2/26/2014)

---

Hello Folks,

Suppose, there are 1 million records, if we insert all these records in the log file, it will become full & DB will become read only. We cannot...

Check this one as I previously mentioned ..

http://www.mssqltips.com/sqlservertip/2511/standardize-sql-server-installations-with-configuration-files/

--

SQLBuddy

If you do NOT have a DefaultSetup.INI, create one as follows :

;SQLSERVER2008 R2 Configuration File

[SQLSERVER2008]

PCUSOURCE=".\SP"

in each of those 3 folders

--

SQLBuddy

As far as I remember, it should be called DefaultSetup.ini

Did the previous steps run successfully ..

--

SQLBuddy

Yeah, I agree with Jeff and others. But make sure to discuss the same with your application team\developers.

When you run the generic report, you should be very careful...

You have to create a slipstream installation file using SP2.

Instructions are as follows ..

http://my-installguides.com/?p=536

--

SQLBuddy

Try this ..

declare @trace_id INT

select @trace_id = 0

select @trace_id = traceid

from ::fn_trace_getinfo (NULL)

-- where value = 'D:\Server_TraceFiles\trace\profiler.trc' (Modify This )

EXEC master..sp_trace_setstatus @traceid = @trace_id ,@status = 0

-- Closes the specified...

If you are planning to use \already using SQL Server Auditing, then definitely you should consider upgrading to SQL Server 2012. There are some good improvements both in Security and...

kimreyj (2/25/2014)

---

After doing some performance research, it appears that covering index(es) may be beneficial for a couple transactional tables in my database.

My question is this:

Is there ever a benefit to...