When it comes to implementing a parameter driven process that performs multiple steps and then returns a result, that should generally go in a stored procedure, not a function.

It is possible to...

Ray Herring (2/21/2012)

---

Eric M Russell (2/21/2012)

---

Ray Herring (2/21/2012)

---

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not...

Ray Herring (2/21/2012)

---

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not automatically members of Builtin/Administrators, But...

jeanyvesR (2/21/2012)

---

Many thanks Eric , I have added the credential in MSDB db_ssisoperator role and it works fine.

Before this try I have found this MS kb : http://support.microsoft.com/kb/912911/en-us and a...

jeanyvesR (2/20/2012)

---

Sorry :crying:, but I going to run the job and I got following error message :

Message

Executed as user: Domain\PROXY_USER. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0...

The 2nd example will work, if your change the factor from an interger to a floating point like so.

select (cast ('1' as smallmoney) * 1000000000.0);

Charmer (1/24/2012)

---

Hi Friends,

i have table which does not have any date time column, but my need is to get some records depending on the date&time...is it possible...

Revenant (2/17/2012)

---

If you watch TV commercials, you may notice that the best salesmen are cute kids, dogs, and cats, in this order. No experience necessary.

Draw your own conclusions, DBAs....

Steve Jones - SSC Editor (2/17/2012)

---

Jack Corbett (2/17/2012)

---

I think commissions for sales people is the best way to compensate them. You provide a lower guaranteed salary so...

RobertYoung (2/17/2012)

---

It appears to have gone away, but Spolsky did a great piece on pricing (and by example, sales staffing) of software. The title is "Camels and Rubber Duckies",...

There are high value IT developers, salespeople, support staff, and executives; these are people who would have a high replacement cost if they left the company, and the cost would...

First consider there may be strong and compelling reasons to just keep the primary key on a natural non-clustered column(s) and have the table's clustered key on a timestamp or...

Describing the process of migrating a SQL Server database from one version to another as "switching a LUN" is definately a reductionist view of things.

The full Oracle client is a monster, and server admins are sometimes reluctant about intalling it. If all you need is connectivity for a linked server connection or SSIS, then...