Very clear

Not entirely sure - I think you can specify it on the connection string used when connecting to SQL.  But once you...

Good article!

Hi Raj.

Your question doesn't make much sense to me.  Could you try rephrasing it?  SSL is typically used to provide end-to-end encryption for data - working effectively as a layer...

I hope I don't have to go through similar pain - sounds very messy   Will save a link to that tool though, sounds...

You don't need to "shut down" the server, although the DB is inaccessible during the restore for obvious reasons.  SQL 2005 has some improvements in that area I think.

To restore...

Well observed Paul

Glad to be of help

If you put your database in FULL recovery mode (rather than SIMPLE recovery mode), you can take a full backup at some time before the table is deleted.  Then, if...

Ahhh, didn't know they could be clocked on several times a day - spose that's why you were using exists...

Then perhaps using a group by on the Fullname, Extension &...

You won't get 70kb of text in row though - row lengths are 8192 max bytes (from memory - don't quote me).  And then with text in row you get...

Is there something similar to the Active Directory migration tool that can move windows accounts between servers rather than between domains?  We used it at a site once (although it...

Yes, the other post was quite funny in comparison

Good point - one of those things you probably wouldn't think of if you hadn't come across it before

Is this about the same topic in another post (the post was a lot longer but asking essentially the same thing)...

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=229905#bm229935

Try this

SELECT 

 Employee.FullName,   Employee.Extension,

 EmployeeDepartments.Description,  

 Case when TimeClock.Type <> 5 then 1 else 0 end as ClockedIn,

 Case when TimeClock.Type = 5 then 1 else 0 end as OnLunch

FROM Employee

  INNER...