Depends if your using any Enterprise edition features.

Check sys.dm_db_persisted_sku_features in all of your databases to see if your using anything which is Enterprise only.

You will then need to check what...

Need to put the ISNULL around your select

SELECT EmpId, ISNULL([2005],0), ISNULL([2006],0), ISNULL([2007],0), ISNULL([ALL],0)

FROM

(

SELECT

...

...

Ask the user for any error messages they are getting.

Check the SQL server error log for any errors, especially around error 18456.

Does the user in question have access to login...

The monitor server is used to monitor information about files copied over between the principle and secondary servers, failures, etc (http://msdn.microsoft.com/en-gb/library/ms187103.aspx)

If your missing a log, or the log is not...

When you send the mail you will get a mail ID returned and it will be stored in MSDB, simply store that mail ID in a table along with the...

for each mail you send capture the mail id in a table and poll the mail table for the status, when it changes update the table to say its been...

If you want to change the system collation then you can rebuild the system databases from the install media.

You will want to script out all server objects like, jobs, logins,...

praneethydba (8/11/2014)

---

HI Experts,

On my production server, the sql server was down for more than 6 hrs & happened on weekend, no one noticed it. Before customers login, I started the...

That is true, but as I don't want to re-iterate what is already out on the web a simple search on Google for the phrase "export varbinary to file" will...

Google has a lot of stuff on this, not done it personally myself, but a quick search did return how to do it.

"export varbinary to file"

Could try something like using BCP to export the varbinary column out to a file, that might work, or a CLR procedure which reads and writes the varbinary out to...

First hit I got after google'ing

http://msdn.microsoft.com/en-us/library/aa337550.aspx

I would start with a google search on the topics of SSAS, SSIS and SSRS. They are the three other services you see, they all do different things which...

It requires that the particular service you have selected is running in the server name you enter and that your windows account has the necessary rights to be able to...

Check out the books section on the right.

Plenty of good books, paid or free covering lots of different SQL server topics.