Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HiggsBoson
Starting Member
1 Post |
 Posted - 2009-11-20 : 15:44:44
|
| I am moving a database to a new server.Old: SQL 7 on Win Server 2kNew: SQL 2008 on Win Server 2008My vb.net app fills the datagridview with a stored procedure.Profiler for each as follows (only the connection string is changed on the app side):Old: exec bb2_SearchSalesHist;1 0.5, 1, 6, '%', '%', '%', '%'New: exec bb2_SearchSalesHist;1 0.5, 1, 6, '% ', '% ', '% ', '% 'The stored procedure starts out like so:CREATE PROCEDURE bb2_SearchSalesHist @diam decimal(9,4), @diam2 decimal(9,4), @length decimal(9,4), @pitch varchar(10) , @head varchar(2), @grade varchar(10), @Cust varchar(5)Where are those spaces coming from? |
|
|
support.sql
Starting Member
15 Posts |
Posted - 2009-11-29 : 19:23:05
|
| You should review your MSSQL Driver connection from VB.NET, this behavior looks like the VB.NET is wrong type when it send the info to SQL Server.SNMTry Free Microsoft SQL Server Data Collector & Performance Monitor.http://www.analyticsperformance.com@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector |
 |
|
|
|
|
|
|
|
Where are these trailing spaces coming from?