Does anyone know if it is possible to install management studio for x64
edition on XP 32bit? (without also getting x86 media)

Is there a way to use the Generate Script option, generate SQL for DB, but
not with all the comments it puts.. I am trying to use this SQL, to store it
in file then use the file from the program to manually create my DB.... the
comments are causing error,

don't know if this is a bug or an undocumented feature but i installed SQL
2005 on a server in our network. i wrote some php pages to connect and get
the data. I track the time what time i costs to execute to query through php.
And here comes to funny part:

I'm using Visual Studio 2005 + MSSQL Developer edition 2005 (SP1) +
WinXP (SP2).
I'm experiencing this major problem. Whenever SQL Server Management
Studio (SSMS) is started, the execution of ASP .NET application

I have a promotional set of three microsoft titles of software (Ready to
Launch) which were handed out at a Microsoft event.  One of these is MS
SQL Server 2005 Standard with 1 CAL.  I don't find anything in the EULA,
so is it legal to install, register and use this promo version ...

I originally posted this question in the programming group but then it
occured to me that this is probably the correct venue.  I am trying to
create a report from a SQL Server 2000 database.  My trouble is that I can't
quite figure out the relationship between various tables, I ...

I’ve been doing some time test between Sql 2000 sp3a and Sql 2005.
Test Database Server = Server 1
It’s a dual 1800 AMD, 2 Gig or RAM
Sql 2000 on the default instance

Hi, I just downloaded the SQL Analyzer Tool, created the sqlbpa db, what do i
need to do to begin, review the analysis?
Thanks!

I have to backup two related databases in two different SQL servers. I
understand that the way to go is to use marked transactions. So my first
question is if this is the only way to do it and second is there a way to
create marked transaction logs using Enterprise Manager, not ...

When I try the following:
exec sp_configure 'min server memory (MB)'
I get the following error:
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51

using SQL SERVER 2K is it possible to filter Profiler to look at a specific sp.
currently, I am filtering by databasename and loginname and this is pretty
good.  I tried to enter % usp_mysp % in the Text but profiler kept returning
rows with the Text column blank.  The sp I am ...

I used DTS to copy one database to a blank database for a backup of the
database. A duplicate database.
How do I copy over the user logins to the new database.
This did not happen with DTS.

Every now and then I consider SSIS / DTS for a task like this:
“Here is a MS-Excel file. A secretary recorded eBay auctions over years in
it. It is not normalized containing the columns article number, auction
number, description, date/time, and price. There is one MS-Excel sheet ...

I need to administer a remote MS SQL server. MS SQL Server Manager Express
Edition won't install on my client PC because MSSQL server is not installed.
Is there an app that I can install to administer the remote server?

Environment : Win Svr 2003/SQL Svr 2000
As far as I know, to specify a UNC path for backup location, MSSQLServer
service should be running with an account that can access network resources...
As you know, by default, SQL Svr 2000 is installed with LocalSystem account.