all groups > sqlserver server > august 2006 > threads for sunday august 13
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Inserting " ' "
Posted by Dot Net Daddy at 8/13/2006 10:44:47 PM
Hello,
I have a text field which consists of strings. And I want to insert
whatever the user types into the database. But if the user types some
punctuation marks, such as " ' ", it generates this error:
Unclosed quotation mark after the character string ')'.
the solutions should be so ... more >>
Disk Queue Length always high, even with no requests...
Posted by Ryan W. at 8/13/2006 8:26:41 PM
I was working on my server this weekend trying to figure out why I'm
having the problems some of my users are reporting.
After I got done running a dbcc dbreindex, I noticed my average disk
queue length (even over several hours) was a solid 4.337. The perfmon
would show disk IO in large spike... more >>
Case
Posted by Jim Heavey at 8/13/2006 4:15:01 PM
Being new to SQL Server and comming from an Oracle environment....
When I write queries for Oracle, I have to ensure that my queries are
written to be case sensitive. Now when I write those same queries in SQL
(using .Net) it does not appear to be case sensitive. Is this a database
setting o... more >>
Default Value
Posted by Jim Heavey at 8/13/2006 4:07:01 PM
I set up a database using Studio Express. I defined one row to be a date
field with a default value of 9999-12-31. When I go back and look at it it
looks like "(((9999)-(12))-(31))".
When I insert a row into this table and I have not specified a value for
this date field, it show a date o... more >>
SQL 6.5 Restore
Posted by Mark at 8/13/2006 3:21:01 PM
I'm attempting a restore on a SQL 6.5 database. The original media was lost.
I did a sp_helpdb to determine the file segments, copied the appropriate
data from sysdatabase, sysdevices, and sysusages, and then dropped the
original database. I recreated the device segments in order, and verif... more >>
reindexing, rebuilding, etc
Posted by Gerry M at 8/13/2006 11:52:01 AM
hi, new to sql server (2000)..in my previous database, we had to do
maintenance on a regualr basis...reindexing tables, rebuilding, etc...our
database is relatively small (8G)but the reindexing in sql server is done in
minutes, whereas in our old system it used to take up to 4 hrs...Is sql
s... more >>
SQL Error (Connection)
Posted by J Bowman [293288] at 8/13/2006 11:21:31 AM
Hello All... I'm new to setting up a SQL server and I'm trying to connect to
the server via a networked pc... here is the error I'm getting
Microsoft SQL Server ODBC Driver Version 03.85.1117
Running connectivity tests...
Attempting connection
[Microsoft][ODBC SQL Server Driver][SQL Serv... more >>
Accessing SQL Server installed on dynamic IP based PC
Posted by Indra Bisen at 8/13/2006 6:51:53 AM
Hi,
I'm trying to make a application that get data from sql server that is
installed on a pc that is connected to internet through dial-up. As we
know that in dialup based connection pc gets dynamic ip. I want to
fetch sql server data from this PC.
how can we setup ?
Indra Bisen
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
