Viewing 15 posts - 406 through 420 (of 1,079 total)
Hi Charlie, no. You will have to migrate the structure and data from the 08 to a 05 database.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2012 at 7:34 am
Which edition is your windows?
If STD, then thats your problem..
http://technet.microsoft.com/en-us/library/dd443539(v=ws.10).aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2012 at 7:30 am
Depends a lot of the type of industry you're in, your clients and their business operation hours, how much they are willing to spend on overtime, and whether they see...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 11, 2012 at 11:03 pm
Were these IP's randomly selected, or are they reserved and assigned for static use on your cluster?
Sounds like DHCP behaviour, but 5minutes sounds a bit short for renewal.
Wait for others...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 11, 2012 at 11:01 pm
Since you need ALL the work done on your behalf, contact a good consulting company who will be more than willing to charge you for a full implementation and documentation...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2012 at 5:41 am
Ok perfect, lets add a twist to it..
I've got different Codes as well.
The cte so far only returns rows for the same Code.
Keep in mind my ID, CODES do...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 2, 2012 at 2:05 am
ColdCoffee (3/1/2012)
Here is my stab at the issue
; with cte as
(
select id,currmonth,nextmonth, monthly,startval , cast( (monthly * 2.00)...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 2, 2012 at 12:16 am
Erm....the answer options were incorrect. only 1 option was correct.
select * from sys.dm_service_services --<-- As in the question, this doesnt exist
select * from sys.dm_server_services --<-- As in the explanation, this...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 24, 2012 at 5:07 am
use BETWEEN...
select column where daterange between @startrange and @endrange
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2012 at 10:03 pm
Your answer states:
Correct answer:
Query sys.dm_service_services, Query sys.dm_server_registry
Explanation:
After SP1 for SQL Server 2008 R2, there is a new DMV that allows you to query for the service accounts...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2012 at 8:57 pm
After the comments, I think its safe to say:
Yes, model can be set to Read_Only
No, it wont affect new databases created?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 22, 2012 at 1:32 am
Please see screen shot of the test I did....I'm running R2....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 21, 2012 at 9:53 pm
handkot (2/21/2012)
Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 21, 2012 at 9:43 pm
So as it stands, your reply to Satish seems to me to be nothing other than inaccurate nonsense.
next time, I'll run it past you, to ensure it meets YOUR requirements.
I'll...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 20, 2012 at 10:26 pm
Must be authorized to work in the United States
🙁
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 20, 2012 at 9:51 pm
Viewing 15 posts - 406 through 420 (of 1,079 total)