all groups > sql server connect > march 2005 > threads for march 8 - 14, 2005
Filter by week: 1 2 3 4 5
SQL Server 2000 SP3a and Windows Server 2003
Posted by Matt Soukup at 3/14/2005 1:57:02 PM
I have a Windows Server 2003 Standard that I have installed MSDE with SP3a
on. This server is running only as a file server on a workgroup, no Active
Directory, DNS, or DHCP servers are running. I can connect to SQL locally
with no problem. When I tried to connect a Windows 2000 workstation at... more >>
Need help with stored procedure.
Posted by Vanessa Lee at 3/13/2005 7:28:44 PM
Hi,
I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
@String = 'word1word2word3word4word5' - This value is passed to Stored
Procedure from the script.
Column1 in a table1 has many rows with "words" . One row in this column1
will have 'word3'. Notice that this 'word3' i... more >>
Connection between SQL Server 2000 SP3a and ODBC Driver
Posted by desimaj at 3/12/2005 3:43:02 PM
Database: SQL Server 2000 Developer Edition SP3a
Frontend: MS Access 2000 and Access 2003
A Custm-built Medical Records Database
I am having a problem connecting to my SQL server with certain ODBC drivers
(sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in
particular ... more >>
trying to create view on linked server
Posted by Joss at 3/11/2005 3:00:13 PM
Plesae excuse if I make any howlers here, I am on the steep part of the
curve.
I have created a link in SQL to an AS400 but cannot create a view to it in
Access ADP. The SQL that I am using is
'SELECT fieldname FROM as400sver..dbo.linkedTableNAme;
the error that I get when I try to save/... more >>
Kill Blocked Process PID 52 without Reboot
Posted by matthias at 3/11/2005 11:45:45 AM
Hello,
I need help :-))
We use an SQL 2000 Server.
in the Systemmanager one Prozess with PID is sleeping, no databese
context, and I can not cancel the Prozess.
When i try to update some Data, this Prozess ist Blocking all other.
How can i cancel this job without reboot the server.
T... more >>
connection failed
Posted by .:alex:. at 3/11/2005 9:15:54 AM
Hello,
I have sql server 2000 on a XP/SP2 machine.. with XP firewall active.
But I cannot connect to sql server. I receive this message "Unable to
connect to server xxxxxx: SQL Server does not exist or access denied"; or
Login failed for user xxxxx. With QA same problem... I created the ... more >>
Low performance while inserting records
Posted by Sanjay Jajoo at 3/11/2005 3:45:02 AM
Hi,
Can anyone help us in letting us know that while inserting records through
VB to SQL server it takes very long time even to insert very few KB of data
which previously was happening in seconds is now taking hours.!!!!!!!... more >>
Restore database fails only when source is read from another machine ( server)
Posted by PKuhne at 3/10/2005 5:41:43 PM
When executing this from Query Analyzer on server1, where the target is
located,
restore database restoretest
from disk = 'd:\backups\dottietest.bak'
with move 'vam_system_data' to 'd:\vamdata\sample\vamsystemdata.mdf',
move 'vam_user_data' to 'd:\vamdata\sample\vamuserdata.ndf',
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Not associated with a trusted SQL Server connection error
Posted by James Turner at 3/10/2005 12:00:48 PM
I have an ASP app I am trying to implement which is giving me some weird
results.
The environment is a Windows 2003 Domain. The IIS Server is Windows 2000
SP4, SQL 2000 is running on a Windows 2003 server.
I have an ODBC connection setup to a database using SQL Authentication.
If I log... more >>
[Microsoft][ODBC SQL Server Driver]Timeout expired
Posted by Mitul Z. at 3/10/2005 4:13:03 AM
Hi:
I am getting this error when the .asp page tries to connect to the DB server.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
The web server is Windows 2000 Advanced Server, Dual CPU with
Hyperthreading, P4 with 2 GB R... more >>
Creating a login after the backup was restored with existent users
Posted by Cathy Boehm at 3/9/2005 10:17:03 AM
Is there a way to create the login id after the database backup with users
was restored into this new SQL Server. The problem is that I am trying to
create the login id for the user that owns practically all the database
objects.
So I can't drop that user to execute sp_grantdbaccess after cre... more >>
|