you have to select the client-tools option to install SSMS

Schadenfreude-Mei (12/5/2008)

---

Gail: BES is Blackberry Enterprise Server

According to the instructions from the BlackBerry web site, for DR purposes you have to setup Transactional Replciation (there is a script to run...

Ninja's_RGR'us (12/4/2008)

---

JohnG (12/4/2008)

---

Note that even in America, extended ASCII is very common. Just think of all of peoples names that have accents in them. Or the word resumé....

try writing it like this;

SELECT DISTINCT t1.Col1, t2.Col1

FROM Table1 t1 LEFT OUTER JOIN Table2 t2

ON (t1.Col1 = t2.Col2)

WHERE t2.Col1 is NULL

I had a similar problem a few months ago and wanted a solution that did not involve editing the noise-word list. What we ended up doing was to create...

If you are using a stored proc for all the inserts against the table, then it would be better to modify this procedure to check the number of records rather...

You should use a data-conversion transformation instead of the script, as this date is in a standard format the data-conversion will re-direct any rows that are not valid dates....

what is the error that you are getting?

It means that the value that you are passing can be a Unicode string, it is not really needed unless you are using Unicode

You want to use UNPIVOT for this,

If you post your exact table structures and some sample data, then I can provide some code that should work

As it is for an examination, how about you show us how...

What sort of trigger?

Carla Wilson (12/3/2008)

---

RE: audit table - it's not like a standard audit table. I have several of those, and the columns do match the datatypes of the tables that...

This does look like an SQL account issue, to get mirroring to work you will need to either run your SQL servers with a domain accout, or...

you can use

INSERT INTO [Destination] (id ,title ,body)

SELECT id ,title ,cast(body as varchar(max)) from [Source]

Though I think that the data conversion may not be needed as it should do this...