Viewing 15 posts - 136 through 150 (of 1,079 total)
You shouldn't have issues, just keep in mind, the databases will be upgraded during restore on 2014, so keep the 2008 backups until your migration is signed off as successful. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 24, 2017 at 8:04 am
exec msdb.dbo.sp_send_dbmail
@profile_name = 'DBAEmailProfile',
@recipients = 'DBA@mail.com',
@subject = 'MonthlyReportData',
@body_format='HTML',
@query_result_header=1,
@execute_query_database='productsDB',
@query =
'SELECT productid, price FROM dbo.product'
@query_result_separator=' ',
@attach_query_result_as_file = 0,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2017 at 1:52 pm
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2017 at 8:39 am
Turn off UAC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2017 at 8:34 am
Fail on individual basis.
Yes, all endpoints double checked.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2017 at 8:30 am
Please post DDL and sample data.
From what you posted, your input field is date type, but once you concatenate it, will lose date for the entire string.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 14, 2017 at 2:39 pm
Also review best practices:
http://download.microsoft.com/download/8/F/A/8FABACD7-803E-40FC-ADF8-355E7D218F4C/SQL_Server_2012_Security_Best_Practice_Whitepaper_Apr2012.docx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 14, 2017 at 6:47 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 13, 2017 at 1:44 pm
Sounds strange.
Test one server by deleting the secondary and populating it from the Primary maybe?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 13, 2017 at 11:52 am
Slight incomplete error information, but check if you have access to the folder and files to begin with.
Just because you can browse to the folder where the MDF and...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 13, 2017 at 9:41 am
What is happening in your Windows cluster and quorum when you perform the shutdown?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 10, 2017 at 8:07 am
You are not inserting EmpRecordNum nor EmpReferenceNum nor EmpStatus into #TEMP, so it is not available for insert into #temp2 (t2), which makes it unavailable for your comparison. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 10, 2017 at 7:25 am
I am sure you can, however I would create a folder for each cluster and separate the actual FSW paths from each other.
Since it's only a file share, the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 9, 2017 at 11:30 am
You'll need to update your column values.
UPDATE Inventory_TagAlongs
set TagAlong_ItemNum = 'CRV- Under 24oz'
where TagAlong_ItemNum IN ('FS CRV- Under 24ozNT','FS CRV- Under 24oz')
Important....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 7, 2017 at 9:14 pm
Post DDL statement and sample data insert statements to ensure get responses.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 7, 2017 at 7:51 pm
Viewing 15 posts - 136 through 150 (of 1,079 total)