river1 (1/3/2016)

---

Thank you lowell.

Just two more questions.

1) You say that shared connections are also deployed. What about it the connections are not shared (if they belong just to that...

your project deploys SSRS reports and other objects(shared data sources, etc) and it stores the reports as xml in the ReportServer.dbo.Catalog table in [Content] column, which is a varbinary column...

Jeff Moden (12/28/2015)

---

If it turns out to not be setup and no one...

sp_help ENROLLMENT_IN is one way, you can scroll down to the foreign leys.

another way, you can use the metadata to find out the information;

select * from sys.foreign_keys WHERE object_id =...

another version, which takes into consideration if the birthday has passed or not:

DECLARE @DOB datetime

SET @DOB='1962-12-11'

SELECT CASE

WHEN DATEPART(DY,GETDATE()) >= DATEPART(DY,@DOB)

...

to a high degree, every snippet of code is written with automation in mind. i think that's probably a best practice where possible.

today might be six servers, but tomorrow, what...

it would really depend on the database. you'd want to keep track of the sizes some diff packups of the db over time for a while.

if the database just...

i adapted and created some sample data.

Declare @MyDay datetime = '2015-01-01'

;With MYFirstNames(FName) AS

(

Select 'Leonardo' UNION ALL

Select 'Brad' UNION ALL

Select 'Arnold' UNION ALL

Select 'Mark' UNION ALL

Select 'Matt' UNION ALL

Select 'Bruce'...

if StartShift and EndShift are DateTime data types, you can just use Datediff to get the period of time.

SELECT DateDiff(minute,StartShift,EndShift) from yourtable.

if it's a TIME data type, you have to...

i think the OP might be copy/pasting from the Powershell ISE and getting whitespace tot he right of the values, but that's a product of the results panel, and not...

i've done this with excel automation, which you can do in a script task,

this is a rough example i modified, but I did not explicitly test against your file.

basically, i'm...

you have to create the table explicitly, and then insert into the table; you cannot take advantage of the INTO #temp without jumping through extra hoops using openquery / openrowset

CREATE...

what specific error do you get? also look in the SQL error log for a detailed error instead of an "ended in...

i have a couple of model DDL triggers that execute as specific users; i think that's the way...

i think you'll need EXECUTE AS OWNER in the trigger; otherwise it's the end users context, i think, who might not have access to msdb, and thus the ability to...