Is it possible to connect to SQL Server 2000 Analysis Server from SQL Server
2005 Management Studio? Should I use some special settings to SQL Server
2000 Serevr or SQL Server 2005 Client? I`ve tried to connect in the same way
i do it for 2005 Analyzis Server (using Widows ...

I'm stuck here - if I use grouping on my userID and select MaxDistinct on
the date/time stamp, how do I pull in the "last comment" from the record,
since it obviously can't be grouped (else ALL the records will show since
all comment fields are different).  Help?

I'd like advices about an idea I add to resolve a problem. thanks to
you in advance for yours answers.
I have a database with tables that I load with flat file. The size of
each table is 600 Mb. The flat file are the image of an application

I have Windows 2003 Server and installed SQL Server 2000 Sp 4 behind the
firewall. I open the Portal 3389 TCP, 1433 TCP, 1434 UPD. when I try to
connect SQL Server from my local box it says SQL Server doesn't exists or
access denied.

I'm just know basic SQL but not enough to write any complex queries.
The problem I'm facing right now keeps me thinking to use a Cursor but
I've seen a lot of posts on here saying Cursors are bad so I'm hoping
there is a complex query that can give me the data I need.

Man do I struggle with Enterprise Manager as a graphical tool for
building views etc.
Its flaky and hangs frequenlty so i have to kill it with the task
manager and re open it.

Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone

I am trying to do a bulk insert
here is the error:
Server: Msg 4860, Level 16, State 1, Line 1
Could not bulk insert. File 'c:\what.fmt' does not exist.

OK, I thought I had it, but I don't.  The following query is intended to
bring in a complete list of ModuleIDs for the selected user.  Problem is,
when I filter, if another user has a ModuleID "2" record, then the "2"
record won't come in for the current user - I guess because ...

Y'all:
I am needing some way, in the SQL Server dialect of SQL, to escape unicode
code points that are embedded within an nvarchar string in a SQL script,
e.g. in Java I can do:

I don't understand why my left outer join isn't giving me "null" records on
the side where there is no matching record....  Is this enough info to
trouble shoot?
SELECT     TOP 100 PERCENT dbo.cert_m.ModuleID, dbo.cert_m.SortOrder,

I'm planning the structure of a SqlServer 2005 database for a new
application.
The requirement is that primary keys must be "natural"; i.e. in the table
Customers the primary key will be a max. 10 characters string (but the

How the heck do I get permission to use SQL Server from
a System DSN on a webpage?
I am using VBScript and ASP Classic and ADO (Classic), thus:
         myConnection.Open "DSN=MySystemDSN"  

How do I modify a defined stored procedure?
Thanks
ascll

Hi Friends,
How to transpose the columns into rows
i want to convert the table which looks like this
ID Name HomePhone WorkPhone Email