all groups > sql server (alternate) > recent posts
Connectiviity error involving Sql Server
Posted by Peggy Mall at 11/24/2009 6:31:11 AM
This is the error I am getting:
Connectivity error: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Conversion failed when converting the varchar value '4/24/' to data type int.
From http://www.developmentnow.com/g/95_2006_4_0_0_0/comp-databases-ms-sqlserver.htm
Posted via DevelopmentNow.com... more >>
buy diacount brand shoes and clothing from www.richvipshoes.com
Posted by richvipshoes at 9/1/2009 2:03:26 AM
www.richvipshoes.com wholesaling ,retailing and dropshipping many kinds discount brands on shoes(nike,adidas,puma,gucci,prada,dg,lv,coach,juicy,true religion……) ,clothes, jeans, purses/bag, Sunglasses,brand accessories, etc, which is from Putian city,Fujian province,China.
1.We supply door to doo... more >>
RE: Error 0xc02020a1: Data Flow Task: Data conversion failed
Posted by PCRIDE at 8/1/2009 2:34:16 PM
I tried this and it worked to an extent. The issue is that my raw data as a lot of free form text fields and the only way to make this work is to limit the number of text fields. The "Suggest Types" seems to take an average of what data is stored and can only be used on a flat file which makes it ev... more >>
im getting this error ox10025270 referrenced oxffffffff
Posted by JB at 4/10/2009 8:46:47 AM
how can i solve this kind of problem.. i cannot pull up yahoo messenger.. ive downloaded messenger 3x and its still providing me that message whenever i tun on my pc.. plz help me out
From http://www.developmentnow.com/g/95_2005_10_0_0_624858/DTSRun-causes-The-Memory-could-not-be-read-application-... more >>
how to write stored procedur using update command in sql server
Posted by indika at 1/9/2009 7:25:45 PM
please let me know about that solution
From http://www.developmentnow.com/g/95_2003_10_0_0_0/comp-databases-ms-sqlserver.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/... more >>
RE: Fundamental help required with SQL connection
Posted by Ravi at 10/23/2008 11:23:46 PM
hai please help me
From http://www.google.co.in/search?hl=en&client=firefox-a&channel=s&rls=org.mozilla:en-US:official&hs=ZDv&q=i+have+database+connection+in+Registry+file+so+how+can+i+add+the+database+when+i+create+setup+file+++vn.net&btnG=Search&meta=
Posted via DevelopmentNow.com Groups
http://... more >>
RE: dynamically built temporary table,
Posted by Stephen Zlamany at 9/2/2008 2:19:39 PM
Spectacular script - thank you so much.
I just used it to build 220 tables that mimic a foxpro system we are converting to MS SQL. I've got all 220 tables now in SQL using MS SQL datatypes and we can all look at data easily.
From http://www.developmentnow.com/g/95_2004_3_0_0_377869/dynamically-... more >>
SQL Server 2008 caching
Posted by Manoj saini at 8/7/2008 10:16:56 PM
I need to give one functionality in my application as applicationl lock. If my databsae is get lock at the time of backup, i need to give a message to user that daatbse has been locked and ask him to log out. This application is in Dot net2005. Before db lock , i set one parameter in table and read ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
win 2003 server
Posted by jansi at 3/3/2008 12:12:17 AM
how many user create in win 2003 server?
From http://www.developmentnow.com/g/95_2004_7_1_0_0/comp-databases-ms-sqlserver.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com... more >>
Re: How do I link a database in SQL
Posted by Erland Sommarskog at 10/14/2007 12:00:00 AM
(rzito@si.rr.com) writes:
> I am working on a databse on my local box, my source data is on
> another. How can I link the database and table from one server to
> another? Currently I am using DTS to just transfer the records!
You can set up a linked server. If the stars align, it's as simple... more >>
Re: Query Variables
Posted by Erland Sommarskog at 10/13/2007 10:16:45 PM
Yota (yotaxp@gmail.com) writes:
> I'm new to SQL Server, but an experienced .Net developer. I'm trying
> to accomplish a query the most efficient way possible. My question is
> if you can define a temporary variable within a query to store tables
> or fields. (Like the LET clause of LINQ) My ... more >>
Query Variables
Posted by Yota at 10/13/2007 10:01:23 PM
Hi,
I'm new to SQL Server, but an experienced .Net developer. I'm trying
to accomplish a query the most efficient way possible. My question is
if you can define a temporary variable within a query to store tables
or fields. (Like the LET clause of LINQ) My query makes use of
subqueries whi... more >>
Jobs in HCL-Noida/Gurgaon/Chennai/Bangalore/Mumbai
Posted by dbaguru at 10/13/2007 9:19:45 PM
Jobs in HCL-Noida/Gurgaon/Chennai/Bangalore/Mumbai
1. Citrix Admins - Noida - Chennai [L2/L3 Support]
2. Sun Solaris Admins - Noida - Chennai - Mumbai [L2/L3 Support]
3. HP Unix Admins [Chennai] / IBM AIX Admins [Chennai & Mumbai]
4. Linux Admin [L2/L3 Support] - NCR & Chennai
5. Oracle DBA... more >>
How do I link a database in SQL
Posted by rzito NO[at]SPAM si.rr.com at 10/13/2007 9:12:45 PM
I am working on a databse on my local box, my source data is on
another. How can I link the database and table from one server to
another? Currently I am using DTS to just transfer the records!
... more >>
Re: Speed Issues After SQL Upgrade
Posted by Ed Murphy at 10/13/2007 8:30:35 PM
Side note: When posting the same thing to multiple newsgroups,
please crosspost (to all of them in a single step) rather than
multi-posting (to each of them individually). I responded to
this in another group before reading in this one that you'd
already resolved the issue.... more >>
Re: Would special character cause insertion problem?
Posted by Erland Sommarskog at 10/13/2007 4:56:53 PM
(tatata9999@gmail.com) writes:
> I'm not sure I follow you this time.
And I am not sure that I am following you. You post some loose bits of
code that I don't really know what language it is. In the middle of at
you get an SQL error:
Violation of PRIMARY KEY constraint 'PK__myTBL__772... more >>
Re: Indexed View Crashes ASP.NET App
Posted by Erland Sommarskog at 10/13/2007 3:18:13 PM
Jason Wilson (wilsonj@ausrad.com) writes:
> I was looking to improve the performance of an ASP.NET application by
> creating the an indexed view that could be used instead of some of the
> root tables.
>
> What I didn't realize is that it would affect any future conenctions
> to the root tabl... more >>
Re: Speed Issues After SQL Upgrade
Posted by Erland Sommarskog at 10/13/2007 3:11:07 PM
Ben (pillars4@sbcglobal.net) writes:
> We recently upgraded our MS SQL Server 2000 to 2005.
>
> Here is what we did:
>
> 1. Perform backup of the database from the old server.
> 2. Created a blank database in the new server.
> 3. Restored the database into the blank database located in the ... more >>
Re: Speed Issues After SQL Upgrade
Posted by Ben at 10/13/2007 1:07:46 PM
The sp_updatestats did the trick. Now the speed as it should be.
Thanks.
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99C8AFB6246FYazorman@127.0.0.1...
> Ben (pillars4@sbcglobal.net) writes:
>> We recently upgraded our MS SQL Server 2000 to 2005.
>>
>> Here is w... more >>
Re: Would special character cause insertion problem?
Posted by tatata9999 NO[at]SPAM gmail.com at 10/13/2007 11:05:53 AM
On Oct 13, 11:56 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (tatata9...@gmail.com) writes:
> > I'm not sure I follow you this time.
>
> And I am not sure that I am following you. You post some loose bits of
> code that I don't really know what language it is. In the middle of at
... more >>
Re: Speed Issues After SQL Upgrade
Posted by Greg D. Moore (Strider) at 10/13/2007 9:39:39 AM
"Ben" <pillars4@sbcglobal.net> wrote in message
news:T%RPi.1672$LD2.1355@newssvr17.news.prodigy.net...
> The hardware configuration below:
>
> - Has two Intel Quad-Core Xeon processors
> - 10GB of RAM
> - 15,000RPM SATA hard drives
>
> The old server was just a regular P4, 4G RAM.
>
... more >>
Re: get value of a single record instead of aggregated value with GROUP BY
Posted by Erland Sommarskog at 10/12/2007 9:21:12 PM
blackpuppy (mingzhu.z@gmail.com) writes:
> I would like to use the following SQL statement to get the latest
> comment for all products.
>
> SELECT PRODUCT_ID, COMMENT, UPDATED_ON
> FROM PRODUCT_COMMENT
> GROUP BY PRODUCT_ID
> HAVING UPDATED_ON = MAX(UPDATED_ON)
>
> But this leads to... more >>
Re: Would special character cause insertion problem?
Posted by Erland Sommarskog at 10/12/2007 9:16:19 PM
(tatata9999@gmail.com) writes:
> Very simple sql dml code (all the columns are of varchar of various
> length):
> insert into myTBL (col1,col2,col3)
> values ('#ranVar#','#FORM.element1#','#FORM.element2#')
>
> The err msg is:
> Violation of PRIMARY KEY constraint 'PK__myTBL__772828B3... more >>
Re: how to query for a column value that contains dashes
Posted by MC at 10/12/2007 7:56:29 PM
Something like this (untested, but you see the point):
select <col list>
from profile
where msgdate >= @date and msgdate < dateadd(dd,1,@date)
date would be a parameter...
MC
<jdrake@living-dead.net> wrote in message
news:1192208492.248548.49030@e34g2000pro.googlegroups.com...
> H... more >>
Re: how to query for a column value that contains dashes
Posted by Roy Harvey (SQL Server MVP) at 10/12/2007 5:56:08 PM
What exactly is the data type of the column msgdate? You mention it
is a 'datetime' column. If it is the datatype of datetime then forget
about strings, it is stored internally as a couple of numbers. With a
non-zero time the standard way to test for a specific date is:
WHERE msgdate >= '2... more >>
Re: Would special character cause insertion problem?
Posted by Jack Vamvas at 10/12/2007 5:01:20 PM
Could you post your stored procedure or code?
Are you able to get an output of the sql string that will be used, the one
that throws the error.
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL
<tatata999... more >>
Re: Would special character cause insertion problem?
Posted by tatata9999 NO[at]SPAM gmail.com at 10/12/2007 4:34:59 PM
Sorry for security reason, I have to remove the previous post and
repost it with revision.
The err msg is:
Violation of PRIMARY KEY constraint 'PK__myTBL__772828B3EFCA'. Cannot
insert duplicate key in object 'myTBL'.<P><P>
SQL = "insert into myTBL (col1,col2,col3) values
('342*783'... more >>
Re: Would special character cause insertion problem?
Posted by tatata9999 NO[at]SPAM gmail.com at 10/12/2007 4:32:00 PM
On Oct 12, 4:16 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (tatata9...@gmail.com) writes:
> > Very simple sql dml code (all the columns are of varchar of various
> > length):
> > insert into myTBL (col1,col2,col3)
> > values ('#ranVar#','#FORM.element1#','#FORM.element2#')
>
... more >>
Re: Speed Issues After SQL Upgrade
Posted by Ben at 10/12/2007 2:54:16 PM
The hardware configuration below:
- Has two Intel Quad-Core Xeon processors
- 10GB of RAM
- 15,000RPM SATA hard drives
The old server was just a regular P4, 4G RAM.
"Ben" <pillars4@sbcglobal.net> wrote in message
news:FURPi.1671$LD2.266@newssvr17.news.prodigy.net...
> We recently upg... more >>
Speed Issues After SQL Upgrade
Posted by Ben at 10/12/2007 2:46:33 PM
We recently upgraded our MS SQL Server 2000 to 2005.
Here is what we did:
1. Perform backup of the database from the old server.
2. Created a blank database in the new server.
3. Restored the database into the blank database located in the new server.
After this process, there was an obvi... more >> |
