Say you have two tables, TableR and TableL, then the OUTER join can be expressed in four ways, two of which are as follows:

TableL RIGHT OUTER JOIN TableR

OR

TableL LEFT OUTER JOIN...

You can use CONVERT(char(8),getdate(),112) to get the date part.

For time use the DATEPART function, eg.

CAST(DATEPART(hh,getdate()) as varchar) 

Replace 'hh' with 'n' for minutes and 'ss' for seconds. You will have to...

char() columns will pad the data with blanks. An easy solution would be to use the RTRIM() function to remove the spaces.

Assuming that the .mdf file is a sql server database file, then this error would suggest that the database was not a 'clean' detached database and/or it is corrupted.

have a...

Trying to trick sql server does not always work, and you may create more problems down the track.

Since you only have the .mdb file, you can simply reattach that file to the new...

Is the 150MB that you specified greater than the current log file size that you are trying to shrink?

A number of database state options are available, including (refer BOL under 'ALTER DATABASE'):

    < state_option > ::=

        { SINGLE_USER | RESTRICTED_USER | MULTI_USER }

        | { OFFLINE | ONLINE }

        |...

You could try something like this:

select distinct StudentID, Name

from (

 select StudentID, Name,

  Trigonometry = case sc.CourseDescription when 'Trigonometry' then 1 else 0 end,

  TheatreI = case sc.CourseDescription when 'Theatre I' then...

Not really! But the other alternatives (apart from char(39) that you've used) include QUOTENAME() and to double the single quote.

Yes it does, and it is the most optimal way to recreate an index.

There's more info on the DBCC REINDEX command in BOL.

The snapshot is created based on the publishing database, and you do have the option of not applying this to the subscribing database(s) if you so desire.

As per previous emails,...

Yes that is correct! A snapshot file is one way to create an exact copy at the subscriber for merge replication.

The approach to making exact copies of two databases would...

Did you enclose the select string in quotes?

One important thing to realise is that Merge Replication (MR) requires that both the publisher and subscriber databases are in sync. This is achieved through the application of a snap-shot...

When synchronisation occurs b/w a Publisher and a Subscriber, the merge agent will determine which data will be propagated to where in order to achieve Data Convergence. In this instance,...