We have the need to determine surrounding counties of a particular county.
For example how can I determine, if I entered a zip code for Contra Costa and the property is also right on the line of alameda that Alameda is a neighboring county of Contra Costa
Could it be determined by the longitude and latitude of the zip code in comparison with the counties?
The operation system is windows xp, and before i installed the SQL SERVER2005 the SQL SERVER2000 had installed.
the course of installing the SQL SERVER2005 has no error at all.
but i can not find the Database Engine under MSSQLSERVER from surface area configuration
==============
thank you in advance for any help
I need to show data for the top 3 zipcodes for EACH of the top 5counties. I feel totally blocked on how to make this work properly.Here is my code - anything you can suggest will be greatly appreciated:SET ROWCOUNT 5DECLARE @tblTopMarkets TABLE (StateCD CHAR(2), CountyCD CHAR(3))INSERT INTO @tblTopMarketsselectS.StateCD,S.CountyCDFROM DAPSummary_By_County SWHERE S.SaleMnYear > '01/01/2004'GROUP BY S.StateCD, S.CountyCD Order By Sum(S.Nbr_MTG) DESC-- the above works fine but next select produces only 3 rows;-- I need 3 times 5 rows (how to effect a "loop")SELECT TOP 3-- zips in a countyD.StateCD,D.CountyCD,D.Zip,"Nbr_Mtg"= Sum(Nbr_MTG)FROM @tblTopMarkets TLEFT JOIN GovtFHADetails DON T.StateCD = D.StateCD AND T.CountyCD = D.CountyCDWHERE D.SaleMnYear > '01/01/2004'GROUP BY D.StateCD, D.CountyCD, D.ZipOrder By Sum(Nbr_MTG) DESC
View 4 Replies View RelatedDoes anyone know if SQL7 will work with Storage Area Networks(SAN's)? I've read that SQL2000 implements something called a Virtual Interface System Area Network (VI SAN) that allows communication with devices connected via a SAN.
My site is installing a SAN and I need to know if SQL7 can utilize those resources (Storage,etc) and how reliable if so.
Randy
I have files with area codes that are several years old. Everything I've seen about updating area codes deals with area codes that are current and are about to split in the near future. How would I go about bringing old area codes up to date?
View 8 Replies View RelatedDear All,
i'm trying to publish a maintenance plan in sql server 2005.
but soon after right click and selecting a new maintenance plan, it is displaying an alert with "AgentXP's component" is turned off.
please let me know how to ON those services. i've read and followed the instructions but i was unable to find where exactly to start.
please guide me in this regard
my version of OS is sql server 2000 professional
my version of sql server is :Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Vinod
Even you learn 1%, Learn it with 100% confidence.
Hi, we are having a strange problem when trying to configure the surface area of my sql server 2005. When we open the tool the only nodes that appears are: Reporting Services and Integration Services. But the Database Engine node is not showing. What do we have to do to access the Database Engine node and configure Remote Connection.
Any help would be extremely appreciated...
Is it possible to display fields from 2 datasets in one table?
Up til now i've been working with Access, i have only got a few weeks experience with SQL, so dont eat me.
I set up a SQL Database, and placed it into my site, etc, set up all the connection strings. It connects fine, but cannot log in. It tells me;
Cannot open database "C:USERSJAREDDESKTOPSTYXSTYX - BUILD 2APP_DATASTYXDB.MDF" requested by the login. The login failed.Login failed for user 'Webdev01Jared'.
I'm running Vista (x86), and SQL Server 2005 Express SP2, and i'm aware that Vista by default does not automatically enable remote access in SQLExpress for local admins.
So i go into Surface Area Configuration. I've read about it, and it's two steps, Click "Add New Administrator", then select the priveleges in the left box and click the button to put them in the right box. Simple enough, and it works, sure, click the button, it moves across, done.
But. Hit OK. It's done nothing, i still cant connect, and the cherry on top; open up the SAC again to check and there is nothing in the right box. It's exactly how it was before i changed it. The problem is definitely this, and not the account, as i can log in for SQL Management Studio just fine, with the same windows authentication credentials.
Thanks in advance.
We are trying to determine what SQL Server 2000 Edition is required for our environment. We really don't need any of the features that Enterprise Edition offers over Standard Edition, except that our disk storage is on a System Area Network (SAN). BOL says that SAN is not supported under Standard Edition, but I am under the impression, that if we are not using distributed queries or replication, then Enterprise Edition is not neccessary.
Any help?
The data as it's recorded in the SQL table looks like this:
IDbatchdate_timecompany_namesymbolscore
4670713/11/14 9:30 AMJ.C. PENNEY COMPANY INC.JCP97
4670813/11/14 9:30 AMZOGENIX INCZGNX97
4670913/11/14 9:30 AMEXCO RESOURCES INCXCO93
4671013/11/14 9:30 AMMARVELL TECHNOLOGY GROUP LTDMRVL91
4671113/11/14 9:30 AMCABOT OIL & GAS CORPCOG90
[code]....
Basically what I'm after, I need to pull only the top 3 records based on score in descending order BUT these should be grouped by batch. For example, I need to select the top 3 records which have the highest score from batch 1, 2, 3, etc. where there could be any number of records in a batch and any number of batches.
Hi,
View 16 Replies View Related
Is there a way to set the default so that the parameter area is displayed by default when running a report in Report Manager. Currently you have to go up and hit the arrows to open the parameter area. I'd like it to be open by default.
Thanks.
We have some reports that allow null values for parameters and I find the "Null" label next the parameters in the report viewer to be completly the wrong thing i want to show to business users.
Has anyone worked out a way to change this label to something more meaningful?
aaron
Hello, I've installed SQLServer2k5 Sept CTP with the following config: W2K SP4 Pro, SQL2K5 Std Sept CTP complete clean install. Everything works except SAC for features. I get the error below when trying to start it. SAC for Services & Connections connects without problem and has local & remote connections via both TCP/IP and Named Pipes enabled for the server, and local & remote connections enabled for analysis services. All SQL2K5 components & services are started in the Services control panel. I've looked at port useage, wondering if some other process is using the port that SAC for features is pinging, but since SAC for Services & Connections works fine that doesn't seem to be culprit.
I also get an error when running the Tuning Advisor, saying it can't connect, but demoted that to just a warning by closing some extraneous connections to the servere (had >10 open). Still get a warning, but it doesn't prevent the Tuning Advisor from completing.
I've tried turning on and off various services, from Remote Registry Service to IIS, but no luck. Anyone know what else I chould check to troubleshoot this? Thanks!
Failed to connect to server localhost
Greetings,
Is there a way to force the parameter input area to always show even when default values are specified? I want to always display the parameter area even when I set initial parameters.
Thanks
Hi,
I would be very grateful if someone could help me. I have very little SQL knowledge and would like a push in the right direction:
I have a application that receives GPS lattitude and longitude values. I was originally using file base system where I would load all the points from the file into memory and do the calculations in the software but I now would like to use SQL Server Express.
I have created the tables:
[Table 1] GPS Points:
id int Primary key
latitude real
longitude real
desc nvarchar(128)
[Table 2] GPS Locations (comprises of one or more GPS Points from [1] above) to form a boundary:
GPS Locations database structure is:
locationId int primary key
gpspoint1 int
gpspoint2 int
gpspoint3 int
gpspoint4 int
desc nvarchar(128)
Table 2 contains up to 4 gps points ids from table 1 and GpsPoints1-4 can be null.
I have created the tables and I have inserted GPS values into both tables.
My problem:
I am trying to compare the current Lat/Lon (which are passed into the SQL fuction as two real datatype value) and I want to return all Table 2 locationId's where the current Lat/Lon are withing GPSPoints1-4 area.
gpspoint1, gpspoint2, gpspoint3, gpspoint4 reference an id from Table 1. I am not sure how I can do this?
I have implemetned a SQL function that returns all points from Table 1 that are within the predefined radius of 1.5 miles from the current Lat/Lon values passed in.
select desc,latitude,longitude, acos(SIN( PI()* @LatDec /180 )*SIN( PI()*latitude/180 )
)+(cos(PI()* @LatDec /180)*COS( PI()*latitude/180) *COS(PI()*longitude/180-PI()* @LonDec /180)
)* 3963.191 AS distance
FROM GpsPoints
WHERE 1=1
AND 3963.191 * ACOS( (SIN(PI()* @LatDec /180)*SIN(PI() * latitude/180)) +
(COS(PI()* @LatDec /180)*cos(PI()*latitude/180)*COS(PI() * longitude/180-PI()* @LonDec /180))
) < = Radius
ORDER BY 3963.191 * ACOS(
(SIN(PI()* @LatDec /180)*SIN(PI()*latitude/180)) +
(COS(PI()* @LatDec /180)*cos(PI()*latitude/180)*COS(PI() * longitude/180-PI()* @LonDec /180))
)
where 3963.191 is earths radius in miles,
radius is 1.5,
@LatDec is the current latitude and
@LonDec is the current longitude
Uses a lot of Trig and (for me) is quite complicated. This works very well and is very accurate. It also only uses a single table. I want to be able to now look for the current position within a boundary of 3 or more positions from Table 1 and this is where I am struggling?
Also, any suggestions on how I could do this better would be very much appreciated?
I look forward to your reply and help.
Thank you in advanced.
Hi,
I'm posting this in the Setup forum as I think the problem relates to my SQL Server Configuration. Being new to server management pls ask for more info if I don't explain this clearly enough, I'm running out of idea.
Here's the set up:
Windows Server 2003 Web Edition SP2
SQL Server 2005 Enterprise Edition SP1
When I try to run apps I get the following message:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I've found some great notes on the TechNet forums explaining this error and how to resolve it by configuring the Surface Area Tool... remote connections etc
But, this is where I draw a blank as I cannot access the Surafce Area Configuartion for Services and Connections because certain components are not installed, or I do not have admin rights. I definitly have the admin rights, but have no idea where to start looking for aforementioned components.
During the SQL Server install I recevied the warning:
SQL Service Edition System Compatibility - Some components of this edition of SQL Server are not supported on this Op system.
It sounds pretty generic and doesn't offer anymore details, but could this be effecting it?
I've also noticed that when I open SQL Server Configuration Manager and click on SQL Server 2005 Services nothing appears in the right-hand panel??? I'm sure there should be???
I've been all over TechNet & Books online and cannot find any reference for what I'm experiencing.
Any help or guidance will be greatly appreciated!
Thanks!
Does anyone know a way to force RS to not collapse the parameter area on a drill through? I searched this forum and found some related threads but nothing that covered this.
I have several reports where they drill through to each other and in all cases, while they pass the parameters between, the users usually want to go directly to different products or time periods within the reports. They constantly have to expand the input area every time they go to another report. This confuses a lot of them.
Is there a setting somewhere that controls this?
Thanks, Tim
Being very new to SQL Server, I have to ask - when I try to connect to SQL Server 2005 using TCP/IP I cannot. To accomplish this I was directed to use the Surface Area Configuration utility.
When I do this, I do not see the Database Engine the docks reffer to - any help/comments/suggestions?
Thanks,
Chris
When I brought up the BI DEV studio first tiem the Connection Managers area showed up, but after I closed it by mistake from next time on wards it is not coming up.
Can some one from this form help me how to get the Connection Managers area(pane) back?
Thanks in advance.
Regards
Mamidi
Currently studying for 70-229.I'm trying to understand how security for users is managed in SQLServer. I've been using SQL Server for a few years now, but withoutinvestigating the bits that "just work".So, here's the scenario. This is more or less how I create all myapplications (which these days are all ASP.NET).I have a database called "TESTDB" (original, huh?)Now, I want to create a method for users to access this database, so Iopen EM, locate and expand the node for the server containing thedatabase, and open the "Security" node. Click on the "Logins" leaf,and in the pane right-click and select "New Login.."On the "General" tab I enter "TESTDBLOGIN" as the Name.Select "SQL Server Authentication", and put in a password.In the drop-down list of databases select "TESTDBLOGIN"Ignoring the "Server Roles" tab, I go to the "Database Access" tab andscroll down until I can see the "TESTDB" database. Check the "Permit"checkbox, and lo!, the "Database Roles for TESTDB" list is populated,with "public" already ticked. I check the "db_owner" box, and press"OK". It asks me to confirm the password, and once that's done there'sa new login called TESTDBLOGIN. What's more in "Users" leaf in the"TESTDB" database node there's a new user called "TESTDBLOGIN".All well and good. I can now create a connection using this login anddo more or less what I want in the TESTDB database.But.If I click the "Users" leaf in the "TESTDB" node, there are two users -"dbo" and "TESTDBLOGIN". If I right-click the "TESTDBLOGIN" user, Ican see that it has Database Role Memberships for the "public" and the"db_owner" roles. But if I examine the permissions on these two roles(by selecting the row, and then pressing the "Permissions" button) Ifind that there are permissions set for EITHER role - all the checkboxes are blank!So, how is it that I can do SELECT, UPDATE, INSERT and DELETEoperations via this login/user?Sorry it all took so long - I just wanted to get it right.ThanksEdward--The reading group's reading group:http://www.bookgroup.org.uk
View 3 Replies View RelatedHi Dear
I have been trying to add SQL database to my web application and have to configure the SQL to allow remote accee.
I would like to start the Database Engine Service when I click on start button to start the service it dissplay following message:
An error occurred while performing this operation
Severa; time I restart the computer still, When I try it is same problem.
thank for yout help.
I have a matrix where i'm trying to have the report select the maximum value in the data area (not including the subtotals) and bold that value.
month
day1
day2
day3
day4
total
Jan
10
15
5
12
42
Feb
5
8
3
11
27
Total
15
23
8
23
69
I'm sure i will have to use the IIF function in conjunction with the InScope function.
However i'm unsure on how to isolate to the max value and make sure the Inscope function does not affect the totals.
any idea's are appreciated.
Has anyone customized the parameters area to pretty it up and make it more configurable like control number of columns etc?
Or can anyone direct me to a third party component?
Thanks.
When executing the Script Task, I get the error shown here:
http://www.webfound.net/buffer.jpg
I'm not sure how to resolve this.
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.buffercolumn(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.buffercolumn.maxlength(SQL.90).aspx
how do I change the maxlength of the buffer...if, that is the problem here?
I am getting the following error on my SSIS package. It runs a large amount of script components, and processes hundred of thousands of rows.
The exact error is: The value is too large to fit in the column data area of the buffer.
I redirect the error rows to another table. When I run just those records individually they import without error, but when run with the group of 270,000 other records it fails with that error. Can anyone point me to the cause of this issue, how to resolve, etc.
Thanks.
I have a variable nvarchar(1000) that I ma reading into the buffer of a data flow task in the script component script task. It gives me this error:
"Script component exception.........The value is too large to fit in the column data area of the buffer."
I looked at the BufferColumn members and tried to set the maxlength to 1500. But it does not help.
What is the solution?
I am currently running a Windows Vista Enterprise OS platform using SQL Express, whenever i add a user to the administrator group using the SQL Server Surface Area Configuration UI, each time i click on the link to add New Administrator, the previous administrator i just added still appears on the left - just as if i never added this user previously.
Is there a way around this issue? or is this a SQL Express problem, because i also tried doing it with SQL Server Enterprise edition on a Win2K3 SP2 box and it gives the same results.
Feedback is greatly appreciated.
Thanks
Sorry for the annoying. I would like to the configuration settings for the surface area. There's an option which able to let us change computer (whether is local computer or remote computer). Let say I put my own computer's name (Hans as example) for configuration as the remote compute, it's work fine to me. However, if I put my remote computer's name, it displays this error message to me.
Error :
Computer Tomato does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
I am sure that the remote computer is working since I am able to ping the remote computer and test on telnet as well. But why it seems that surface area can't detect my remote computer. Hope can get some resistance from everyone here. Thanx alot.
Best Regards,
Hans
Can someone tell me how to access the MaxLength property of a data column so I can figure out where the problem is?
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
Try
Row.PrimaryDiagnosis = Mid(Row.DiagnosisCode, 1, 8)
Catch ex As Exception
Row.Comments = "Error copying DiagnosisCode: <" + Row.DiagnosisCode + ">. " + ex.Message
End Try
Output = <aaaaa >
Thanks,
Laurence
I want to send mails from SQL Server 2005 Management Studio Express for which I referred to the article at http://www.databasejournal.com/features/mssql/article.php/3626056. I could successfully do the steps from step 1 to step 6 listed at the above URL. In fact, when I sent a test mail (as cited in step 6), SQL Server displays the message Mail queued though the mail didn't get delivered. The mail server address I am using is smtp.mail.yahoo.co.uk.
But when I expand the Management node in the Management Studio Express GUI, I don't find Database Mail as a child node. In fact, there are only 2 child nodes under the Management node - SQL Server Logs & Activity Monitor.
Why isn't Database Mail listed under the Management node? What am I missing here?
Also when I open Surface Area Configuration & then click Surface Area Configuration for Services and Connections, the following error gets generated:
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)
Additional Information:
The type initializer 'System.Management.ManagementPath' threw an exception. (System.Management)
Unable to cast COM object of type 'System.Management.WbemDefPath' to interface type 'System.Management.IWbemPath'. The operation failed because the QueryInterface call on the COM component for the interface with IID '(38C15AF2-736C-477E-9E51-238AF8667DCC)' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (System.Management)
When I click Surface Area Configuration for Features, it generates the error cited above but from the first bulleted list.
How do I overcome this error? I confirmed that Windows Management Instrumentation is running by opening Services from Control Panel ---> Administrative Tools.
I am on WinXP Pro SP2. Please note that I also have SQL Server 7.0 installed in my machine which is a standalone m/c.
Thanks
Hi, i'm new to reporting services, rather new to heavy processing in reporting services. i have scenario
for which i need your help. so here it goes,
i have a method in Code area of the report, i'm passing parameter values to it. the method willl return me a swl query in string format. i need to execute it in data tab area. the codei have used in data tab is as below. please let me know. wat to do to make it right. thx
EXEC ('Code.Main(Parameters!Param1)' +
UNION
+ 'Code.Main(Parameters!Param2) ' +
UNION ALL
+ 'Code.Main(Parameters!Param3)')
Thx again
i need to get this report done really soon, so please, if u have any idea let me know ASAP