i.e. In the properties of the solution, there is an option for OverwriteDataSources. That can cause big problems...

Maybe the properties of one of the connections changed on the report server. That, or someone deployed a report and accidentally overwrote the connections.

You do realize that you have to execute this from command prompt or using xp_cmdshell? This is not an SQL command and cannot be executed as such.

To execute...

Have you researched SQL Server Alerts?

dbdmora (6/5/2012)

---

Hi SQLKnowItAll, when I say hardcoding, our developers were putting the actual server name for example MyServerName.Database instead of using a DNS alias for a connection string or when...

dbdmora (6/5/2012)

---

Hi Steve, to answer your question about schema, I want to make sure developers don't use the default dbo schema but a more relevant one for example customer.name sales.leads...

NJ-DBA (6/5/2012)

---

I guess the only way to do this is to add multiple daily subscriptions which run at X hour, so for 8-5, I would have 1 subscription that runs...

What is the DDL for the table FicheirosImportar, and sincronismo?

Who said I assumed that? :-)...

This is what I use:

/*

* CATEGORY: Script

* AUTHOR: Luiz Barros

* OBJECTIVE: Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database

*

*...

r.pe (6/4/2012)

---

Thanks Lynn and Jared.

What gets me is that the function definitions are virtually the same in 3.0 and the 4.0 system. The nested calls are the same. The...

Marius.D (6/4/2012)

---

Maybe I'm not getting this, but tableB does not get updated.

The big question mark continues to be, with or without more indexes, how come the sp runs anywhere...

Hehehe... More functions in this one too. I would not be happy the development company that wrote...

r.pe (6/4/2012)

---

Jared,

I typically try to do my homework. There was something about a timezone change with Windows around the year 2008 for Daylight savings time but I doubt that this...

I don't see any issues in taking what you learn here and applying it to your own business. In fact, that is what most people here take away from...