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

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,

Under what circumstances would I want to check the server property "Use AWE
to allocate memory"?
Our server:
Windows 2003 Enterprise edition

Does anyone know, I will be add two new columns with small int data type to
existing table that has 121 million records. How long will finish? We use SQL
Server 2005 EE with SP2 (OS Windows 2003 with SP1).
Thanks!