I am not going to use the cursor.

😛

Sean Lange (3/8/2012)

---

Beginner_2008 (3/8/2012)

---

Sean Lange (3/8/2012)

---

Here is a good place to...

Eugene Elutin (3/8/2012)

---

Do you want to send email only if Customer FirstName is changed?

What about Lastname?

What about other details?

If yes to any of the above two, what you email when...

Any example...

Thanks for the suggestions.

Can anybody please provide the best alternative with an example? I am new to Database mail.

Sean Lange (3/7/2012)

---

Need a little more clarification on what you are trying to do but in general your approach to this trigger is not going to work well. In your...

Good article,

I know to view audit logs, we can right click from SSMS to the audit specification and view them if the object has made the destination to a file....

Thanks for the information.

Thanks for the question.

See table 1 has

id,

firstname,

lastname,

transactionamount

table2 has

id,

fullname,

transactionamount

How to compare the firstname,lastname with fullname

And after comaprision check whether the full name is 70% of the the both firrstname and lastname.

Example:

firstname: William

lastname: John

Fullname: Wil...

No my question is after the secondary database has gone in "Restoring" mode, how to bring to accessible mode?

Please suggest.

Thanks,

Affzal..

tnk (10/13/2011)

---

There are two options for the database on the secondary server (aka, the one receiving the log shipments, so to speak). It can either remain In Recovery, or it...

Thanks,

I used export and import wizard . but it was urgent in the time..

you can use this dbcc command DBCC SHRINKFILE(<TransactionLogName>, 1)

or

you can do the same with management studio.

http://msdn.microsoft.com/en-us/library/ms190757.aspx

Make sure the log files are not active while you perform shrink..

SSIS package

Thanks..