all groups > sql server connect > august 2007 > threads for august 1 - 7, 2007
Filter by week: 1 2 3 4 5
Pay Attention Please...
Posted by Feri Sh at 8/7/2007 12:25:13 AM
Dear Sir,
Actually i want to ask, how to install the SQL Server Desktop Edition
2000 Client Tools only from the Command Prompt ? i have gone through the
internet but all the responds were about SQL Server Desktop Edition
2005, and it does not work for SQL Server Desktop Edition 2000.
I just ... more >>
How to specify an instance name in a SQL statement
Posted by DMurray at 8/6/2007 11:10:03 AM
Hello,
I am trying to get info from a linked server, but the instance is not the
default instance. I have tried:
select *from myserver\myinstance.mydb.dbo.mytable
but get a syntax error due to the backslash.
How should I specify the instance I wish to use?
Thanks in advance
Dave... more >>
SQL 2005 Performance
Posted by N Rajan at 8/6/2007 3:24:01 AM
HI,
Currently would like to migrate my server from Win 2000 running SQL 2000 to
Win 2003 and SQL 2005. We do have 2 inhouse program and ACCPAC (accounting)
pack accessing the SQL database. According to my 3rd party software house
that changing to SQL 2005 the performance is slower compared to... more >>
[DBNETLIB][ConnectionWrite (send()).]General network error
Posted by soonyu at 8/5/2007 9:14:01 PM
SQL Server Spec
SQL 2000, 8.00.2187 SP4 standard edition
windows 2003 SP1
sqlserver driver 2000.86.1830.00
webserver
windows 2003 r2, standard edition service pack2
sqlserver driver 2000.86.3959.00
we received "intermittance"
Error Number -2147467259 (&H80004005)
[DBNETLIB][Connection... more >>
Linked server strangeness in SQL 2005 Mgmt Studio
Posted by DWalker at 8/3/2007 2:52:38 PM
The user interface for SQL 2005 Management Studio is strange when you're
messing with a linked 2000 server default instance. Maybe this isn't
supported. :-)
In the Object Explorer, go to the Linked Servers item, right-click and
select "New Linked Server".
In the "Linked Server" box, gi... more >>
Create view "disconnected" (correct group this time)
Posted by DWalker at 8/3/2007 1:45:05 PM
Oops, I accidentally put this in the wrong newsgroup the first time. I
think this is a better location. Sorry for the double-post.
I occasionally need to create or alter a view that references a linked
server, where the linked server is not currently online (or my Internet
connection... more >>
Powerbuilder 10.5.1.6662 Connection to SQL Server 2005
Posted by dmmcgrue at 8/3/2007 6:11:11 AM
Recently, an application has been migrated from Powerbuilder 9.0 to
Powerbuilder 10.5 Build 6662. This application uses an .INI file
located in the Windows folder. The connection to the database, which
has also been migrated from SQL 2000 to SQL 2005 is as follows:
[database]
DBMS=3DOLE DB... more >>
SQL 2005 Express
Posted by Charlie at 8/2/2007 8:15:20 PM
I am new to SQL Server, and using the Express edition. I can't seem to find
the way to create relationships between tables. Any reference info will be
appreciated.
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
problem connectin sql server from remote
Posted by Roy Goldhammer at 8/1/2007 12:00:00 AM
Hello there
I've got this error when i tried to connect sql server from biztalk on
another domain:
provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server
where can be the problem?
... more >>
|