Answer Questions

• isaacd SQLExpress Problems

  I just installed Visual Studio 2005 Professional a couple a weeks ago, I have been playing around with the Personal Web Site Starter Kit it has to learn how the .NET interacts with the SQL Server. Everything was working fine even was able post the site on the WEB and have my friend and I log in and use it. My Issue is I messed up the SQLExpress , I am about at the point I want to completely start from the beginning and re-install the OS but I ne ...Show All

• India62 Excel pivot table

  Hi, I have several pivot tables in Excel that access data to a SQL 2000. We install SQL 2005, we change the ODBC from the 2000 server to the 2005 server. Now when we try to run the pivot tables I've got the following message: "User 'public' does not have permission to run DBCC TRACEON" Any idea on how to fix this problem Thanks, Arty updade your Excel to Excel XP. it will connect to SQL2005. ...Show All

• DragonSpeed Can't Connect to Reportserver using Management Studio

  Dear Anyone, I am having trouble connecting to the report server using SQL Server Management studio. Whenever I try to connect to the report server, I get the following error. Request failed with Http status 502: Bad Gateway. (Microsoft.SQLServer.Management.UI.RSClient What puzzles me is that I am using the SQL Server Manager on the local server using the local admin account. I've tried connecting to the server using both the server nam ...Show All

• JB Metrics How Can I Do This Better in SQL 2005?

  I have two tables, one contains ids(very small, less than 100) and the other contains history(very large, over 1000 mil); table a (id int) table b (id int, contact_datetime datetime, id2 int, id3 int) I need to pull latest contact date and other id fields from table b fastest possible. in 2000, I did following sql query, select a.id, b.contact_datetime, b.id2, b.id3 from table a inner join table b on b.id = a.id where b.c ...Show All

• Kevin Buchan Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?

  I'm trying to find ANY examples of using the Microsoft.SqlServer.Management.Trace namespace. What I'm looking for is an example of being able to create and initialise a new trace, haing this processed on the Server, and then initializes some sort of traceReader against this. e.g the equivalent of:    MyTraceConnection = new Something ("localhost");    MyTrace = new SqlTrace (CaptureTSQL || CaptureLogonEvent || CaptureLogoutEv ...Show All

• Mougenot Empty Space between two tables

  I have placed two tables from the toolbox onto the report. Filled the two tables Table A, Table B with data from the database. When i run the report I want the Table B's data to be appended to Table A's data. But, when I tried to do this, there is lot of empty space between two tables's data. How can i get rid of this empty space. Thank You so much. I don't understand why you separating data in 2 tables. It's ...Show All

• JoLee [Resolved] How to insert a byte() to a blob column?

  Hi everybody,     I don't where to asked this question in this forum. How do you insert to a column of a table with a blob or binary datatype if there is one, from a byte() datatype  What is wrong How can I fixed this I need help. Thanks. Code: string sqlText = "Insert table1(id, dataByte) values('" + id + "'," + byteData + ")"; OdbcCommand cmd = new OdbcCommand(sqlText, odConn); //opening connection here int iRes = cmd.Execu ...Show All

• microsoft_developer SqlDeveloper/SqlExpress Conflict.

  Hi, Background: I'm on a Pentium 2.4 with 1024 mb Memory and 160 Gb harddrive, running XPPro with SP2. I started a project in VS2005Beta2 with Sql2005Beta. When the RTM versions came along I ungraded to VS2005Pro, and tried to upgrade the SqlDeveloper. This ran amuck, but I could still access my database, so after three attempts I gave up temporarily. When it looked as if I was actually going to finish my project, I decided to sort out ...Show All

• Charles Piche Dataset and Filters

  Hi ! I have a quick question. If i have a report that show invoice by suppliers. Sometime i would like the report to diplayed all suppliers and sometimes for only one suppliers. Can i do this using the filters property of the dateset Or did i have to create 2 reports. One for the case All suppliers and the other for the case Only one suppliers Thank and sorry about my bad English ^_^ Thanks for your answer. ...Show All

• TwipAndPixel Can't connect with Visual Web Developer Express

  When attempting to use VWD Express' built-in web server I recieve the following error in browser window: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I've done the following: ...Show All

• coolstyle sql server2005 and sql mobile DB (.sdf)

  hi. I am too green in sql2005. so the problem is with data import from csv or txt or access files to sql mobile database. at internet i fount that tis is wery simple but i can not find how so dts wizzard have not this function. coul someone provide directly steps which i shoud do to import/export data from sdf db i have vs2005 and sql2005 Patrick, If you have gotten this to work, could you ...Show All

• Enkht SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger I received this very similar type error and found myself here with others ...Show All

• Rodrigo Landaeta INSERT INTO Statement Problem

  Greetings, I have a INSERT sp that just copies a few lines from one table into another. The problem I am hitting is that one of the fields in the target table is an ID field (this is from when the table started its life in MS Access and used Autonumber). Obviously this field does not accept NULL values. How can I get the import process to automatically add the next sequential number in the ID field as part of this stored procedur ...Show All

• JeffRusso transfer access DB to SQL 2005 PRO

  Dear, i have a huge msaccess 2003 DB i want to transfer it to SQL 2005 , i found tool to imigrant oracle (and i used it) but i can't find solution to imugrant msaccess thanks avner on your MSAccess tools menu in you should find Database Utilities -> Upsizing Wizard. If you don't see it, it needs to be added via Add Remove Programs. Modify Office/Access to add the "Additional Wiza ...Show All

• YellOwCN Update conflict

  I am running merge replication on SQL Server 2005. Included in replication are 6 Subscribers and one Publisher/Distributor. Replication compatibility level is SQL 2005 and I am using row-level tracking. Servers are synchronized in 5 minutes each (so gap between two consecutive syncs of one server is 30 minutes) Earlier all of this was on compatibility level SQL 2000, since all servers were upgraded from 2000 to 2005. But 10 days ago I upgrade ...Show All