Viewing 15 posts - 1 through 15 (of 21 total)
October 10, 2017 at 9:32 am
The query that got me the above resultset
Declare @unuseddbs Table([last_read] NVARCHAR(255), [last_write] NVARCHAR(255) )
INSERT INTO @unuseddbs
EXECUTE master.sys.sp_MSforeachdb 'USE [?]; WITH agg AS
(
SELECT
October 10, 2017 at 8:43 am
October 10, 2017 at 8:42 am
October 9, 2017 at 8:15 am
September 29, 2017 at 8:04 am
February 13, 2017 at 5:36 pm
Eirikur Eiriksson (10/22/2016)
MVP_enthusiast (10/22/2016)
October 22, 2016 at 6:39 pm
Jeff Moden (10/22/2016)
October 22, 2016 at 6:35 pm
kfewer (12/28/2009)
Finally success! It turned out to be a missed configuration step: Setting the public profile as "Default". Thanks everyone for your help!
Hello! what do you mean when you say...
October 12, 2016 at 9:39 pm
Mladen Krstonosic (10/27/2008)
here is what i did,
select * from openquery
(LINK_LINUX, 'SELECT id, inf_date_open, inf_date_clos, inf_prob_type_no,
CAST(inf_prob_desc AS varchar(4000)) AS inf_prob_desc,
...
September 19, 2016 at 10:13 am
I appreciate your response but I'm not really sure how you intended for me to use that. Can you make it a little clearer for me? I appreciate
August 26, 2016 at 11:38 am
Beatrix Kiddo (3/3/2016)
amickey84 (3/2/2016)
I've been tasked with restoring a backup of a prod db to a shell db on another instance.
Hi- I'm not really sure why you're referring to a...
March 3, 2016 at 5:28 am
Orlando Colamatteo (2/16/2016)
TheSQLGuru (2/16/2016)
sp_job_start is the sproc IIRC....
February 16, 2016 at 11:26 am
Orlando Colamatteo (2/16/2016)
Suggestion: make...
February 16, 2016 at 6:54 am
Viewing 15 posts - 1 through 15 (of 21 total)