In that case, instead of SELECT @name, @val WHERE, it would be

SELECT s.name, s.val

FROM SomeOtherDatabase.dbo.SomeOtherTable s

WHERE NOT EXISTS (SELECT 1 FROM u_apppreferences WHERE name = s.name)

If it's server-side traces that you're using, then the easiest thing is to use Profiler to set up the trace, then go to File -> Export -> Script Trace Definition

That...

Sounds like you're using an old version of Management Studio with a new version of SQL. What do the following show:

SELECT @@Version

In Management Studio: Help -> About

8 CPUs doesn't mean 8 files for TempDB.

Adding...

He's converting it to varchar in order to concatenate it...

Because if you leave out the quotes, then you have something like this:

AND EmpCode = 256781

Where EmpCode is a varchar column and 256781 is a literal with a numeric type....

2008, so you're using server-side traces?

The Security Audit: Audit Login has both database id and database name as event columns. Just check the boxes when you create the trace, they're...

Add the DB name from the (Global Fields) Actions tab, it won't be default part of the event's columns

Steve Jones - SSC Editor (7/5/2016)

---

Also, as we've evolved, so have spammers. They change tactics, so there is a race here, and sometimes it's easier to work with what we...

No you haven't.

You have two copies of the...

Steve Jones - SSC Editor (7/5/2016)

---

So if you have a 2008 RTM instance and a 2008 SP3 instance, you can restore RTM backups to the SP3 instance, but not vice...

Create an extended event session, run it for the 10 minutes that you want to analyse, query the resulting file.

You can use the DMVs, specifically sys.dm_exec_query_stats, but they won't necessarily...

To explain why you're getting syntax errors, the output of a case statement must be an expression (constant, parameter, column, variable or function), not a clause or a predicate of...

INSERT into u_apppreferences(name, Val)

SELECT @name, @VAL

WHERE NOT EXISTS (SELECT 1 FROM u_apppreferences WHERE name = @name)

as your current one is prone to concurrency problems (will cause duplicates under load)

http://source.entelect.co.za/why-is-this-upsert-code-broken

the...

You can't attach a single database to two instances. A database can only be attached to a single instance.

I suspect you only have one instance, not two, hence when taking...