Is the database in readonly/standby due to logshipping or other HA technology or have you set it like that manually?

Is the databases on a different server than the others?

Is the...

PDW can only be purchased from HP or Dell when you purchase the vendors appliance which is capable of doing PDW

If you grant the server level role sysadmin you dont need to grant anything else as your effictivly saying you can do what you want where you want.

MSSQL is a Microsoft product, and can only be installed on a Microsoft operating system.

You can install MySQL on Linux and use the MySQL Data Controller to connect to a...

Good luck getting sample data, DDL and expected results from this user.

We have asked a number of times on different topics all related to the same problem the OP is...

Data source needs changing to windows authentication and not SQL authentication.

Also run through the SSRS config and set an unattended execution account if you plan to use subscriptions.

My origininal post contains a default login trigger, all you need to do is create a table with 1 column and change the trigger to insert into that column.

The best way to word it is TOP is non-deterministic in that you may not get the same results twice without enforcing order.

All depends what data the engine reads first.

"There...

Yep thats a good one to read, more of a overview to SSAS, the one I provided is more of a hands on, lets go build a cube tutorial.

Duplicate post.

All replies here http://www.sqlservercentral.com/Forums/Topic1335034-391-1.aspx

I think a good place to start would be here http://technet.microsoft.com/en-us/library/ms170208.aspx

sp_help_revlogin would probably be the best way, or manually script out the logins to script and run them on azure.

So you dont know the name of at least 1 table within the database without looking at it in object explorer?

Do you not have a DEV/TEST/UAT copy of the database...

No, your using the wrong date function, your adding to a date instead of getting the part of the date you want.

The clues are in the bold italic text of...

Did you google "DATE functions in T-SQL"

If so the first link would take you through all the different date functions that exist in SQL and you would of found the...