Need hand holding

Getting started with SQL Server

Index ‹ SQL Server

- Previous
  - 1
    - Trouble Installing Reporting Add-In for Microsoft Visual Web Developer 2005 Express Hi Folks I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message: "There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor" Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing. Any ideas, please Thanks Andrew Tag: Need hand holding
  - 2
    - xquery query path without elements The Demographics xml data type column in AdventureWorks. Sales . Store contains the row sample below. How would I write the path for Demographics.query() to retun all rows with AnnualSales >=300000 I'm using variations of this statement but can't find an example of a path without elements. SELECT demographics . query ( 'declare namespace AWMI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"; / ' ) as Result FROM Sales . Store < StoreSurvey xmlns = " http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey " > < AnnualSales > 300000 </ AnnualSales > < AnnualRevenue > 30000 </ AnnualRevenue > < BankName > International Bank </ BankName > < BusinessType > BM </ BusinessType > < YearOpened > 1970 </ YearOpened > < Specialty > Road </ Specialty > < SquareFeet > 7000 </ SquareFeet > < Brands > AW </ Brands > < Internet > T1 </ Internet > < NumberEmployees > 2 </ NumberEmployees > </ StoreSurvey > Tag: Need hand holding
  - 3
    - Hotfix for Bug # 473675 (SQL Server could not spawn process_loginread thread) Hi, I get " SQL Server could not spawn process_loginread thread." errors. This is related to a bug in SQL 2000 and there is a hotfix for SP3a. I am running SQL2000 with SP4. I checked the fix list of SP4 & this bug is not fixed in this SP4. Can I apply the hotfix to resolve this problem on my server tia. Tag: Need hand holding
  - 4
    - EXEC in WHERE clause I wanted to have something like SELECT * FROM refs1 WHERE (EXEC ref_id) = this.id Should I turn the SP into a function Tag: Need hand holding
  - 5
    - Linkserver connection fails between SqlServer 2005 and Oracle 10g This is what I did: The instructions for changing the registry entries per previous MSDN postings were: For Windows 2000 Oracle 8.1 [HKEY_LOCAL_MACHINE\SOFTWARE \Microsoft\MSDTC\MTxOCI] "OracleXaLib"="oraclient8.dll" "OracleSqlLib"="orasql8.dll" "OracleOciLib"="oci.dll" Changed the registry entries on my WindowsXP machine: entry name old value new values "OracleXaLib" xa80.dll oraclient10.dll "OracleSqlLib" sqllib80.dll orasql10.dll "OracleOciLib" oci.dll oci.dll Then created the Linkserver definition: EXEC sp_addlinkedserver 'ORA10G', 'ORACLE', 'MSDAORA', 'ORA10G' Command(s) completed successfully. EXEC sp_addlinkedsrvlogin 'ORA10G', 'FALSE',NULL, 'scott', 'tiger' Command(s) completed successfully. Note: scott/tiger is given as an example here; used my real userid/pw instead. BTW, I am able to connect to the Oracle database using the userid/pw from the same host that is running the Sqlserver db.So, the Oracle client software is installed and is working correctly. Then attempted to query a table on the Oracle database: select count(*) from ORA10G..<schemaname>.<tablename> Got the following error message(s) OLE DB provider "MSDAORA" for linked server "ORA10G" returned message "ORA-12154: TNS:could not resolve the connect identifier specified ". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "ORA10G". All the previous discussions and suggested solutions are all for SqlServer 2000 and Oracle8. But I did not see much discussions on SqlServer2005 and Oracle10g. Any help to resolve this problem will be appreciated. Thank you. Tag: Need hand holding
  - 6
    - OUTPUT - help with please I am using a dynamic t-sql string in proc1 to execute proc2, which returns an int variable named @Fatal_Error back to proc1. When I execute proc2 I use the syntax: EXEC @SQL @Params @SQL is the Proc Name (varchar) and @Params is the parameter string (nvarchar). If I include the @Fatal_Error variable in the dynamic creation of the @Params string the returning value from Proc2 is unable to convert int to nvarchar. I have declared @Fatal_Error in proc1 as int and tried to add to the end of my dynamic t-sql EXEC but I still get 'Cannot convert int to nvarchar' . Please help - I'm beginning to pull out hair! :-) Thanks! Here' s the syntax I tried when just passing it at the end of the EXEC call: EXEC @SQL @Param_List = @Fatal_Error AND I also tried: EXEC @SQL @Param_List + ' '+@Fatal_Error+' ' Tag: Need hand holding
  - 7
    - problem with Stored procedure hi everyone... Iam new with stored procedure in Sql 2005 so iam facing a problem which i need to get the result of query to store in an sql output parameter here is my SP : ALTER PROCEDURE [dbo].[CheckUser] ( @Id nvarchar(50) , @Pass nvarchar(50) , @Exist int output , @Type char(1) output ) AS BEGIN SET NOCOUNT ON; -- Insert statements for procedure here declare @tt int declare @char char select @tt=count(*) from Users where Id=@Id and Password=@Pass select @char=users.Type from users where Id=@Id and password=@Pass set @Type=@char set @Exist=@tt END so i would to retrieve the results of the 2 queries & store them in @Exist & @Type.. how can i do that Tag: Need hand holding
  - 8
    - Creating an Windows Rdl on the fly using .net programming Hi, I would like to know that can I create an .rdl file programmatically based on the user selection (USING .Net programming) . Please help with some link / examples. P.S: I am giving very less number of static reports to the client. I want to give a more of a dynamic report , wherein in each case, I will give the user a selection criteria to select the fields from the front end (say ASP.Net page) and those fields along with the relevant data will be generated in the report and will be displayed on the user’s screen. IS THAT POSSIBLE WITH MSSQL 2005 AND .NET 2005 Kind Regards Pratik Tag: Need hand holding
  - 9
    - XML columns failing to Replicate I am using Push Merge Replication. I am seeing some very disturbing behavior related to the xml datatype. An insert into a table with an xml value seems to consistently fail to replicate the xml value. The row is replicated, but the xml column is null. Also updates to an xml column do not always get replicated. Is this a known problem I cannot stress how big a problem this is for my business. Tag: Need hand holding
  - 10
    - distinct query for table containing records more than 69347 What would be the best way to avoid distinct clause in query to get the result.My Query looks like select distinct Col1 ,col2,col3,col4 from ABC where (1=1) group by Col1 ,col2,col3,col4 order by col1 ABC Contains records like Col1 col2 col3 col4 a 1 1 1 a 2 1 1 B 2 2 2 B 1 1 1 ; ; ; how is the performance of disticnt query on Number of Rows HOw can i Improve my query performance if want to use distinct in my query will adding indexes help to boost performance Thanks Tag: Need hand holding
  - 11
    - Checking for records where One value is NOT in the other? I am trying to display results in which a value in my first result table is NOT contained in the second result table. Any idea on how to do this . SELECT CUSTOMERID, CUSTOMER FROM TABLE1 WHERE CUSTOMERID NOT IN TABLE2 Tag: Need hand holding
  - 12
    - Property IsLocked is not available I'm running Vista Ultimate x64 and when I tried to connect to my 2005 database using SQL server authentication it gave me an error. When I went to the management studio to check on the login it said this: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=IsLocked&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Has anyone ever seen this before and know how to solve it Tag: Need hand holding
  - 13
    - Store currency and volume in database We are creating an enterprise application for fuel, and I am fighting with my DBA about the proper way to store volume and currency in the database. We have 2 main arguments. The first argument is whether we should store costs in the database in $ and convert in the presentation layer, or to store the amount and currency in the database. We sell product from the US in dollar but depending on the customer we may invoice in Euro. Our second argument is the same, execept with volume and UOM. We often purchase product by BBL but sell/transfer by gallon, or Ton. please tell us the best practice for our d ilemma. Tag: Need hand holding
  - 14
    - Deploy Reports via Visual Studio 2005 This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services. I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out" When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio. Thoughts Thanks Tag: Need hand holding
  - 15
    - Question on Row Count Transformation Hi all, i'm using Row Count Transformation downloaded from http://www.sqlis.com/93.aspx to generate surrogate key. in my data flow, i have OLE Data Source connected to Row Count Transformation connected to SCD. i've configured ok and the package ran without error. my problem is my surrogate key column won't generate the next increment number if i run the package the 2nd time and there is new row in the dimension, e.g. Id BusinessKey BusinessName --- ------------------ --------------------- 1 RDO Radio 2 MAG Magazine 3 TV Television 1 INT Internet } added new row from source did i miss something please help. thanks. Tag: Need hand holding
  - 16
    - Installing Sql Server 2005 Enterprise on Windows XP pro I am trying to install 2005 sql server enterprise edition on windows xp pro, When I get to the part where you pick which components to add, they are all grayed out except for workstation components and books. What did I do wrong Tag: Need hand holding
- Next
  - 1
    - When to use a Nested Table? Why would someone choose to model a problem with a case and nested table versus just using a case tables with multiple rows For example, a simple customer and product scenario where you could say: Mining Model DT_CustProd ( [Id] , [Gender] , [Age] [Products] Predict ( [ProductName] , [Quantity] ) ) But you could also model as: Mining Model DT_CustProd ( [Id] , [Gender] , [Age] [ProductName] Predict, [Quantity] Predict ) and just insert multiple rows per Id/Gender/Age Is there any rule of thumb to use here when deciding to model with a nested table I understand that a nested table essentially pivots the data ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=408840&SiteID=1 ) and the data becomes an attribute, but how do you know if you want that, or you want the data as a value of an attribute Tag: Need hand holding
  - 2
    - SQL Server 2005 Install fails on Vista During the install, I get the following message: Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt. I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it. I tried downloading 2.0 and installing it, but it says that its allready installed. I was able to install Visual Studio with Sql Server 2005 express. I am stuck. Is the case that Sql install dosent know about the latest version of 2.0 that came with vista Tag: Need hand holding
  - 3
    - error hi i have one varchar field i m convarting that field to datetime in format of dd/mm/yyyy but i m getting eror select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr, convert(varchar(10),cast(AdditionalField5 as datetime),103) 'ValDate' ,AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalField21 'Drawer Name' from Tbl_CMS_UploadDetails with(nolock) where Compare_Status='Pending' and ltrim(rtrim(CMS_Upload_Details_ID)) not in (select top 0 ltrim(rtrim(CMS_Upload_Details_ID)) from Tbl_CMS_UploadDetails with(nolock) where Compare_Status = 'Pending ' and Format_ID =83)and Compare_Status='Pending' and Format_ID =83 error is Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Tag: Need hand holding
  - 4
    - Sub_Report on field details Table Hello, I'm French, so sorry for the faults. I want to make a report with a table who gives some figures of a family and elements of her subfamily. For example, for the Fruit family I have like subfamily the apple, the pear, the banana. I tried to make a table with a group but to aggregate some figures of the subfamily dataset, calculations are complicated. So I make two report: - one for a dataset for the subfamily with a parameter (the family). - one for the dataset of the family. In the second, I want to put the under-report (the first) in the details of the table while passing in parameter the family. But, I have an error when I want to see the result:" Error: Impossible to post the under-report." If you can help me that would be sympathetic! Thanks Mickael Tag: Need hand holding
  - 5
    - Few questions on INDEXES. Dear Experts, I have few questions on SQL Server indexes. Example : There is a table Table1 with columns col1,col2,col3,col4,col5. Q#1 There are below non clustered indexes on the table Table1 1. IDX1 ON (Col1, Col2, Col3) 2. IDX2 ON (Col2, Col3) 3. IDX3 ON (Col2) 4. IDX4 ON (Col3, Col4, Col5) 5. IDX5 ON (col5) 6. IDX_PK ON (col1) is Primary key and IDENTITY. Does these indexes makes sense That is , do we need IDX3 when IDX2 could be used for searching col2 do we need IDX5 when IDX4 could be used for searching col5 Q#2 In case if I need to make the fill factor to 90 % , should I do it on all the indexes or only on the PK IDX_PK Q#3 Assume this table is write intensive. As the column col1 is Primary Key with IDENTITY property , should I still have the fill factor made as 90% changed from the default 100%. That is, does the fill factor comes to help even if there is an IDENTITY column. Thanks for your time & responses in advance. DBLearner Tag: Need hand holding
  - 6
    - Not able to sort UDTs in DatadridView Control. Hi All, I have deployed UDTS in SQLserver and i am dsplaying data in datagridview control of the table which contains columns of UDTs. Till time everthing is ok. But problem is All other columns sorting is working properly but UDTS column sorting by doing Columnheader click is not working and firing an exception like System.Data.DataException occurred Message="Type 'MCSTypes.AlarmState, MCSTypes, Version=5.5.5.5, Culture=neutral, PublicKeyToken=null' does not implement IComparable interface. Comparison cannot be done." Source="System.Data" StackTrace: at System.Data.Common.SqlUdtStorage.CompareValueTo(Int32 recordNo1, Object value) Efforts I made :- I have implemented IComparable interface but still its not working. even i have tried my own sorting on datagridview but It is required that DatagridControl should not contains any data source and i have table as datasource. so that is not helpful. Problem Prediction: I think the problem is with UDTS as they are not using IComparable for Comparison. UDTS are using some sqlserver native comparison and thats the problem. All suggestions and workarounds are welcomed. Thanks in Advance. Manoj Tag: Need hand holding
  - 7
    - how to use non-basic AscII character in Stored procedure parameter hi all, I have a stored procedure with a input parameter ( xml block). sp: spGetAddr @xmlText the style of parameter @xmlText looks like <Param RestricBy="UserName IN ('May a ', 'Bob')"/> If I use non-basic ASCII character, just like ' a ' in the parameter, the execution fails and I get 'The error description is 'An invalid character was found in text content.'' But this kind of special characters should be allowed in the name column of the database table. If I use the htlm code '&#xE1" to replace ' a ' in the parameter, then the execution of the stored procedure is fine. but how can I change all of the possible sepcial characters If somebody knows how to handle this issue, please help me. I'm pre-appreciated for all the idea and suggestion! Thanks, Jone Tag: Need hand holding
  - 8
    - What version: Enterprise manager or Management Studio Express This may be a dumb question but I have searched and haven't found an answer to it here yet. We are planing to get SQL Server 2005 for a specific purpose.We have several existing stand alone SQL Server 2000 database servers already. I have Enterprise Manager (2000) client installed on my PC. I recently installed SQL Server Express (2005) on my PC to get to know about new features. I have run into problems (BCP specifically) with having two versions of C:\Program Files\Microsoft SQL Server\80\... and C:\Program Files\Microsoft SQL Server\90\... on my PC. Is there any point before or after we purchase Standard version of SQL Server 2005 when I can do away with C:\Program Files\Microsoft SQL Server\80... and/or uninstall Enterprise manager In other words can I manage SQL Server 2000 databases using only Management Studio(SQL Server 2005 client) If not, how do I manage the two different versions of the client software on a single PC. Thanks, Dave K. Tag: Need hand holding
  - 9
    - Semantic Model Hello, I got the following error while trying to create a report model: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3. (rsModelingError) (Report Services SOAP Proxy Source) ------------------------------ For help, click: http://go.microsoft.com/fwlink/ LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsModelingError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00 ------------------------------ Program Location: at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GenerateModel(String DataSource, String Model, String Parent, Property[] Properties) at Microsoft.SqlServer.Management.UI.RSWrapper.NodeDataSource.GenerateModel(String name, String folderpath, String description) at Microsoft.SqlServer.Management.UI.RSUserInterface.DataSourcePropertiesGenerateModel.OnRunNow(Object sender) at Microsoft.SqlServer.Management.SqlMgmt.PanelExecutionHandler.Run(RunType runType, Object sender) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender) I've searched every forum and every page from microsoft but couldn't find a single reference about this problem. I don't know what to do and I really need to get this model working fine for report builder Can you help me Andre Tag: Need hand holding
  - 10
    - SP2 installation problem when mssqlsystemresource has moved Hello. I recently moved all the system databases from their default location to different drives. I keep my .mdf files in E:\SQL MDF\ and .ldf files in F:\SQL LDF\ and all has been running fine until SP2 came along. I Installed SP2 and the database services part failed. All other parts were sucessful but I could not re-start SQLServer. On examination of the event log the reason why it wouldn't start is because the mssqlsystemresource .ldf did not match the .mdf file. This is strange I thought because I had sucessfully altered the paths for the mssqlsystemresource database and re-started SQL many times to test that the new paths were correct. However, when I checked the contents of both the SQL MDF and SQL LDF file folders i discovered something interesting. In the SQL MDF folder, there was now a mssqlsystemresource.ldf file and it had the same modified date as the mssqlsystemresource.mdf file. In the SQL LDF folder there was also a mssqlsystemresource.ldf (which there should be, because this is the original .ldf file which SQL had been using ) although the modified date was earlier than the one contained in the SQL MDF. This has made sense of the error messages in the event log because it looks as though something in SP2 alters the mssqlsystemresource database but it is not putting the .ldf file in to the folder I specified so SQL wouldn't start. Now the obvious question would be had I actually got the paths right! So to prove this I copied the updated .ldf file from the SQL MDF to the SQL LDF folder and SQL started sucessfully, thus proving the path was correct. I have now replicated this problem on another server aswell. My next question is, can the service pack now be classed as having installed correctly as the build number of the database engine is now 9.0.3042 even though the installer "failed" I'd appreciate any comments or thoughts on this as I have 5 production servers to apply SP2 to and I'm pretty sure I'm going to get the same problem and even though I know how to fix it, it would for once, be nice to have one installation of SP2 run from start to finish with no errors. Thanks Tag: Need hand holding
  - 11
    - Use Sql To Run Export Wizard?? Is There any Command that can run the sql server export wizard and configure the setting of this wizard in order to export data to .txt file Tag: Need hand holding
  - 12
    - Upgrade from SQL CE 2.0 to 3.1 We have numerous clients that have been using 2.0. And we are now planning to upgrade everything to 3.1. Of all the 3.1 dll files, which ones do we need to have on the device And does anyone know of any problems with doing such an upgrade -Thanks, Kris Kline kris_kline@hotmail.com Tag: Need hand holding
  - 13
    - sometime ADODB return No result to Excel Hi all, I have a strange situation. I use VBA to call a MSSQL server 2000 to get data from one of the DB inside, using ADODB. My problem is, the DB is around 20GB, and if we get data from it for few days, say 7 days, is fine. When I come to trying get more data like 1 month, the excel returns no data after waiting for about 30 sec. The query is actually calling a stored procedure on the server side to return data. I have add connectiontimeout=10000 to my connection string but still not working... I run the same execute statement in query analyzer on the same machine using the Excel and it is fine. Around 2 minute waiting I can see my data. But in Excel, never. Anyone can offer some helps to me Thanks alot. Tag: Need hand holding
  - 14
    - Flat file source not communicating with script component properly Hi there, I have a flat file source in my data flow that is suppose to feed through a couple of columns to a script component. All of the columns have data but when I debug in my script component (with the aid of messageboxes) I can see that one of then is empty. This is wrong because when I preview that data in the flat file source, I can see that the columns are all populated. Has anyone ever encountered that a flat file source doesn't communicate with a script component properly I mean it does pass through the data of all other columns except for one. I have replaced the components in case it had become corrupt and I even rebuild the package but the problem still persists. Any advice would be welcome Regards Mike Tag: Need hand holding
  - 15
    - constrains on table subsets Hello! I'm looking for some ideas about how to ensure constraints on multiple rows. Of course one can use stored procedures and/or triggers while inserting. Other ideas The reason for this question is that it could be hard to ensure, because if lock level is not high enough, you can get duplicates during concurrency, if lock level is too high, it can result in deadlocks. Thanks Tag: Need hand holding
  - 16
    - need decimal data after division HI, when i divide 2 nos i need the result in decimal. always the fractional part is truncated how to get it. venp-- Tag: Need hand holding

Douglas_W_Roberts

Hi -
Is there a resource I can go to that lists people who I pay to talk me through stuff like getting SQL Server Express installed, get some sample data input and then get that data into Excel I just cannot seem to get any help that works for me to learn SQL Server; the books are obtuse, the online help too indirect. Once I get something working I hope to enhance it on my own, but I have been stuck at the start for a very long time. There is stuff for me to do that is not getting done.

Doug

Top

Re: Need hand holding

Sam Lester - MSFT

Hey Doug, what part are you currently stuck on My suggestion would be to install Express with Advanced Services since it has a set of GUI management tools that will make life much easier.

You can find that install here:

https://www.microsoft.com/downloads/details.aspx familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

Once you install it, you can download the SQL 2005 sample databases from here:

https://www.microsoft.com/downloads/details.aspx familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

For more info on samples, you can check out the samples blog here:

http://blogs.msdn.com/bonniefe/default.aspx

As for exporting data from Express to Excel, I don't have much experience. You can start with Euan's blog here:

http://blogs.msdn.com/euanga/archive/2006/07/20/672272.aspx

If that doesn't work, you can post directly to the SQL integration services forum.

Thanks,
Sam Lester (MSFT)

Top