Anyone with an idea?

I have multiple external databases that i want to connect to, from a stored procedure. What server the database is located on is dynamic (a record in a table). All of the external databases are...

The issue isn't how to use sp_send_dbmail, because i use it everywhere, for both querys and system mails.

But i have one problem, and that is how do you send a mail with HTML and TEXT format?
...

Solved, because i don't think there is any "good" solution for the problem.

I was thinking of making the automatical extension of schema based on user rights, because our customers have diffrent...

Damit, then I have to try to make the matching in the schema with the split, LEN and match, just to do the debugging a bit easier.

If it was possible to get the exact column, I would like to build...

Error message ”[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.” comes when you insert/update a larger value than the column is specified for. But is there a...

I'm verry close now.

For INSERT together with OPENROWSET you can use WITH (IGNORE TRIGGERS).

IGNORE_TRIGGERS
Is applicable only in an INSERT statement when the BULK option is used with...

If you "Include Actual Execution Plan" what does it say when you Insert or Update a record?

You could also try to change:

ALTER TRIGGER [dbo].[INS_AlarmsEvents]
ON [dbo].[TEST]
AFTER...

This gode writes ERROR:


BEGIN TRY
SELECT 1/0
END TRY

BEGIN CATCH
PRINT 'ERROR'
END CATCH

Classic ASP and text/ntext is pain, but if your running SQL 2005 then you can use varchar(max) insted, i have not experienced any problems i had with ntext after i switched over to varchar(max).
...

Your code in the TRY don't fire a error into the catch.

If you run this one you will se that it prints out ERROR:

BEGIN TRY
DECLARE @INT AS INT
SET @INT=CAST(GetDate() AS VARCHAR(2))
END...

It's kind of same solution I’m implementing now.
I have added a column called "TUpdate" it's a bit column that i set to true in all the different update statements. This solution will not use much...

Just to be clear, I’m thinking about something like this (except that I want to skip trigger instead of setting the update to only lock current row):
UPDATE <TABLENAME> WITH (ROWLOCK) SET...

Sorry but i don't think it's possible in SQL 2008 either, I don’t even think it have been discussed. Most database designers use table names to categorise, and if they don’t then they change to...

Try to change:
if(update(ReturnedOn))

To:
IF (SELECT ReturnedOn FROM INSERTED) IS NULL

I have a INSERT, UPDATE trigger on a table, it works great and helps me from firing a stored procedure from all the (think it's over 50places) where it is needed.

But I have one batch update to...

Hi Bporajesh,

This group is for MS SQL, most people here don't have knowledge about MySQL.

If you post your question in the MySQL group, you probably get more help:...