This is kind of straight forward task using SQL Server Management Objects (SMO) in C#/VB.net, i.e. in an SSIS script task etc.. Don't have an example at hand but a...

Thanks Grant, came back to add the documentation link:-)

😎

For indices other than primary keys the answer is NO, the closest would be the date for the statistics

😎

SELECT

I.object_id

,I.index_id

,I.name...

Quick suggestion, create a procedure that executes sp_readerrorlog and filter/search the output, then use sqlcmd and a windows scheduled task to execute the procedure.

😎

DECLARE @LOG TABLE

(

LogDate...

sqlguy-736318 (4/1/2015)

---

Hello, I work in an environment with 3 app devs. We need to keep our local dbs in synch with changes made by the other devs. Are...

For completeness, what's missing is the removal of half of the CRLF combination (windows newline)

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#t3') IS NOT NULL DROP TABLE #t3;

Create table #t3 (id int, country...

As mentioned before, this looks like blocking, typical signs are high signal waits with relatively low actual cpu usage but following the same pattern. The reason for it to suddenly...

Obviously the Test Connection is successful?

😎

Don't have SSDT available at the moment, so I cannot do much more than point you to this article: Example using Web Services with SQL...

Quick thought, use the OUTPUT clause, here is an example

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @GUIDINSERT TABLE

(

GUID_ID UNIQUEIDENTIFIER NOT NULL

...

Quick thought, having a Named Pipe as a protocol there looks odd, have the client network configurations changed on the server?

😎

Named Pipes Provider: Could not open a connection to SQL...

itmasterw 60042 (4/3/2015)

---

Hi,

Someone was telling me that they had a text file that was both comma and piped delimited and that they used BCP to import it.

While they did not...

Quick question, as looks like the HTTP Connection Manager is not correctly configured, can you post the connection configuration?

😎

As SSIS does not have the concept of implicit type conversion you will...

Further on Sean's answer, seriously suggest you look into some database design patterns, what you got there is just awful

😎

ZZartin (4/3/2015)

---

My favorite was coming across a system...