I have a view in SQL Server 2005 that is sorted. When I import to Excel, it
comes in not sorted. Where the problem on this? I also posted on Excel Gen
Questions. Thanks.

How can I go about safely renaming the data and log files for a
database?
Thanks.

We use Avaya IP Office. Call records are stored in programs such as Delta
Server and Database Server Supervisor and backed up with SDX Archiver.
Avaya says it's using Microsoft's SQL database.
Question: How do I restore a database? I have a .BAK file that I need to

We have an application that collects data from two databases (DB1 and DB2) on
the same server. We also have triggers on some tables on DB2 that update an
"index\lookup" table in DB1.
DB2 is a fast growing database with a lot of inserts and updates, therefore

I have a problem that I'm hoping someone will be able to help me
resolve.
1)  I have a C# Web Site in which I connect to the database:  "Install
Microsoft SQL Server 2005 Express Edition" via the link on:

I have a stored procedure that if I run it takes over 40 minutes to
complete.  I use exec stored_procname and parameters.
However, if I run just the inside of the stored procedure (just the
code) with hard coded parameters it takes under a minute to

I have a database which has been moved from one server to another using
backup/restore. Of course there were some problems with mapping of
userid to logins. That was solved by running sp_change_users_login.
But one problem remains. I had one userid that I had aliased to dbo.

Are there any books/article/forum posts out there that document the
best practices for SQL Server security?
For example,  what account should create the database?
What account should create the schema?

My application is to get some data from SQL/OLAP server.
When I try to open OleDbConnection using connection string:
"Provider=MSOLAP;Data Source=servername;Initial Catalog=dbname;"
I get message:

I am running SQL Server 2000 and was wondering if there was a way to query
the state of any given SQL Agent job? So i want to setup a seperate SQL Agent
job that's going to go out and tell me if a particular sql agent job is in a
"Executing Job Step 'x'" status or in a "Not ...

Does anyone know how to do the search and replace in multiple stored
procedures using SQL 2005 Management Studio?
Any help will be appreciated.
Thanks!

Can SQL Server 2000 + sp3 work  on Windows Server 2003 enterprise edition R2
Please I need a reply urgently

This is more looking for an opinion then a clear answer
I have a Point Of Sale table that has 500 million records
Contains
PointOfSaleID Primary Key BIGINT

I know this might seem like a strange question, but we currently have a
database that very few people have heard of TurboPower FlashFiler
(http://sourceforge.net/projects/tpflashfiler/). We have had issues with it
as we approach 100 users.  We have installed SQL 2005 Enterprise ...

I have an interesting situation.  We have the following scenario:
1.  Server A, Database A, table A as the replication publisher
2.  Server B, Database B, table B as the replication subscriber.
3.  Server B, Database C