Answer Questions

• Bryan O Cant locate SQL Server Express from client pc

  Hi, I have a 5 user network running SBS 2000. I have installed SQL Server Express on one of the client machines (not the SBS Server) I can connect locally without problem. However i cant connect from the other client machines. I have enabled TCP/IP, Remote Connections Etc I am attempting to test the connection using an .udl file. The server name is found but i still cant connect. Any help would be apreciated. ...Show All

• happymozart Access is Denied in Upgrade Advisor

  Hi all, I have run the SQL Server 2005 Upgrade Advisor against a default instance of SQL Server 2000 server running on Windows Server 2003. One thing I need to fix before I upgrade is: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED) SVCACCTREQ I'm not sure what this means or what I need to do before I can upgrade. Does anyone have a clue on this one. Thanks, David ...Show All

• Ethan W. modify procedure sys.sp_datatype_info

  Can we modify the sp_datatype_info stored procedure to return datatypes >=3 only in sql server 2005 Is it possible with SQL Server 2000. If it is not possible to modify/drop the procedure, is it possible to change the name resolution logic to be able to call the procedure in another (for example dbo) schema Any other possible way to achieve this Hi Umachandar, My objective is to modify sp_datatype_info to ...Show All

• Avi Gershon Select date year below 1950 not valid?

  i am doing a select statement, the .sdf database file has dates from 1910 to 2020 Dim fullcurrent_date As Date = New Date(1950, 10, 2) Dim sqlstr As String = "SELECT * FROM table WHERE Start_Month <= '" & fullcurrent_date & "'" it seems to work alright, but if i were to initialize the Date as Dim fullcurrent_date As Date = New Date(1949, 10, 2) it doesn't seem to work, is there a limit somewhere as long the year ...Show All

• Timpany Adding many templates at once

  I can’t find out how to put SQL 2000 templates that I’ve already created into SQL 2005, en masse. I don’t want to put them in one at a time. I’ve got 40 or 50 of them. Can you please direct me to the location I can paste them in and have them show up. I’ve tried this location, where the ones built-in exist: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql When I put my own f ...Show All

• Scriptfox not possible to export from the Report Viewer control -Error

  Hi, I am facing a problem, it working in few reports, but for most of the reports, i am not able to export from report viewr control. it throws up an error saying that Internet explorer cannot download ........ server name and it says IE was not able to open this Internet Site. The requested site is either unavailable or could not be found. Please try again later Quick Help is appreciated. suresh babu hi guys, ...Show All

• NUMBSCULL Distinct Count in a new Measure Group

  Here is the situation: I have a cube that has transaction level data and there is a control number that goes with this data, but it isn't one for one.  If I have 60 million rows in the fact table, I have 50 million control numbers in a control number dimension. I would like to be able to slice the data by date (for instance) and then do a distinct count on the control number dimension.  I can do a distinct count w.o having to do ...Show All

• PierreWT 2005 CTP Connection error

  When I try to connect to the 2005 CTP SQL server in any of the VBexpress software packages I get the gfollowing error user instance login flag not supported in this version of SQL I am not sure what to check or what I may have missed in the SQL server setup   The User Instance flag is only supported in the express SKU, are you connected to Express or another version of SQL Server You can check by running s ...Show All

• darinn Problems Using Temporary Tables

  I am declaring a temp table in control flow via Execute SQL task. I then want to use that table as a source in a data task, keep it alive going back to control flow and use it as a destination in another data task following. I am having trouble just getting the first data flow to access that temp table. In my Execute SQL task, I'm creating a simple temp table. After executing that task, I can head to the data task and change my OLE DB Source to ...Show All

• firstfruits Need to create <Query> statement programmatically

  I am creating a web application that uses a using a web service to get data for my reports. Since the webservice only accepts 1 parameter called "sql" (the sql select statement), I am using the report's query string to get the data. Here is the data source and dataset info I am using: DataSource Name: WebService Type: XML Connection string: http://localhost/myWeb/myWebService.asmx Credentials: No credentials DataSet ...Show All

• Maxim Langman Keeping track of last time of extract

  I am building an SSIS package in which I extract data from a number of transaction tables. The rows in each transaction table contain a timestamp. I would like to do the following. * Every time I extract rows from a table I want to extract only the records added since last extract (no rows are modified or deleted - only added) * In the extract process I want to find the maximum timestamp in a given table. This timestamp should be stored&nbs ...Show All

• benjycleyndert Second instance of Reporting Service cannot get to web page

  I am beginning to think I can't do anything right with Reporting Services. I was following Brian Welcker's web cast SS 2005 Reporting Services Management and Configuration. I have successfully created a second instance of RS (demo) and all is fine until I try to browse to the port 81 web site. I cannot see the web cast well enought to see what he changed in order to get to the demo site. http://localhost/reports get to the first instance of RS. ...Show All

• Tim F Equivalent to Shift+Enter in Management Studio result grid cell?

  Is there a way to insert a line break into a cell when view table in Management Studio In Enterprise Management it was Shift+Enter, but that doesn't work in SQL 2005. For example, we have a column that contains address format, so we need to have multi line data (line break). When viewing data alredy in the table in a grid view using query, line breaks are not visible, but if switched to text view, the line breaks are visible. Programaticly or ...Show All

• LuisCabrera Stored proc & transaction log size problems!!!!!

  For some reason, my stored procedure which is kicked off by VB.NET is growing the log file for the database in question by gigs, very fast. Why is it doing this The code: Sub Main() objConn.Open() Dim cmdSql As New SqlClient.SqlCommand("IT_sss_Collector_D otNet", objConn) cmdSql.CommandType = CommandType.StoredProcedure cmdSql.CommandTimeout = 1000 Dim reader As SqlDataReader = cmdSql.ExecuteReader() Dim ppa_rowcou ...Show All

• wingba DTS Legacy and SQL 2005

  I am in the process of migrating to a new SQL 2005 server. I have a number of DTS packages on my SQL2000 server, approximately 200, that are used on a daily basis. I used the migration wizard to migrate the packages from the 2000 server to the new 2005 server however there are issues with the way some were brought over. I would like to have all of the packages moved from the 2000 to the 2005 server and appear under Legacy DTS so that I can r ...Show All