Is it possible to link access tables to a sql server 2005 db? I can't seem
to find any option in Management Studio.
Thanks
Regards

I have the following two questions:
1) If auto update statistics is on, would there ever be a reason why I might
want to run update statistics manually or via maintenance plan?
2) What condition triggers auto update statistics to run? If there are many

Ok, I have seen quite a few statements to find fragmentation, but none tell
me what Indexes need defragmented.  I am working with SQL Server 2008 and I
have a few databases and tables.  What I want to do is find out what Indexes
need defragmentated, I need to know their names so I ...

I'm looking at tables that have both high insert/update activity and high
select activity and according to some information, are frequently getting
page level locks when being modified. This is increasing the time the
selects are taking.

Is sql server express ok for a 20 user contacts database which is used
mostly for queries and rarely has updates or inserts?
Many Thanks
Regards

I am in need of some help.  I am very new at SQL so please disregard my
ignorance.  
I have a table where I have a field named “persNo”  is set up as the primary
key. This is working well as I don’t want duplicate records.  The problem is

Finding that SQL Server automatically created an index for a PK was no
surprise, in fact, it was expected - how else can uniqueness be enforced in
a system that only provides b-tree indexes.
However, finding that a FK does NOT get an index by default and that it must

I have an ALTER table script that adds a new column. Problem is, it
adds it to the bottom of the list of columns. Is there a way to insert
it into a particular position, without having to read all the data
into a different table, recreated the table, and get all the data back

Can you restore a backup from newer version of SQL Server to older
version if in compatbility mode?
i.e. there is a db on SQL2005 running in SQL2000 compatibility mode.
Can you restore a backup of this db onto SQL 2000?

I would like to replace a value in a column provided it meets my conditions.
For instance, if formtype = w123' then set formtype = 'PRO' if formtype =
'w344' then set formtype = 'INT'.
I am fairly new to creating a stored procedure on SQLServer. Do you think

Hello, I'm new to SQL Profiler.  I've created a .trc file and saved it
to disk.  I can open the .trc file but I want to now save this
existing file to a table.  When I go under Save As all the options are
grayed out.  I have another .trc file and when I open that file and

hi, we have a sql server 2000 sp3 on a w2003 and some days ago we installed
sp4 to that sql instance. We are having some big problems with queries really
slow down, taking to much long to complete or locking to themselves, ie. spid
105 locked by spid 105 if you throw a sp_who2.

I am trying to create index view fore that I went to create view with
schemabinding .
If I try table in same database it work properly. But my database is
different from I went to create view.

SQL Server 2005 Express.
25 january 2007 I added a new procedure to my database using ole automation
procedures such as sp_OACreate and sp_OAMethod.
These system procedures requires 'Ole Automation Procedures' to be enabled.

After I moved my sysdatabases and error log to another drive, I
restarted the sql server services. The databases look fine but sql
server agent won't start.
In the error log/windows event log, there's no error message except