here's an adapted example of some code i use to check for invalid objects; this will recompile your procs/functions/views to allow you to point to a different database.

at the end,...

ok, here's a cursor example adapted a bit to your requirements;

YOU will have to modify it to manage any date conversions/formats to varchar, as well as gracefully handle nulls, because...

also, wouldn't it be better to send an email simply stating there is an alert/facilities are down,a nd direct them to a web page for details?

ok, so how many rows does your query return?: and please confirm that if that returns 100 rows, you want 100 emails, one per row? is that what you are...

wheelsthatgrip (12/5/2013)

---

Hello All,

I am using dbmail to send out the results of a query. The results are being sent to SMS users so the output has to be limited...

details. you'll wnat to provide details if you wantany meaningful answers.

inside the trigger, you compare the columns in the virtual tablees INSERTED and DELETED to each other.

ie

IF EXISTS (SELECT 1...

Ratheesh.K.Nair (12/5/2013)

---

Hi Experts,

We have a DB user names Supply . Application will hit the DB with this username.

Is there anyway to find the hit happening to the database?Thanks in...

Gail i just tried that, but cannot seem to get the object_id;

for a temp table, i can get object_id('tempdb.dbo.TableName') no problem, but is there a trick for table variables?

this is...

navimir (12/5/2013)

---

I am working on triggers for insert,update and delete

output of the trigger shows tablename,user and timestamp

Is it possible to display the column name,old value and new value??

There are around...

so your procedures are using three part naming...

I'm always into the free resources, as long as you are willing to pour your time into learning.

I started straight from the source: android.com has a lot of of reosurces...

sqlvogel (12/4/2013)

---

That's incorrect. It's not necessary to create a primary key for referential integrity purposes. Referential Integrity is a good thing of course but you can enforce referential integrity against...

at one point, built a .NET project that used the quickbooks connector from http://www.rssbus.com/;

with that, and some minor configuration in quickbooks to allow remote access, i was able to see...

mote.ajit2 (12/4/2013)

---

Hi!

I am trying to call procedure from function but getting following error.

Invalid use of side-effecting or time-dependent operator in 'INSERT EXEC' within a function.

Actually I want table valued function...

sree-226516 (12/3/2013)

---

Hi,

We have a stored procedure which updates table A every 5 mins whole day(9AM to 7PM).Table A has only one day worth data and end of the day it...