mandy-570563 (7/27/2015)

---

I have an SSIS solution deployed to the SSISDB catalog. It has a number of project parameters which I have setup an environment to provide values to....

select Mth = datename(month, dateadd(month, Mths.Mth, -1))

...

Create the table as usual, then add the FKs using ALTER TABLE:

alter table MyTable

add constraint MyTable_MyColumn_FK FOREIGN KEY ( MyColumn ) references MyOtherTable(PKColumn)

vipin_jha123 (7/27/2015)

---

CREATE TABLE [dbo].[md_geographylevel](

[type_key] [int] NOT NULL,

[geog_key] [int] NOT NULL,

[Type_description] [nvarchar](50) NULL,

[Store_flag] [nvarchar](10) NULL,

[Type_short_desciption] [nvarchar](50) NULL,

[Type_long_desciption] [nvarchar](100) NULL,

PRIMARY KEY CLUSTERED

(

[type_key] ASC,

[geog_key] ASC

)

CREATE TABLE [dbo].[md_geographyleveltype](

[type_key] [int] NOT NULL,

[Type_description] [nvarchar](50) NULL,

[Store_flag]...

vipin_jha123 (7/27/2015)

---

Hi All,

I never created table on the basis of Data model diagram .

I have to create the 3 table on the basis of given Data model diagram.

there are 3...

That's no problem. SSMS is not licensed separately, so go ahead.

tt-615680 (7/24/2015)

---

EXEC msdb.dbo.sp_send_dbmail

@subject = 'Job Summary',

@profile_name = 'SQL SMTP',

@recipients = 'email address',

...

metroman17 (7/24/2015)

---

DECLARE @ServiceStatus TABLE

(ServerName varchar(128)

,ServiceName varchar(128)

,StatusOfService varchar(128)

,StatusAsOn datetime)

INSERT INTO @ServiceStatus (StatusOfService)

EXEC master..xp_servicecontrol 'QueryState', 'msdtc'

UPDATE @ServiceStatus

SET ServerName=cast(@@SERVERNAME as varchar(128))

,ServiceName='Microsoft Distributed Transaction Coordinator'

,StatusAsOn=GETDATE()

--WHERE ServerName IS NULL

SELECT * FROM...

I do not have dbo.Notifications.

Did you read the link in my signature?

If I were to run this in my local SSMS, it would fail.

kmamenya (7/23/2015)

---

Hallo,

I am trying to calculate the number of hours a device has been used and I cant find how...Any help guys...I need a query that calculated and does...

You have been here long enough to know that you should post your data in a consumable format.

dwilliscp (7/23/2015)

---

How would I find out what happened to create the error below... It is hard to believe it was a time-out issue since the elapsed time is only about...

I'm with Alvin. In fact I'll be more blunt: the packages should be rewritten.

Many of the things DTS can do cannot be directly translated to SSIS. Hundreds of the...

Alvin Ramard (7/22/2015)

---

If you have many packages to migrate, then you might want to consider 3rd party tools for doing so. the only one I'm aware of is from a...