sqlsqlexpress.blogspot.com
SQL SQLExpress: March 2012
http://sqlsqlexpress.blogspot.com/2012_03_01_archive.html
Tuesday, March 27, 2012. Identity not returning Value. I have a stored procedure that inserts a record. I call the @.@.Identity variable and assign that to a variable in my SQL statement in my asp.net page. That all worked fine when i did it just like that. Now I'm using a new stored procedure that inserts records into 3 tables successively, and the value of the @.@.Identity field is no longer being returned. Anyone have any ideas? CREATE PROCEDURE [iguser].[newticket]. 64;Category nvarchar(80),. Fixed t...
dataloadinginreports.blogspot.com
Data Loading in Reports: 2000 to 2005: The query processor could not produce a query plan
http://dataloadinginreports.blogspot.com/2012/03/2000-to-2005-query-processor-could-not_29.html
Thursday, March 29, 2012. 2000 to 2005: The query processor could not produce a query plan. We are trying to upgrade from 2000 to 2005 and get the following error. Message when we try to execute an insert statement against certain tables in. The query processor could not produce a query plan. If we change the definition of the table (i.e. modifying a column, adding a. New column, etc.), the insert statement works fine. If we script out the. Restoring it in 2005 and both methods produce the same error.
sqlerrors.blogspot.com
sql error: "Version 2.0 Is Not A Compatible Version"
http://sqlerrors.blogspot.com/2012/03/version-20-is-not-compatible-version.html
Monday, March 19, 2012. Version 2.0 Is Not A Compatible Version". When using VS2003 and Reporting Services 2005, I am met with the following. Compilation error after creating a dataset then trying to design it:. Version 2.0 Is Not A Compatible Version". I cant drag any tools to the design surface, or add any fields. I have both. SQL Server 2000 Reporting Services as well as 2005. Anyone have a hint on how I can remedy this? Here is the stack:. Exception Text * * * * * * *. CaItem, Type caType). At Micros...
dataloadinginreports.blogspot.com
Data Loading in Reports: 2000 vs 2005 comparison list
http://dataloadinginreports.blogspot.com/2012/03/2000-vs-2005-comparison-list_8351.html
Thursday, March 29, 2012. 2000 vs 2005 comparison list. I need to summerize diferences between sql server version 2005. Does any body know a link to a comparison of. Sql server features between versions 2000 and 2005? This could be a good start:. Http:/ msdn2.microsoft.com/library/ms170363(en-US,SQL.90).aspx. Dejan Sarka, SQL Server MVP. Rea" Rea@.discussions.microsoft.com wrote in message. News:4ABA7D25-1691-4C6A-B571-1BD0D4247A27@.microsoft.com. Does any body know a link to a comparison of. 2000 to 200...
sqlerrors.blogspot.com
sql error: "unable to load MDT2G.DLL" (sql 7.0)?
http://sqlerrors.blogspot.com/2012/03/unable-to-load-mdt2gdll-sql-70.html
Monday, March 19, 2012. Unable to load MDT2G.DLL" (sql 7.0)? I'm using sql server 7.0 - on "SQL Server Enterprise Manager" screen,. When I right click a table and select "Design Table" on the menu list,. I get error message box "Unable to load MDT2G.DLL". I never had this before and don't know what happend. What caused this and how to fix it? I'm using sql server 7.0 - on "SQL Server Enterprise Manager". Screen, when I right click a table and select "Design Table" on. What caused this and how to fix it?
sqlerrors.blogspot.com
sql error: "View Report" button.
http://sqlerrors.blogspot.com/2012/03/view-report-button.html
Monday, March 19, 2012. Would someone be able to tell me if this is a bug or not. When I have two. Parameters (both text boxes) and change the first one and click on the "View. Report" button to refresh the data with the new parameter values it blanks. The report out and I do not see "processing report" like I normally do. On. The second click it processes the report. When I change a parameter in the second text box and click "View Report", it. Processes the first click. Happy to provide the RDL. Paramet...
sqlerrors.blogspot.com
sql error: "UAT" Managed test Post
http://sqlerrors.blogspot.com/2012/03/uat-managed-test-post.html
Monday, March 19, 2012. UAT" Managed test Post. Using johnogorman@.netscape.net ACCT. Your display name is strange in that it doesnt seem to map to your email. Address, but thats just a guess. If this was a test to see if youre coming. In as a "managed" customer, however, I can confirm that. :-). This posting is provided "AS IS" with no warranties, and confers no rights. Vikrant" johnogorman@.netscape.net wrote in message. News:uMQSgXrMEHA.3556@.TK2MSFTNGP09.phx.gbl. Subscribe to: Post Comments (Atom).
sqlsqlexpress.blogspot.com
SQL SQLExpress: @@Identity not returning Value
http://sqlsqlexpress.blogspot.com/2012/03/identity-not-returning-value.html
Tuesday, March 27, 2012. Identity not returning Value. I have a stored procedure that inserts a record. I call the @.@.Identity variable and assign that to a variable in my SQL statement in my asp.net page. That all worked fine when i did it just like that. Now I'm using a new stored procedure that inserts records into 3 tables successively, and the value of the @.@.Identity field is no longer being returned. Anyone have any ideas? CREATE PROCEDURE [iguser].[newticket]. 64;Category nvarchar(80),. Fixed t...
dataloadinginreports.blogspot.com
Data Loading in Reports: 2000/2005 Handling UPDATE with mixed locking hints differently
http://dataloadinginreports.blogspot.com/2012/03/20002005-handling-update-with-mixed.html
Thursday, March 29, 2012. 2000/2005 Handling UPDATE with mixed locking hints differently. We've recently begun planning our upgrade to SQL 2005 from SQL 2000 (see. Versions below). During testing we discovered we can no. Longer specify conflicting locking hints within an UPDATE statement. For example, our SQL 2000 systems have code similar to this (line. 1 UPDATE dbo.flSalesDetail WITH (ROWLOCK). 2 SET net amt = gross amt storage amt - credit. 3 FROM dbo.flSalesSummary AS summary WITH (NOLOCK). Andrew J&...
dataloadinginreports.blogspot.com
Data Loading in Reports: 2000 to 2005: The query processor could not produce a query plan
http://dataloadinginreports.blogspot.com/2012/03/2000-to-2005-query-processor-could-not_8698.html
Thursday, March 29, 2012. 2000 to 2005: The query processor could not produce a query plan. We are trying to upgrade from 2000 to 2005 and get the following error. Message when we try to execute an insert statement against certain tables in. The query processor could not produce a query plan. If we change the definition of the table (i.e. modifying a column, adding a. New column, etc.), the insert statement works fine. If we script out the. Restoring it in 2005 and both methods produce the same error.