SQL Server is trying to (potentially) save you from yourself 🙂 It's saying that you're going to overwrite a database that's in FULL recovery mode which hasn't had its...

What tool are you using to edit the contents of the table? SSMS? There shouldn't be any particular limit on the number of ntext columns in a table.

Make it decimal(38,19). After that, do some table update of sorts to round the data appropriately and then use your GUI tools to make it decimal(25,10).

The table update could...

Reformatting your drive and reinstalling Windows & MS SQL is not a small thing 🙂 You might as well have an entirely new computer.

Anyhow, you are logged into Windows...

Hmmm... You could try to deny access to most of the tables in master I guess.

If you really want to go down that road (if they can view but...

Google's your friend.

See

http://209.85.173.104/search?q=cache:p06LYuo2cI0J:www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20896100.html+Error+14274-Cannot+add,update+or+delete+a+job&hl=en&ct=clnk&cd=3&gl=au&client=firefox-a

(This has google cache looking at Experts-Exchange)

Also see http://support.microsoft.com/kb/281642

This might solve your problem.

Access to the master DB is required to a certain extent. What/why do you wish to deny (in) the master DB?

You could even go as far as to uninstall SSAS, reboot and then reinstall SSAS to see if that helps. Alternatively, install a second instance using defaults and see if...

Are you getting an error message? If so, what is it?

Good work on solving it yourself 🙂

You may think it seems a bit silly at first, but you may wish to consider creating a dates table (very similar to a...

I haven't tried to decipher the dynamic SQL in too much depth but what error message (if any) are you getting. Is it just not filtering the way you...

If your source data is that messy then that's probably the easiest thing to do.

The first reply was spot on - keep it consistent with the rest of the system. I suppose you should also think of how beneficial a list of countries,...

Google's your friend 🙂

http://www.google.com.au/search?q=A+correlation+name+must+be+specified+for+the+bulk+rowset+in+the+from+clause&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Visit one of the first links in google's results (http://technet.microsoft.com/en-us/library/ms190312.aspx)

Then search on the page for correlation and you'll see how to make it work.

Long story short, you...

Can you hook SQL Profiler up to your Analysis Services instance and see if what commands, if any, are being issued? If so, can you then take those commands...