What Protocols should be enabled using a local copy of SQL Express?
Shared Memory
Name Pipes
TCP/IP

Gurus,
Running SQL Server 2005 SP2 and using named instances.  I am having lots of
important application databases on my server these days.  My question is
this.  Is it better to back up all server databases in one maintenance plan

Gurus,
Running SQL Server 2005 SP2 default instance on top of Windows Server 2003
SP2.  Everything is working fine however I noticed that under server roles,
the roles are all there EXCEPT for "Public".  Really strange.  Anyone ever

i´m trying to change this setting on the Sql  Management studio database
properties but it doesn´t let me. If i change it to unrestricted it
automaticaly changes to restricted to a specific value.
How can i change this??

I am wondering if anyone has created T-SQL that lists various categories of SQL 2005 objects that quickly lists them.  For example, if I wanted to see all the system objects that were related to triggers or if I wanted to see all objects related to constraints.  Basically a ...

I'm trying to put together a query that will return number 1 for the first
week of the year that starts on a monday. I've found the following query:
select datepart(week, DateAdd(day, -1 * DATEPART (dw, '06-JAN-2008') -1,
'06-JAN-2008' ))

In my envrionment not all the tables have datetime field that
indicates when the row is created or updated.  Coming up a DW project
that will be implemented I would like to ask the community what kind
of techniques they use for Incremental data loading.  There are some

We are migrating our website to a new hosting site.  The site has a
CMS written in C# with a SQL Server backend.  I need to migrate this
but the new hosting site will not allow me to restore the SQL Server
from backup at the new site and requires that I import CSV files.

I'm trying to setup a differential maintenance plan to backup all
users databases on sql 2000 using t-sql (or not)
I can't figure out or find how to include "all user databases" like i
would using a maintenance plan.  This is a cake to do in sql 2005 but

I need to query different databases. Below is an example (the database
name is returned in 'select dbname'):
select dbname,
(select count(*) from [dbname].dbo.members) as 'mycount'

I want to query a set of tables in order to create a dataset that I can look
at (in a grid in my application) and decide manually whether I want to
include the records for further processing such as including in a report.  I
thought to have a bit field which I can treat as a ...

I have encountered a strange security problem recently, I send sql server
functions to my clients and when they install them, it seems execute
permissions are turned off by default (at least this happened to 2 of my
clients: they encountered lack no execute permissions on those ...

Where can I query the SQL Server Log?  I'd like to see the Database Mirroring entries using T-SQL, not the log viewer.
Thank-you,
Rubens

I'm interesting in monitoring database space usage in SQL Server 2005.
Ideally, once a day I'd like a job to run that looks for databases that are
within 20% of capacity.  If one or more exists, I get an email.  I don't
need/want it to monitor constantly as our business processes ...

I want to find out on when the database and the objects were last used so
that we can do some cleaning up and sent it for archiving...
Thank You
Rgds,