Is there a registry key that will tell me if am running MSDE 7 or MS
SQL 7?
Thanks

Could someone please remind me hoe to change the date format in the output
grid when I run a query within Management Studio.
I'm sure this must be possible. I remember doing it for Query Analyzer under
SQL 2000, but can't find the setting within Management Studio.

I recently installed SQL Server 2005 Standard.  I am trying to open a new
connection server name: "2006-5316\Data" where 2006-5316 is the computer
name and it will not connect.  I am using Windows Authentication on the
computer with my login and Admin rights to the local computer ...

SQL Server 2000. There is a linked server and I want to replicate, in
TSQL only, the code that I could execute on another server to re-gen
it. It doesn't seem to be created if I "script all SQL objects" from
Enterprise Manager or SQL Workbench.

I installed SQL Server 2005, but I do not see SQL Server Service Manager
icon appearing in the notification area of the taskbar. Is there a way to put
it there?
thanks for the help!

Once i installed SQL server 2000 on my server it was working fine, but due to some reason i un-installed it, now when i am trying to re-install it , as message appears "Snapshot.exe unabale to locate" this is the caption of message box. in message box this message appears "This ...

I'm having problems instaling MSDE for some of my clients, the failure is:
InstallSQLAgentSecurity failed.
I saw a thread about it (from 1/9/07) but it was not completed with answers.
Can someone comment on that issue?

I'm trying to install SQL Server 2005 Standard Edition on Server 2003 Web
Edition. All the installation options are disabled except the workstation
components (the last check box). For example,. I'm not allowed to install
the key "SQL Server Database Services".

I am new to Virtualisation and I am sorry for some of the basic questions.
I have a requirement for 8 physical servers for our CRM project and I
thought to explore Virtualisation.
I am not asking for you to do the work for me but if you could just point me

I'm trying to install SQL Server SP2 on a SQL Server 2005 Developer Edition.
I'm running SQL Server 2005, SSAS 2005, SSIS 2005, & SSRS 2005 with SP1. (I
have also install VS 2005 Professional on this server.)
I've copied the SP2 exe file on the local C: drive of the SQL 2005 Server

I'm trying to install SP2 on a SQL Server 2005 SP1 installation on X64 on
2003 Server RC2 SP1 OS.
The installation is failing for the SQL Server Service. It is succeeding for
all other components. I have the log. Is there a specific string I should

What's the recommended approach(aka words of wisdom) to installing the RTM
SP2 for SQL Server 2005 on a machine that already has SP2 CTP installed? I
looked through the installation documentation (where it often tells how/if to
uninstall the "beta" versions) but I saw no such ...

For my dbs larger than 1GB, I'm giving up on Copy Database Wizard, which
means using the detach/attach method.  
The problem I'm having, however, is getting the detached files to the new
server.  Both the boxes have Ultrium 2 drives, I've tried backing up to tape

SP2 installed OK on a Windows XP computer with SQL Server developer edition.
I tried to install on a windows 2003 server with SQLExpress. The install
ran, but first screen listed NO updates for the SQL Express database engine.
Did I do something wrong?

I installed VS2005 on my WinXP Pro SP2 machine and SQL Express was installed
at the same time. I did not see SQL Server Management Studio so I tried
installing a Workgroup edition overtop. The install seemed to go okay except
for the Workstation Components and Books Online. These ...