Viewing 15 posts - 826 through 840 (of 1,079 total)
Nice to know! one more question: is your sa account enabled and what is the password? 😛
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 29, 2010 at 11:05 pm
No matter what the answers, testing on production servers is never a good idea.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 29, 2010 at 11:03 pm
When posting questions, be sure to post more and detailed information in order for us to assist you faster and better.
Do you have an ID column? or any column with...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 29, 2010 at 11:01 pm
If you can drop down the DB's, Tables etc, its obviously online.
Some times remote servers take a while to display the color status.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 29, 2010 at 2:32 am
confused....
What was the question?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 29, 2010 at 1:58 am
Noted, and thank you for the feedback.
SELECTt.name as [DB Name],
t.user_access_desc as [Access State],
t.state_desc as [Online/Offline],
((SELECT (CASE t.is_in_standby WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' ELSE 'Other' END))) as...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 22, 2010 at 9:35 am
try it like this on both:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SELECT LEN('TEST')
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 22, 2010 at 9:32 am
Have a look at these:
http://www.microsoft.com/sqlserver/2008/en/us/spatial-data.aspx
and
http://blogs.technet.com/andrew/archive/2007/11/26/sql-server-2008-spatial-data-types.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
April 22, 2010 at 9:30 am
and if you run:
Select Datalength('Ather') ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 22, 2010 at 9:20 am
Port 90 as you used is fine.
It's a port specific to the website hosted on IIS, and is only used to point and identify the different websites running on...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 22, 2010 at 9:14 am
Yes, and no.
run this to rename the server name:
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 22, 2010 at 9:08 am
right here on SSC 😀
or
http://www.microsoft.com/sqlserver/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 22, 2010 at 3:25 am
nevermind......misread your question....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 21, 2010 at 9:32 am
select name, state_desc from sysdatabases
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 19, 2010 at 11:28 am
not a very descriptive post, but...
try using "." as your server name, just a dot.
and make sure SQL Services are running....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 19, 2010 at 8:55 am
Viewing 15 posts - 826 through 840 (of 1,079 total)