all groups > sqlserver server > august 2006 > threads for sunday august 20
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
"sp_cursor" error while printing web report using Reporting Servic
Posted by CD Moo at 8/20/2006 10:18:01 PM
Hi there,
We're using MS SQL 2000 with MS Server 2003. It's a Xeon ( single processor)
based Server with 1GB RAM.
We also use 'Reporting Services' to generate web reports.
The problem is , our application will have problem writing ( ie. INSERT
INTO) to the transaction database if the web ... more >>
Strange behavior accessing SQL server from web - beginner
Posted by Ranginald at 8/20/2006 9:38:46 PM
Hi,
This may be a simple questions but I've noticed a strange behavior on
my web with sql server.
I have an asp.net 2.0 web site hosted with one provider and the sql
server 2000 database that runs it on a different host.
Here's the strange thing (for me):
www.website.com/samplepage.asp... more >>
How much memory is safe to reserve for SQL?
Posted by WR at 8/20/2006 8:56:44 PM
I am running SQL 2000 in a Windows Server 2000. The server only has 1.5
Gb of RAM. One of the databases is taking 1GB of space and it has 8
connections running at all times. I want to limit the amount of memory
that SQL uses, beucase SQLSVR.EXE is taking 1+ Gb of the memory of the
server. How m... more >>
Named Pipers Provider, error 40, ok from local, error to remote - help
Posted by Ranginald at 8/20/2006 7:20:29 PM
Hi.
I am new to sql server so please bear with me.
Here is the problem.
I am using VWD express to connect to a sql server 2005 db on my local
machine. The site and the sql server are local and everything is fine.
No problems.
I have a sql server hosting plan to host the db. (my local is ... more >>
maintenance plan
Posted by Howard at 8/20/2006 10:06:27 AM
Im building a new sql server and would like to use my existing maintenance
plans. Where are the files stored and how do I use them on the new server?
Thanks,
Howard
... more >>
Mismatched pages
Posted by Mark at 8/20/2006 8:33:01 AM
I am working with a SQL 6.5 database. I have restored it from backup, but on
some of the tables, when I do a select, I get the following message:
Attempt to fetch logical page 2355704 in database 'db1' belongs to object
'0', not to object 'Document'.
A similar message is displayed when I... more >>
DTS package won't run as a scheduled job
Posted by Rich at 8/20/2006 7:48:44 AM
Hi,
We have recently begun to experience a problem that is stumping us. We
have a DTS package that is run every morning as a scheduled job but
always fails. The job runs perfectly fine when kicked off manually
(either all at once from the Enterprise Manager or one step at a time
from DTS). Th... more >>
SQ 2000 and MYSQL - Transferring data automated
Posted by techcs at 8/20/2006 3:14:38 AM
Hi,
Please bear with me as I am new to databases especially SQL.
Here is what I would like to achieve:
I have a webserver running MYSQL where website users store their data.
I now need to store/replicate the data in another SQL2000 database on
my interanl network. Is there a script or rou... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server 2005 linked server
Posted by Mark Rae at 8/20/2006 12:00:00 AM
Hi,
I'm having a nightmare trying to create a linked server on my SQL Server
2005 box pointing to a remote SQL Server 2005 box. This used to be so easy
with SQL Server 2000: create an alias, point the linked server at the alias,
and then do four-part query names etc.
However, I appear to... more >> |
