Kazim,

Have you considered using FILESTREAM in SQL Server?

http://technet.microsoft.com/en-us/library/bb933993.aspx

Thanks

Chris

Looking at the scripts provided the DraftContent table has two nvarchar(max) columns. The storage size, in bytes, is two times the number of characters entered + 2 bytes for...

All the documentation I have read simply states one or many without stating a maximum. the below by Kalen Delaney is a great place to start.

http://msdn.microsoft.com/en-us/library/dd939169(v=sql.100).aspx

Sorry

Chris

SQL Server 2008 R2 Developer Edition is not free! It is around $50.00 and can be bought from MS or amazon etc;

http://www.amazon.com/s/ref=nb_sb_ss_i_0_21?url=search-alias%3Daps&field-keywords=sql+server+developer+edition&sprefix=sql+server+developer+

The trial you have is exactly that a...

If you are using windows authentication and the account does not exist on the remote SQL Server machine, then when you try to connect your current context doesn't have permissions.

Make...

Is it simply table names which you are comparing accross the two instances? Or are you looking to compare table definitions as well?

Thanks

Chris

Actually you get when using british_english

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

grrr!

Script fails with syntx error another question which is incorrect *sigh*

Point in Time restores have always been flakey in EM. I always use scripts never EM or SSMS.

BOL specifically says

'Returns the date that the statistics for the specified table were last updated.'

We use this every day the answer is wrong.

I've moved this database on several of my servers using Microsoft guides???!

For SQL Server 2005

http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx

For SQL Server 2008

http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.100).aspx

For SQL Server 2008 R2

http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.105).aspx

Thanks

Chris

The first SQL Server install I succesfully slipstreamed was SQL Server 2008 with SP1. I've never been succesfull with installs prior to 2008 + SP1 and as you...

Can you script the alert job and post the SQL?

Thanks

Chris

FILESTREAM would look like a viable solution. Check out the MCM Training videos;

http://www.sqlskills.com/T_MCMVideos.asp

New Database Structures in SQL Server 2008

New Database Structures in SQL Server 2008 - Demo

Thanks

Chris