| Thread | Last Post | Replies |
|
| Problem with default schema | 02 Mar 2007 03:40 GMT | 5 |
under SQL Server 2005 I greatet a user with: USE MYDB CREATE USER TEST FOR LOGIN TEST WITH DEFAULT_SCHEMA = TEST ALTER LOGIN TEST WITH DEFAULT_DATABASE =MYDB
|
| Management Studio fails to connect to local db for new queries | 01 Mar 2007 18:38 GMT | 5 |
I've just installed SQL Server 2005 on my workstation, and attached an existing database using Management Studio. I can then browse the database in the Object Explorer and open the tables. But whenever I try to create a new query it fails to connect, and I can't
|
| Connectivity between vb 6.0 and Sql server 2000 (data base is in Server) | 01 Mar 2007 12:05 GMT | 1 |
Hai all I am sudhir I am facing problem to establish connection between vb 6.0 and ms sql server 2000, ie data base is in Server. I want to make conneciton
|
| [Microsoft][ODBC SQL Server Driver] error | 01 Mar 2007 04:57 GMT | 1 |
A strange thing has been happening for a month or so when I retrive data via QA. Sometimes the queries fail to run and I receive the following error messages. [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
|
| Calling SQLServerDatabaseMetaData methods | 01 Mar 2007 01:32 GMT | 3 |
Has anyone had success with calling SQLServerDatabaseMetaData methods (e.g. getDriverVersion, getDriverName, etc.). My attempts failed so I'm using the DatabaseMetaData methods instead. But if anyone is willing to share a working example using SQLServerDatabaseMetaData,
|
| Data Download via ODBC | 01 Mar 2007 01:20 GMT | 3 |
Server is SQL 2000 SP4. We are trying to pull some data from a Progress 9.1d server via ODBC. If I go to the local packages, open the package in question and execute it, everything runs fine and it gets the data. If I try and run the job manually from the job list in the SQL ...
|