среда, 28 апреля 2010 г.
|
| Thanks for telling us the answer you found. No really. X-( Guest 19:34:34 |
| | Thanks for telling us the answer you found. No really.  |
| | Add comment |
|
| One of the properties of a relation or table is that every... Guest 19:33:58 |
| | One of the properties of a relation or table is that every row is unique. If this so what do we do with q table of comments?
Let’s say I want to put comments on a play in a relation. Two different say "it was a great play”. They both say exactly the same words. How can we put both comments in relation we must have uniqueness??
can any help me out for solving this if so please post a mail to this mail id rad7687@gmail.com:-) |
| |  2 answer | Add comment |
|
| Hi,Since this topic was on using bcp and format files, i... Guest 19:33:15 |
| | Hi,
Since this topic was on using bcp and format files, i thought i could post my query here.
I am trying to load a table using bcp and format file, however the table has one extra column which has to have a constant value (not null). I tried to modify the format file to indicate that this column shouldnt be loaded, but the bcp utility just says no rows processed, and doesnt throw any error either. What would be the ideal solution to add a constant value to a column, using bcp?
Thanks in advance!
Regards
Kalpa |
| | 3 answer | Add comment |
пятница, 16 апреля 2010 г.
|
| :-) its good, thanks a lot. now its working Guest 06:31:49 |
| |  its good, thanks a lot. now its working |
| | Add comment |
вторник, 13 апреля 2010 г.
|
Topic awaiting moderation  nikejordanaaa 11:56:35 |
воскресенье, 28 марта 2010 г.
|
| Hi,I had this script with a lot of left outer join working... Guest 12:37:03 |
| | Hi,
I had this script with a lot of left outer join working, but when i added the command 'order by ' a valid field, the script is not working. am using microsoft sql 2005, shall i need to upgrade to service packs to make this work? |
| | Add comment |
пятница, 19 марта 2010 г.
среда, 17 марта 2010 г.
|
| nice tool. However, I have heard about another program for... Guest 18:28:56 |
| | nice tool. However, I have heard about another program for sql recover ndf file: http://www.recoverytoolbox.com/sql_server_2000_how_recover_index_ndf.html, check it out and find out why it is more efficient |
| | Add comment |
|
| nice tool. However, I have heard about another program for... Guest 18:27:51 |
| | nice tool. However, I have heard about another program for repair sql database 2005: http://www.recoverytoolbox.com/sql_server_2000_database_repair_download.html, check it out and find out why it is more efficient |
| | Add comment |
вторник, 16 марта 2010 г.
понедельник, 15 марта 2010 г.
|
| do not hesitate trying various tools for recovery sql... Guest 18:34:06 |
| | do not hesitate trying various tools for recovery sql server mdf: http://www.recoverytoolbox.com/how_to_recover_mdf_file_from_sql_server.html, it is often the only choice to retrieve the data from corrupted documents |
| | Add comment |
воскресенье, 14 марта 2010 г.
|
| e-cracker Guest 03:48:53 |
| | Hi Friend can some1 tell me where iwil gat e-cracker where i can free download im waiting4 ur all answer thanks GOD Bless u All |
| | Add comment |
вторник, 9 марта 2010 г.
|
| looks great. The parsing of corrupted documents can be also... Guest 19:51:53 |
| | looks great. The parsing of corrupted documents can be also performed by the .mdf repair utility: http://www.recoverytoolbox.com/sql.html, it is the fastest way to open affected files |
| | Add comment |
пятница, 20 ноября 2009 г.
|
| unable to connect to ,ms sql server from visual c++ athi 19:37:15 |
| | hi
I am trying to connect from my small c++ program to my ms sql server, but Not able to. I tried going to the configuration manager and enabled the namedpipes, but still not able to.
I am using the default instance in the server.
someone please enlighten me.
thnks
athi |
| | 1 answer | Add comment |
пятница, 4 сентября 2009 г.
|
| Agreed - I have see a 'few' items - but nothing... Guest 23:32:59 |
| | Agreed - I have see a 'few' items - but nothing 'official'
This should not even be (nor should it need) a 'whitepaper.'
It should be an AUTOMATIC upgrade, handled by Microsoft's own processes!
Bottom line: not all of us have SBS 2003 R2 'premium' - some only have 'standard' (me, for example). AND Microsoft's NEW toys, such as Business Contacts Manager Database Tool allegedly runs on SBS 2003, to allow us to put the BCM database there; BUT they (MS) *never* tell you word one about "Oh, by the way, you MUST upgrade MSDE 2000 to SQL Express 2005" - because that's the first thing the DB Tool asks for (or rather, complains about) when you try to create a database - it says, "Unable to list SQL server instances" - "Please ensure you have blah blah SQL 2005" - BUT the BCM Team NOR the SBS Team knows the proper way to upgrade SBS 2003 R2 (Standard) from MSDE 2000 to SQL Express 2005! Don't you find that amazingly incompetent? This should be a ONE-BUTTON, SINGLE-CLICK UPGRADE! I mean, if you can tell me, in a 75-page whitepaper how to "drop the db's, copy the db's, install new 2005 version of SQL Lite, etc." then you most certainly can write an MSI or equivalent upgrade package to handle that!
To be honest, I have YET to find the exact instructions to upgrade MSDE 2000 to SQL Express 2005 on SBS 2003 R2 Standard (with SP2). It's just 'piecemeal' stuff that people have randomly tried on their own. Especially with the SharePoint/SBS Monitoring tie-in - one articles says, "Oh, don't even 'touch' the SharePoint/SBS instances" and yet, in the same breath, the guys says at the end that he ended up successfully upgrading those MSDE 2K instances also to 2005 - BUT he never says 'how' he did it.
Very disappointed. All these techs, and nobody can give precise steps on how to do this.
Someone please point me to an MS Whitepaper - because all the links I've seen are broken and taken down, so they can now try and sell SQL 2008 and BCM 2010 and SBS 2008, etc. Well, I just bought SBS 2003 R2 (client actually bought it) and that's all they could afford, and that's as far as we are going for at least 3 years - so, people like us should still be able to get tech help - right? Thanks in advance for anything anyone can point me to about proper way to either upgrade MSDE 2K to 2k5 Express on SBS 2003 or how to run them side-by-side - Can I leave the SharePoint/SBS pieces on MSDE 2000 and just maybe install and isntance of SQL Express 2005 for BCM? Will that work okay?
I guess MS 'assumes' that we know we must pull down a copy of SQL Express 2005 for BCM 2007, but they don't address whether or not that is "okay" to do with MSDE 2000 on the same server running with SharePoint and SBS Monitoring. |
| | Add comment |
среда, 12 августа 2009 г.
|
| h]:-) Guest 06:19:51 |
| | h![]:-)](http://qaix.com/i/smiles/devil.png "]:-)") |
| | Add comment |
понедельник, 13 июля 2009 г.
|
| i have the same problem on my 2003serverbut i didnot... Guest 18:17:49 |
| | i have the same problem on my 2003server
but i didnot install SQL
i have VMware intalled |
| | 3 answer | Add comment |
воскресенье, 29 марта 2009 г.
|
| Have you tried biterscripting ? There are tons of examples... Guest 20:55:40 |
| |
Have you tried biterscripting ? There are tons of examples posted on the internet, with scripts for manipulating csv (comma separated values) files. Do a google for 'biterscripting' and 'csv'. If you find a script that you that's close to what you want, you can download biterscripting free at http://www.biterscripting.com .
|
| | Add comment |
среда, 6 августа 2008 г.
|
| Is there any system table which contains the number of... Guest 06:47:14 |
| | Is there any system table which contains the number of reads and writes on a table? |
| | Add comment |
понедельник, 28 июля 2008 г.
|
| How do I display my table in mssql in netbeans? Guest 14:08:02 |
| | How do I display my table in mssql in netbeans? |
| | Add comment |
среда, 6 июня 2007 г.
|
| Very helpful to me Guest 14:05:34 |
| | Very helpful to me |
| | Add comment |
среда, 21 июня 2006 г.
|
| What was the solution?!?!! I'm having a similar problem. I... Guest 18:29:25 |
| | What was the solution?!?!! I'm having a similar problem. I have a stored procedure that works fine if I run it over a wired network but If I go wireless it doesn't work and I receive the following message:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken |
| | 2 answer | Add comment |
пятница, 5 мая 2006 г.
|
| Median of Two Dates BrianJ 20:51:31 |
| | I need to find the mid point of two date fields.
The table is application the two column are called ProgramBegin and ProgramEnd.
I need a SQL to display the mid-point of these two dates..
Please Help |
| | Add comment |
|
