Try this.

USE testing

GO

declare@MyEmailString varchar(MAX)

select@MyEmailString = coalesce(@MyEmailString + ';', '') + coalesce(useremail, '')

fromtesting.dbo.users

EXEC msdb.dbo.sp_send_dbmail @profile_name='test',

@recipients=@myEmailString,

@subject='Test message',

@body='testing testing'

Don't use GO after declaring a variable.

Yes, all the indexes (clustered and nonclustred) dropped automatically whenever a table is dropped.

Try this:

Right click -> Tasks -> Import.../Export...

See the attached screen shot for reference.

Exported file is in xml format.

1. No. RTM is not ready. Only CTP is available.

2. No. No need to install SP1 and SP2. You can directly install SP3

1) sp_help <source/target table name>

2) Open Excel

3) Copy the source table structure and paste to Excel Sheet1

4) Copy the target table structure and paste to Excel Sheet2

5) Click...

Thanks for informing that it worked.

🙂

Run DBCC UPDATEUSAGE. It may fix the issue.

By default BULK INSERT does not fire triggers. You have to use FIRE_TRIGGERS option.

Another work around is after Bulk Copy, you can easily insert the data to other tables...

Other two important features:

1) TDE

2) MERGE statment

SKYBVI (9/14/2011)

---

Here, it is a function.

I guess, you do not have enough permissions to view the database level triggers...

It is returning 0 rows?

It is a database level trigger. It is common for all the tables. Not just related to that table.

You can check using SSMS UI also. Under...

sqlgreg (9/7/2011)

---

I'm getting errors when running DBCC CHECKDB on a particular database. The database is running on my local workstation (SQL Server 2008 R2, Win 7, fairly fast machine with...

Select events Error Log, Event Log under Errors and Warnings and Audit Login Failed under Security Audit

Check for Database Triggers. DDL triggers are on database, not on table.

Please run this query:

select * from sys.triggers