Michael Gerholdt (4/3/2015)

---

How do I tell SQL Server what key to use for DES3 decryption? I want to encrypt in Oracle and after ETL to SQL Server, be able to...

coool_sweet (4/4/2015)

---

i have 1 variable whch is integer.

i am using row count transformation and adding values to this variable.

now i want this variable to char(8) instead of int.

how to do...

David Burrows (4/4/2015)

---

Did know someone whose workplace had a life size cardboard cut out of a person called Maud (name not...

Tac11 (4/4/2015)

---

my experience is, I tried to do 'page compression' on a table to gain some 'free space' on the databases level. But when I did it, i got more...

Quick note, use the sys.dm_db_persisted_sku_features to identify Enterprise features in use

😎

SELECT

PSF.feature_name

,PSF.feature_id

FROM sys.dm_db_persisted_sku_features PSF;

Jeff Moden (4/1/2015)

---

tomy200501 (4/1/2015)

---

Hello All,

I am trying to set "Is Identity property" To Yes on a column that has uniqueidentifier as a type and has a primary key constraint on...

You are missing the hash(#) prefix for the #busdetails in the from clause

😎

SELECT @Query = 'SELECT m.bus_id as ID ' + CHAR(13)

+ (SELECT...

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...