Answer Questions

• guysky Error:Procedure or function CatalogJSummary has too many arguments specified

  hello, all I am using a Stored procedure and calling this in my code in C#. Here is my procedure: CatalogJSummary ( @SeriesId INT ) AS SELECT Games.GameName, Games.Id AS GameId FROM GameCodes INNER JOIN Games ON GameCodes.GameId = Games.Id INNER JOIN MobileSeries ON GameCodes.SeriesId = MobileSeries.Id INNER JOIN Mobiles ON MobileSeries.Id = Mobiles.SeriesId GROUP BY Games.GameNam ...Show All

• Panagiotis Error in Report "Memory Consumption" after upgrading with SQL2005 CTP SP1

  There's a little bug in the CTP SP1 release of SQL2005. Opened MS SQL Server Management Studio. Connected to a SQL2005 64bit server with 6GB memory. Choose Summary, Report, Memory Consumption and in the graph for Buffer Pages Distribution (#Pages) there's no graph, but the following error " Unable to retrieve data for this section of the report. Following error occurred. Msg 8114, Level 16, State 1 Error converting data type bigint to int. ...Show All

• Steve1234 Directly editing data in results pane with SQL 2005 Management Studio

  In SQL 2000 Enterprise Manager, one was able to edit and commit data on-the-fly directly from the results pane.  Action->Open Table->Query with the SQL Pane shown gives you an interface similar to Query Analyzer.  One could write a complex select statement with where clauses and joins, and the results pane would show the resulting data.  The data is editable and instantly updated.  We are now planning to migrate to SQL ...Show All

• valeneo changing autocommit mode

  Hi: The first stmts in http://msdn.microsoft.com/library/default.asp url=/library/en-us/acdata/ac_8_md_06_35bq.asp are "Autocommit mode is the default transaction management mode of MicrosoftR SQL Server . Every Transact-SQL statement is committed or rolled back when it completes." "if a statement completes successfully, it is committed; if it encounters any error, it is rolled back. A SQL Server connection operates ...Show All

• MightyDubCats No TRIM function in 2005 - are you serious!?

  I cannot believe that there is yet another version of SQL Server without a TRIM function.  So for SQL 2005 (like I've done in 7.0 and 2000) my T-SQL will look like dog poo because I will have to write LTRIM(RTRIM(MyValue)) anytime I want to remove whitespace from both ends of character values instead of just writing TRIM(MyValue). Microsoft - how can you write LTRIM and RTRIM and not write TRIM in the same breath an ...Show All

• AJTessin Client Failover Problems

  Hi, I encountered 2 problems when my application reconnects to the mirror database after the principle database is not available. My Connection String: Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=TestFailover;Persist Security Info=True;User ID=sa;Connect Timeout=45 Firstly, the following exception will be prompted when failover occurs: A transport-level error has ocurred when received results from the server. ...Show All

• VeeraMaddukuri How can SQL Server 2005 Reporting help me ?

  Hi, Currently, we developed an online survey engine using ASP .NET and SQL Server 2000. We gather data from surveys, store this data inside SQL Server 2000 tables and then use a bunch of stored procedure to recode the values, store these new values inside some new tables and finally, generate PDF reports with in-house reporting elements. Today, we'd like to provide results of surveys in a snythetic way online, allowing the end-user to sele ...Show All

• shango Parallel activations with GET CONV GROUP

  Hey guys. I'll try to keep this as short as possible. Was testing out some thresholds with a simple service broker application and ran into something interesting that I'm trying to find a workaround to. I setup a simple service on a single instance, and am transmitting messages to/from the same instance. I assigned a procedure to be activated on the queue, with a max of 20 parallel activations. The procedure originally was reading messages ...Show All

• Gathar pros/cons of using Access 2003 as a front-end for SQL 2005

  Hi, I'm creating a SQL 2005 database for a small company. I'm leaning towards using Access 2003 as a front-end for them, since it has a decent report writer and the adp projects seem to preserve SQL's schema relationships. But I've read some posts where Microsoft is frowning on adp projects. It would cost this company more money in the short-term, but am I better off building a custom .net winforms application instead and avoid Access 2003 I' ...Show All

• marco_polo14 Log Shipping from SQL Server 2000 to SQL Server 2005

  I work for a small state government department.  We are about to install SQL Server 2005. A national government department that runs on SQL Server 2000 are willing to give us a backup of their database (20 gig I think) and then log ship to us regulary.  Our aim is to have a copy of the database that we can query from and that is only a day or so out-of-date. I'm having no luck. 1. I can backup the SQL Server 2000 database. ...Show All

• Steen L. Nielsen Database Engine from One Computer to Another

  As an obvious novice, I am hoping the answer to this will be simple. I have two computers with SQL 2005 installed. One computer is used for development and the other will be used for the application. I would love to transfer the database from the development computer to the application compute. By the way, these computers are NOT networked and are miles apart. I did a ClickOnce for deployment but must have missed something because of the SQL 200 ...Show All

• Andreas Sieber Configuration Error on Encryption Key

  I came across an issue while configuring SQL Server 2005 Reporting Services. In the reporting services configuration tool, there is a step the either Backup, Restore, or Change the encryption key for the new Reporting Services instance. I backed up the key since this is the first installation of SQL Server and Reporting Services on this machine. I had expected that the configuration would then allow me to progress to the ne ...Show All

• DaveRivera Partially solved the problem {OLE DB error - TCP Provider: No connection could be made ...}

  All, -> SQL Server 2005 Standard set as a named instance, runs as a local system -> SQL Server protocol enabled: TCPIP (configured to listen on port 1433 with use of dynamic ports disabled) -> Remote connections through the SQL Server Surface Area Configuration. Server starts successfully. But, I received the following error on trying to process a cube from BI studio is - OLE DB error: OLE DB or ODBC error: Login timeout exp ...Show All

• ArunM Oracle 9i -> SQL Server 2005: Snapshot agent aborts suddenly uninterrupted

  Hi - I hope some of you can help me with this problem. I'm trying to run the snapshot agent for 77 published tables, but the agent stops suddenly uninterrupted. It stops in the middle of taking a snapshot of a table containing 81,719,531 rows. The error message is pasted below. Message 2006-06-14 05:33:33.53 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57200000 total rows copied) 2006-06-14 0 ...Show All

• Jignesh Desai How could XML help us in our ETL packages on daily-basis?

  Hi all of you, I'm just a newbie with XML. Now we're moving all our DTS to SSIS packages. Most of them are simply processes that takes a plain file and loading these data into Sql table or in inverse way. So that I wonder what role will play XML here. I mean, are there big differences between store data as XML format and nvarchar That sort of stuff. Thanks in advance for any input, http://msdn2.microsoft.com/en-us/lib ...Show All