does the startup account of SQL server have...

This way be an object name, and optionally parameters after object name

exec @sqlStr

THIS way, you can execute a string command: note the parenthesis!

exec(@sqlStr )

As I understand it, there will be no significant impact at all;

if you look at the execution plan, all objects are extracted out to their four part naming convention anyway;

I...

On The server NJACCOUNTING01, look at the indexes on the table marlin_test.dbo.apdoc

an index like this would greatly help the query, i believe:

CREATE INDEX IX_apdoc ON dbo.apdoc(Crtd_DateTime,DocType,VendId) INCLUDE (user1,vendid)

see what indexes...

Tina there's quite a few things i'd do differently as far as the naming of tables and columns; Tables don't need tbl_ in front of the name, and the PK...

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...