|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Connect Posted by William Stacey [MVP] at 11/7/2005 10:13:14 PM How come I have to connect to my MSSQLSERVER instance using only "." or
"<hostname>", yet it does not work with ".\MSSQLSERVER"? Yet all other
instances require the host\instance format? This seems a bit strange and
inconsistent. Also, the common dialogs should be:
Server: <host>
Instance:...more >>
PLASE HELP - remote connectivity to named instance of 2005 Posted by Carlos at 11/7/2005 10:05:35 PM Hi all,
I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the remote connection string from
an ASP .Net page which works fine already in 2000. However it does not work
in 2005.
In 2005, I went to configuration Manager/Protocols/TCP IP, and e...more >>
SQL server 2000 installation Posted by Nada Sherief at 11/7/2005 3:57:26 PM
hello,
1-I want a detailed step by step tutorial for installing SQL server 2000.
2- I want to install two SQL servers 2000 on the same machine, how could
i do that? (i mean will there be any change in the installation to the second
server?)
3- I want to know how to connect between these t...more >>
derived horizontal partitioning on SQL server 2000 Posted by Nada Sherief at 11/7/2005 3:47:44 PM
hello
i want someone to help me in solving a problem in sql server 2000
considering that i have a table named PAY(TITLE, SAL) where TITLE is the
primary key of this table
also this table is related to another one named EMP, where the other table
has a foreign
key to this table.
ta...more >>
best practice -- connecting to run database creation script Posted by William Sullivan at 11/7/2005 1:01:03 PM I want to run a database creation sql script. The problem (I believe) is
that I have to specify the database I wish to connect to when connecting to
the server (ADO). Should I specify the Main database? Or is there a way
around this?...more >>
Error 165 - Sql state Hy000 Posted by Pupo at 11/7/2005 9:42:44 AM Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
...more >>
RE: Linked server latency Posted by Murali at 11/7/2005 12:15:46 AM Hi there,
I have a two Linked servers in a database. One of them is colocated in the
same lan and the other server is across the country(California to Florida).
We have a dedicated T1's(8 of them) between these two location. I have a
stored procedure that decides which server to query t...more >>
ver 2000 vs 2005 Posted by Carlos at 11/5/2005 11:26:58 PM Hi all,
I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the connection string fro an ASP
..Net page which works fine already in
2000. However it does not work in 2005.
In 2005, I went to configuration Manager/Protocols/TCP IP, and entered 1...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Attaching Database 'AdventureWorks'??? Posted by Steve at 11/3/2005 2:42:02 PM Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'....more >>
General Network Error Posted by microteq at 11/3/2005 2:31:06 AM Hi,
we have written a vb.net program using SQL Server 2000 SP4 over OLEDB.
Our customer has a network which is sometimes quite instable. So we did
some tests in our office, because we wanted to help our customer by
redisigning some of our SQL calls.
When we start the program and disconnect ...more >>
MSsql Standard connect error Posted by wojtas_z at 11/3/2005 2:09:48 AM Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant ...more >>
SQL Native Client install Posted by Mike Frank at 11/3/2005 12:00:00 AM Is it possible and if yes how to install just a SQL Native Client on a
client machine.
This is for a SQL Express Edition installation.
Mike...more >>
Intermittent SQL Server does not exist or access denied. Posted by roxy636 NO[at]SPAM yahoo.com at 11/2/2005 10:32:52 AM ASP.NET application with intermittent returns of 503 errors with the
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.
An unhandled exception was generated during the execution of the
current web re...more >>
Connecting a SQL-DMO 7 client program to a sql 2K server Posted by Phil at 11/2/2005 1:04:06 AM Hi,
We are running a client program on NT 4 using SQL-DMO objects. We have
upgraded the server (on another box) from NT4/Sqlserver 7 to WS
2003/Sqlserver 2K. Our Sql-DMO program is now returning an error.
We would like to avoid to upgrade the NT4 client box for stability reasons.
The doc i...more >>
Not associated with a trusted SQL Server connection??? Posted by Andrew at 11/1/2005 8:53:01 PM Hi, friends,
When I used ADO.Net to connect to our SQL Server, I got the error saying:
Login failed for user 'mscn'. Reason: Not associated with a trusted SQL
Server connection.
What did this mean? I created this user for msc database already! And the
connection string is:
"packet si...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |