|
|
|
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 SQLDMO connects to the wrong database Posted by Maer at 6/29/2006 5:30:24 PM Hi guys - I am not sure if this is the news group I should be writing
to, but I have been having a weird connection problem with an application
that I wrote in SQLDMO when it tries to access the server.
The server has several databases and my application tries to connect to
the "MyA...more >>
Create SQL 2000 user accounts with a script Posted by spburke at 6/29/2006 12:28:02 PM Is it possible to create multiple user accounts within SQL 2000 via a
script? We have a database on a development server that is overwritten
every night. I would like to be able to create a script to create the user
accounts needed. Any help or guidance would be appreciated. Thank you. ...more >>
Hard Code Native Error code in program? Posted by Larry at 6/29/2006 11:39:32 AM Using VB 6, sp6,
On sql server 2000 (sp4)
When I try to establish a connection to the database
from a VB 6 program using ADO, I get a similar message
if the UserID does not exist or if the UserID does exist
but does not have the permission to the database.
The NativeError number is differe...more >>
How can I create a passthrough query from a VBA code? Posted by asteroid at 6/28/2006 5:37:09 AM Hi!
I am trying to migrate the Back end of an MS Access based aplication to
an SQL server 2000. I KNOW how to use passthrough queries in MS Access.
So, my question is: How can I CREATE a passthrough query from a VBA
code?
I want to know WHERE to point that this will be a passthrough query? I
...more >>
LINK SERVER BAD PERFORMANTCE Posted by Chedva at 6/28/2006 12:00:00 AM A SP with join's between tables of 2 SQL 2000 linked server used to work
relatively quick.
Since a few weeks the same SP that runs on +/- the same amount of data takes
much more time (43 sec).
When i copied the DB so that the SP should run on the same server it takes
only 13 seconds.
Probab...more >>
Table names in Enterprise Manager and Access when linking tables Posted by Richard at 6/26/2006 9:03:18 PM Hi.
I have a SQL 2000 server that I have created a number of tables. When I
connect to the database using ODBC with ACCESS the table names appear to
have my user details added to the front.
ie. I create a table in Enterprise manager called "names"
When I try to link to the tables with a...more >>
MS SQL Server Express connection error from VB.net Program Posted by Sujata P at 6/26/2006 5:56:02 PM I am trying to make new connection with SQL Server 2005 Express Database from
my Visual Basic.Net program. I am using connection string as "Dim
connectionString As String = "Data Source=.\SQLEXPRESS;Initial
Catalog=MgmtSystem;User Instance=True".
But it is giving me error as " Failed to gener...more >>
Linked Server Oracle 10g problem Posted by Hob_Naggers at 6/26/2006 5:14:01 PM I have followed the examples from MS. to create the link between my MSSQL2005
and Oracle 10g
I have all of the Oracle client installed on the server.
I have a net service defined.
Here is what I ran to create link:
EXEC sp_addlinkedserver 'OraLinkServer2', 'Oracle', 'MSDAORA', 'HPRD89...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem to delete a user Posted by Pedro at 6/26/2006 8:51:02 AM Hi,
I have a problem to delete a user and it gives me this message in SQL2K5:
The database principal owns a schema in the database, and cannot be dropped.
(.Net SqlClient Data Provider)
Can any body help me. I will be grateful
This databade came from a SQL2K and I can connect from any ...more >>
sql server2005 issue for the connection Posted by Nilkanth Desai at 6/26/2006 2:54:02 AM "The request failed or the service did not the respond in a timely fashion"
I am using xp servicepack 2.0 and sql server 2005 developer edition...more >>
Cannot login using 'sa' user name and password Posted by Mike9900 at 6/25/2006 12:08:01 PM Hello,
When I try to connect it give the following message I copied from the log:
Source Logon
Message
Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection. [CLIENT: <local machine>]
I am using Win 2003 Ent. and is domain controller. I use ad...more >>
Multiple Threads and Licensing Posted by Patrick Brand at 6/22/2006 2:33:02 PM Hello,
I am working on a project that will require the use of SQL Server 2005
Workgroup Edition. We were planning to use the version that comes with
5 CALs instead of the version that is licensed based on processors due
to the enormous cost difference.
The application I am working on is...more >>
Images in SQL Posted by I notice that SQL 2000 has a datatype of image.
My question is after I setup the table and fields how do I populate the
table with image data?
...more >>
Connecting via VPN Posted by Middletree at 6/21/2006 1:27:23 PM One my company's customers has allowed me to connect to their network via
VPN. Overall, it seems to work fine. I can remote in, or map drives, etc.
However, I have been unable to use my SQL2000 Enterprise manager to connect
to their database. I can remote into the machine where that database r...more >>
in sql server 2000+ is there some stored procedure that shows your current disk space usage? Posted by Daniel at 6/20/2006 4:18:33 PM in sql server 2000+ is there some stored procedure that shows your current
disk space usage?
...more >>
MSSQL 2000 Developer connection limit & boolean connection Posted by J.H at 6/20/2006 9:08:34 AM Dear All,
I've been searching the MSDN web for the MSSQL 2000 Developer connection
limit.
However, could not find any authentic documentation that says MSSQL 2000
Developer
connection information.
With MSSQL 2000 Developer Edition, do we have any limitation of connection
direct to
databa...more >>
Sometimes yes, sometimes no, connect to a SQL 2005 Server Posted by Javier at 6/19/2006 8:26:02 AM I have the problem that at times I can't connected to the database via
Microsoft SQL Server Management Studio.
The error is: "Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding".
But in other times I can obtain a positive conne...more >>
Windows Server 2003 vs. Windows 98 Posted by LUIS at 6/16/2006 7:20:02 AM I am using MS SQL Server 2000 in a server with Windows Server 2000.
Workstations with Windows XP and Windows 2000 do noy have problems to connect
with, but the ones with Windows 98/second edition/last updates and service
packs cannot do so, specificaly it is impossible to create an ODBC connec...more >>
Connecting to wrong SQL Server Posted by Tosch at 6/15/2006 8:47:26 AM I have a machine where I have installed Visual Studio 2005 including SQLExpress. I have also installed MSDE2000. They are both named instances:
MyMachine\SQLExpress and MyMachine\S3MSDE.
Locally everything works fine. But when I connect to MyMachine from an other machine with the connectstring ...more >>
Where is my database? Posted by Giuseppe Pezzella at 6/14/2006 11:07:13 PM Dear friends
I have written this code for create a database in my sql server express =
(for to be clear after this program I think to found program in my =
server where there is Master, ecc. Instead the program have create the =
file in:
C:\Documents and Settings\Giuseppe\Impostazioni locali\...more >>
Sql 2000 connect fine in Win 2000, but not in Win server 2003 Posted by Angela at 6/14/2006 1:02:01 AM I have a web application which uses SQLOLEDB for connecting SQL server 2000
database (sp4). The application server and database server both runs on Win
2000.
strConn = "Provider=SQLOLEDB; "
strConn = strConn & "Data Source=PC; "
strConn = strConn & "Initial Catalog=ABC; "
strConn = strC...more >>
Enable SQL Server Remote Connections via Script Posted by ramadu at 6/12/2006 1:51:06 PM Hi,
I am connecting to my SQL server 2005 database using a remote connection.
Can someone provide me with a SQL script which will enable connections
via TCP/IP to the database? (i.e. I'd like to do the step of going to
the configuration manager and enabling the TCP/IP protocol for the SQL ...more >>
In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT field is many megabytes but i only wat 10k at a time? how to do this in ADO Posted by Daniel at 6/8/2006 6:50:15 PM In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT
field is many megabytes but i only wat 10k at a time? how to do this in
ADO.net?
...more >>
SQL Server 2005 Express Edition :: Connection Limit Posted by Muhittin Kara at 6/8/2006 2:58:04 PM MSDE has a connection limit (as far as i remember, you can't open more than
20 connections at the same time) but other editions of SQL 2000 has no limit
for opening connections. Is there a limit for how many connections can be
opened to SQL 2005 Express edition at the same time.
...more >>
how to display 10 rows at a time when 1000's returned form sql query Posted by Daniel at 6/7/2006 10:15:23 PM how to display 10 rows at a time when 1000's returned form sql query
how to select the 20th-30th row in a where clause? e.g. select the 20th to
30th employee who name is 'bob' in tsql. i need this because my select often
returns 1000s of rows and i want to display them in pages of 10 at a tim...more >>
Exclusive Connection Posted by Tom Gaughan at 6/7/2006 1:02:08 PM Is there a way to establish an exclusive SQL 2000 connection, i.e. only
allow 1 user to connect?
In Access I am able using a file DSN with Exclusive=1. Is there a similar
property to use in the connect string or ADO connection object (I do not see
anything glaring there)?
Thanks - Tom
...more >>
failed to connect to SQL server from asp.net Posted by ajfish NO[at]SPAM blueyonder.co.uk at 6/7/2006 9:45:37 AM Hello,
I have an asp.net application which connects to SQL server using the
normal ado.net mechanism. One customer cannot get it to connect to the
database. his connection string is
user id=aaaa;password=bbbb;initial catalog=cccc;server=dddd
and he gets the message:
Cannot open databas...more >>
Sharing databases netween SQL 2000 and 2005 Posted by Dick at 6/7/2006 5:18:02 AM Is there a way to avoid the following problem:
I have a database created in SQL 2000. I detatch it from the SQL 2000
instance. I attach it to a SQL 2005 instance (I can see the compatibility
mode is SQL 2000). I detatch it from the SQL 2005 instance. I try to reattach
it to a SQL 2000 insta...more >>
txn isolation level and connection pooling Posted by Vikram Vamshi at 6/6/2006 11:55:02 AM Hi All,
Should the transaction isolation level persist across the reuse of a
connection from the connection pool?
From my experiment it does persist and I was not expecting it.
I was under the impression that "sp_reset_connection" will tear down all the
connection level settings and go back t...more >>
HELP - Connecting SQL Express Edition Posted by Soko at 6/6/2006 12:00:00 AM I have two machines and same problem.
I installed SQL EE on XP HOME EDITION it is OK !
Localy work OK !
I try to connect from another machine with SQL Server Management Studio and
I can't.
I some how successed to connect with named pipes but TCP/IP is not working.
I turn on all protocol...more >>
Schema Change of a Progress DB causes Linked Server to Fail Posted by Brian Drab at 6/5/2006 10:50:20 PM We use SQL Server 2000 and have a Linked Server to a Progress 9.1E
Database. Everything works fine until a schema change is made in the
Progress database. We then get an error message similar to the following:
OLE DB provider 'MSDASQL' supplied inconsistent metadata.
An extra column was su...more >>
Is it possible to make linked server from SQL Server 2000 to MySQL Posted by Chen at 6/5/2006 12:29:02 PM Hi All,
I need transfer data from MySQL to SQL Server 2000. Does anyone know how to
make a linked server from SQL Server 2000 (SP3 or SP4) to MySQL? If it's
possible, I need install MySQL client software in my SQL Server box. Am I
right? What kind procedures I need follow?
Regards!
-Chen
...more >>
Problem with sql server connection sting Posted by Jack at 6/5/2006 9:24:01 AM Hi,
I am testing a asp page using sql server as the backend database. However, I
cannot connect to the database from asp. I have the following error coming
and I have also added the connection string that goes with the asp page.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E...more >>
Can't make a new Login Posted by Pedro at 6/5/2006 6:33:01 AM Hi,
I have this problem:
When I create a new Login with a "SQL server authentication".
And if I change some User Mapping and Server Roles it gives me the follow
message "Create failed for User 'win2kadmin "
Server Name: SERVER\SERVER
Error Number: 15023
Severity: 16
State: 1
Line Numbe...more >>
Run SQL against SQL Server 2000 on Windows 2003 Web Edition Posted by AJ at 6/5/2006 4:35:02 AM I have a dedicated Windows 2003 Web Edition server running SQL Server 2000.
SQL Server 2000 was pre-installed. What tools can I use to interrogate and
update the SQL Server 2000 database from the Windows 2003 Web Edition Server?
Client and Adminstration tools are not supported and will not ...more >>
Developing with SQL Server 2000 and SQL Server 2005 on same machine. Posted by Dan Sikorsky at 6/3/2006 12:00:00 AM
I have SQL Server 2000 installed which has a server name of NOTEBOOKDELL.
I installed SQL Server 2005 Community Technology Review last October, 2005,
and somehow gave it a server name of NOTEBOOKDELL\SQL2005 so that I can keep
my SQL Server 2005 databases separate.
All was well until I...more >>
Using SQL Against SQL Server, Rename A Column?? Posted by ods at 6/2/2006 2:32:18 PM I need to rename a column in a table in a sql server database from my .NET
program. I can't seem to find the syntax to do this. Can it be done just
using sql?
Thanks
db...more >>
Rename A Field Using SQL Statement? Posted by ods at 6/2/2006 1:08:18 PM Is there a way that i can rename some fields in a table using SQL from my
..NET program? The customer send sthem in as BMT Number and I need
BMT_Number, etc.
Thanks
db...more >>
Emergency: lost connection to SQL Server Posted by Randall Arnold at 6/1/2006 3:02:27 PM For some unknown reason we just lost the connection to our local SQL server.
The error message is "Connection failed, check sql server registration
properties". I can't find any usable info on this cryptic error message.
Nothing was being done to the server around the time that this happened...more >>
need assistance on connecting to sql server Posted by MrRAO at 6/1/2006 11:41:01 AM Connect to Sql Server
>> SQL Server: [____________]
Connect using:
[ ] Window authentication
[ ] Sql Server authentication
Login Name : [____________]
Password : [____________]
-----------------------------------------------------------------------------------------...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |