I was actually trying to open the tables through Management Studio....and I know where I was going wrong..

I was trying to "right-click" and "edit" on the table, when I should...

thanks for your reply 😀

thanks for your help guys....:D

I left school at 16, got a job in HR, then at 24 started a Bachelor of Business degree part time whilst still working in HR, graduated at 29 with...

I cannot check that the old server had the same collation sequence, because it has been decomissioned.

thanks - I'll give it a go!

ok I'll answer your question.....there is one row.

thanks for all your help - I'll figure it out from here.

I really just wanted to know why it didn't work through EM...

ok thanks for your help.....I just have one more question....

Why doesn't this work through EM?  Is it a bug?  Or was it never meant to work through EM?  This is...

no its not a restore from another database - does this make a difference?

Apart from Books Online, can someone suggest a manual (downloadable) that covers SQL syntax specifically for SQL Server?  I don't use SQL Server very often, so I am not really...

Sergiy,

My first line was:

"A very easy question for someone who has the time to respond...."

If you don't have the time, then don't respond.  There is no need to be rude.

Thanks...

Hi,

I think I posted my question wrong....I meant I wanted to get ALL of the data within the last month, not just the last day of the month, ie something...

thanks, I was aware of that one, but I was asking more of what other things I need to consider.  What server properties to other people take note of when...

Thanks, but I really just want to know why it is trying to run under this userid?  Surely I can choose which userid to run the maintenance plan under?  The...

Thanks for your reply.

But as I mentioned, the account running SQL Server Agent has sysadmin privileges.