does anyone know how to change the name of a view in sql2005?
it seems to be different than sql2000, where i would just go into
properties and be able to change the name of the view by editing the sql
code.  i dont seem to see where to do that.

What is the best way to upgrade/migrate to SQL Server 2005 (including
Reporting service)?
1. Upgrade in place
2. Set up another box for SQL 2005 and migrate

I'm trying to take best advantage of the hardware for the server which is
running sql server 2005 on win server 2003 r2.
The machine is fitted with 3GB of memory and runs very little other than SQL
Server 2005. I've increased the minimum server memory to 1024 MB and maximum

I was wondering if there is a way to secure a sql 2005 database.
i want to distribute an app and would prefer that any customers not be
able to get into the database and make changes to structures, or
basically steal the database design, especially if i distribute a trial

I am fairly new to sql2005 and have sql2005 Developer edition. I am loading
it on one-desktop (xp pro SP2) to learn how to upsize our Access dbs.
Can any one recommend the best Service Account setup.
1) Customize for each service account

Does anybody know how to unpublish the replicated databases without
going through deleting publication step by step? It can be done this
way but it's a pain when you need just to unpublish the database for
temporary to get some job done, and then to republish it. In Sql server

Hey guys.  I'm trying to understand how Windows handles addressable
memory with SQL Server.
I have read that Windows will give 2GB to apps, and save 2 for the OS /
Shared pool.  Right now, I have 2 GB of RAM in my box, but would like

According to this article(
http://www.windowsecurity.com/articles/Hacking_an_SQL_Server.html?printversion
) it doesn't take much to set up SQL service to run as a local user and not
LOCALSYSTEM... but I have tried that and I fail. The Sql service will not

I am trying to create a simple backup (full) of my sql server 2005 - with
the maintenanceplan wizard. But i keep getting this error - and i don't quite
get it.
Using the help buttons, sends me to some empty help site (on danish)

Please Help!
I am trying to install SQL 2005 Express on my Dell Laptop so I can use
Visual Web Developer and build ASP.Net Web apps and intanet files.
The installation hangs when it is installing the SQL Server Database

is it possible to export data from 2005 express and import it to sql server
2000 ?
TIA
Guy

any one know where I could find some standard deployment configuration for
SQL Reporting Services.
Thanks in advance!

I'm currently having a very frustrating time trying to connect a newly
installed Win 2003 Standard Edition (R2) web server to an existing SQL server
2000 db.
The web server needs to connect to three db's in all, one being server 2005

I'm attempting to install SQL Server 2005 Developer edition on Windows XP
Media Center SP2.
I get the error:
An installation package for the product Microsoft SQL Server VSS writer