We want to run Unix Scripts on SunSolaris which Connected to MS SQL
Server 2000.
We would like to connect to SQL Server 2000 from Solaris. Is there any
way to connect to Sql Server 2000 natively (just like isql we use in

SQL Server 2000
Howdy All.
Is it going to be faster to join several tables together and then
select what I need from the set or is it more efficient to select only

Hi groups,
I have taken backup of my local database say employee.bak
I'm sending this Sql db backup file(employee.bak) to my headoffice, where they have to restore this database and its data with this single file.
But my headoffice people dont know my database name, but they will ...

Before I have my client purchase SQL Server I wanted to intall the trial
version and test it.  During installation, I got a message that SQL Server
2000 SP2 was not compatible with the operating system (Windows 2003 Server).
I installed it anyway, but was not able to find it with ...

  I am looking for a good SQL Server Editor which can be used for
writting stored procedures, doing queries etc. It should have features
like autocomplete and so on. Any recommendations.
Thanks !

I'm trying to import data from Excel to SQL Server 2000, but I don't get all
the data not even half of all the rows.
The Excel sheet contains 24600 rows. Is there a limit in SQL? I also tried
to import the data from a text file with the same result.

I built a database by using a generated script from the original
database. It built the System Store Procedures as User type. How do I
change them back to System type?

At a previous job I used Enterprise Manager on my desktop to manage tables
and queries on our SQL server. I'm wanting to download it to another machine,
and I can't find where to download it from the Microsoft site. I remember
getting it from there before, but now...

Is it possible to exclude a column from a trigger, I mean, I want the
trigger to fire if any colomn is updated except one of them.
the reason is I have many columns.

Is there a way to figure out when was the last time someone connected to
a database?  SQL 2000 environment.
Thanks,
Raziq.

I have a table with about 305 million rows, and a composite primary key
that consists of an ascending int and an ascending varchar(18), which
is typically of length 13. Even if all the keys used the full 18
characters of the varchar, it seems to me each key should be 22 bytes,

wanted to use sp_OACreate, sp_OAMethod and sp_OADestroy to execute a
DTS package from a stored procedure.  I had the dba (using the sa
account) create a wrapper stored procedure as recommended in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsq....

Trying to install SQL Server 2005 beta version on partition disk drive say
F:\ (Other than local disk drive c:\),
Does anyone know how can I do this? During the installation, it never asks
me on which drive it install to nor browse button is there to browse the

We had been running SQL Server without any control of security  (since
the company is very small -100 employees). All of us know the admin
password and has been accessing the database as admin. Our database
server crashed due to hardware failure twice last month and we lost a

I need to limit results in the following query type:
http://www.somewhere.com/php/sql-a.php3?server=1&db=mydatabase&table=mytable&sql
_query=SELECT+Field_1%2CField_2%2CField_3%2Cidno+from+mytable+where+1+and+field_
1+like+%22string%22+&sql_order=&pos=1
I found a reference that says I ...