No reason...

Thanks Lynn

Your solution is correct - I didn't examine my own test data thoroughly enough. :blush:

Hi Vijay,

I don't know a tutor, but I learned loads about SSIS when I needed to from Brian Knight - he has a website with lots of video tutorials. ...

My advice.

Never have production and development DB's on the same SQL Server. Its just too easy to make mistakes

Have a completely separate machine for development DB's.

I...

Hi - I can't answer all your questions but here's what I have done.

What are objects I have to backup after encrypt my columns?,to prevent losing of my encrypted data...

Separation of databases is usually along the lines of business function. If you only have one business function, then one database may be a suitable option. If you...

Hi FredS

Its really a matter of business knowledge of how your company will use the data.

I did a lot of work in the insurance industry, and a common factor seemed...

SELECT E.EmpRow FROM (

SELECT Name, Name AS EmpRow FROM EMP

UNION ALL

SELECT Name, CONVERT(varchar(10), AGE) AS EmpRow FROM EMP ) AS E

ORDER BY E.NAME, E.EmpRow...

There is a command line utility SAC - you can export and import settings using that - Ii'm not sure if its available in the Express edition though, See if...

Try GETDATE()

insted of date(now)

If that doesn't work, post the error you are getting.

Try this

select name, age from emp

and Welcome to the Forum.

Ask anything you want, there's always someone here willing to help 😀

Very interesting question.

I think if the table is likely to be accessed frequently without retrieving the blob data, such as reporting, listing, that kind of operation - then...

Refer to

"DBCC SHRINKFILE"

in books online. This is how you'd script it in T-SQL, however I'd read up on it first to see if its really what you need.

In...

sp_change_users_login 'Report'

rings a bell, from memory.