I work in a domain environment with a couple of Enterprise Edition SQL
Servers. Using SSMS, when I go to register a new installation and I 'Browse
for more' in the dialog box, I see a whole bunch of workstations that I know
are set up with MSDE.

I'm trying to connect to SQL Server 2000 using the SQL Server 2005 1.1
JDBC  drivers using integratedSecurity=true.  However whenever I try
to connect I'm thrown the following exception;
com.microsoft.sqlserver.jdbc.SQLServerException: An exception

i'm looking after the possibility of importing / exporting data from / to
Excel and Access.
Thanks for help
Casper

I receive Error 340: General Error when I try to open MSSQL7, Enterprise
Manager.  Can someone help Please?

Can we create a new Package in SQL Server (T-SQL). Oracle has the option of creating a new package using 'CREATE PACKAGE'
Is SQL Server has anything similar to this.

I installed the SQL Server Express 2005 + SP2 on Windows XP x64 +SP2, the
TCP/IP, Named Pipes and SQL Browser services are enabled, and client
computer runns under Windows 2000 with Native Client driver installed.
I can connect the instance with ADO or Native Client within the same

Is it possible (and if so, how?) to export the list job tasks (with status,
last run, etc.) from SQL Server to a table (in the same SQL Server) so I can
create a simple ASP file showing the results?
Also, that export process should be running periodically because I don't

We had to rename the hostname of a server where SQL 2005 and Analysis
services were installed. SQL 2005 picked up the change no problem, but when
we try to connect to the Analysis services side of things, it's still
connecting to the old host name. I've been digging around and ...

I'm quite new to SQL Server so maybe this is an easy question but I haven't
found the answer after 3+ hours of Googling and experimenting.
I have a simple set up - two computers named HELEN and DELORES, both running
Win XP Pro, SP2. These machines are connected via a home network ...

May you help for beginner.
I have installed MS SQL server 2005 to local computer. I can not connect to
Server type "Analysis  Services" from Management studio.
Message "A connection cannot be made. Ensure that the server is running.

I HAVE SQL2005 32 BIT ( TEST)    AND SECOND MACHINE 64 BIt
(PRODUCTION).
IN 32 BIT I LINKED SUCCESFULL  DBASE FOLDER (FILES CLIPPER) BY
OPENROWSET BY:

Is there a limit to the number of users that can be connected to a SQL Server
2005 Express instance?
If the hardware is beefy enough, could it support 20 or 30 simultaneous
connections?

It has been stated that Microsoft will "not" provide a 64 bit version of
MSDASQL...but I have found a response from the MDAC Team stating otherwise
(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1239339&SiteID=1).  
When will this be available (dates please)??  We are ...

I have a server running SQL Server 2005 Ent. Ed. SP2 and locally, I can see
the default instance and two SQLExpress instances named 'sqlexpress' and
'officeservers', all withing SSMS, and can connect and manage them.
From my workstation, running SQL 2005 Dev, SP2, I can connect to ...

I have a problem using an jet database as a linked server.
when there is no database password on the mdb database everything is working
fine.
When I put a password an the mdb database I receive the error: