It is definitely a huge mistake to store dates as integers. This is just one of the many issues you are going to run into - but, if you...

I know - I have now updated my signature and added two links, one of which is that article.

Tracey, I am not sure what you are asking here. If you drop and create a synonym - the synonym will now be a synonym for the new object.

Synonyms...

Gail - I have to make sure I remember this link. I see this issue so often now that it would just be easier to link to the article...

To add to what Jonathan has stated - I prefer a scripted solution since that does not require an instance of SQL Server be available for monitoring. For something...

The error is telling you everything you need to know.

Error message: ' [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'Indicadores' is full. Back up the transaction...

Christian - the semi-colon is required before a CTE WITH statement. I personally prefer prefixing the WITH instead of relying upon the previous statement ending with a semi-colon. ...

I would use Powershell and WMI to check service status.

This will get you started, all you need to do is look at the examples for how to loop through a...

No need to run the test code - I did say *may*...;)

Now, if you look at what the OP posted - you'll see that the WHERE IN is also a...

Just to be clear - EXISTS does not return any rows at all. Exists stops processing as soon as a match is found. The EXISTS query may be...

I would recommend that you don't get rid of the data corruption forum. It should be one that stands by itself for those cases where someone is really in...

From a query window execute SELECT @@VERSION and also from SSMS go to Help | About and show us the results for both. These kinds of errors can generally...

Not sure I follow all of your dialog - but, if I am reading this correctly you are trying to access a report in SSRS on ServerA that accesses the...

Two things I know of to check:

1) Server properties - make sure you have set filestream access to full access

2) You must be using Windows Authentication to access...

Jeff Moden showed a way to do this, but I would caution you about doing this for your project. Creating a view with dynamic columns is going to cause...