greeshatu (3/29/2013)

---

Hi

I have scenario where I need to Call an Storeprocedure in SQL task

Eg: Procedure Name Like Usp_ABCDEF 'Param1',Param2'

Part of Stored Procedure name is coming from Varible

Eg:...

This solution allows you to set a duration for how long you want the index job to run. It will finish the index it is working on when it reaches...

Jeff Moden (3/30/2013)

---

Then I have to admit, points in favor of PowerShell but only if such auditing software is actually inplace, active, and that, you as an administrator, can't defeat...

Jeff Moden (3/30/2013)

---

Ok. So let's ask another question. To keep it simple, you've either been given administrative privs on a box or you are the administrator. You fire...

Jeff Moden (3/30/2013)

---

opc.three (3/30/2013)

---

Once again you're focusing in too narrow a field and only considering SQL Server auditing, and only a piece of that to boot. What about the folks...

Once again you're focusing in too narrow a field and only considering SQL Server auditing, and only a piece of that to boot. What about the folks that kick off...

INFORMATION_SCHEMA is there to serve certain clients that want to maintain ANSI-standard code and sp_helptext is not going to be very easy to work with. Instead, try using this query...

Thanks for the post, Steve. I'll chime in since I have a feeling I know where the idea for this Editorial came from 😉

I think xp_cmdshell should be disabled, period,...

It sounds like a data-driven error. Check the data types on your Excel Source to make sure they match the columns they are mapped to in the Excel file. In...

Brandie Tarvin (3/29/2013)

---

opc.three (3/28/2013)

---

With only a single Precedence Constraint in place I am not aware of a configuration that would allow SSIS to execute a subsequent task without the previous...

With only a single Precedence Constraint in place I am not aware of a configuration that would allow SSIS to execute a subsequent task without the previous task completing, whether...

Dave Pendleton (3/28/2013)

---

If you are having difficulty getting this to work consistently, try adding the following to WatchForFileCreation:

// enable the watcher

fileSystemWatcher.EnableRaisingEvents = true;

just prior to the WaitForChanged call. In the...

My pleasure. One item of note, the revlogin proc does not pickup Fixed Server Role membership. Here is a query you can adapt to pickup those memberships as well. I...

opc.three (3/27/2013)

---

GilaMonster (3/27/2013)

---

opc.three (3/27/2013)

---

At 50% I would rebuild. If you're having trouble with log size look into partitioning your table and indexes so you can rebuild smaller subsets of your...

The article is more geared towards debunking the myth that BULK...