My customer has a complex system that is made of jobs, procedures and scripts that
should run almost every day.
The problem is that sometimes, some job can run "a little longer" and the other
procedures and scripts (and even jobs) should wait for jobs to end before starting.

We run maintenance plan created SSIS packages to backup our databases. The
final step is the cleanup of the jobhistory. We see the occasional deadlock
coming from sp_maintplan_delete_log.
Now I know that msdb backup tables have no indexes. We are looking at

I want to create a user that will use SQL Server Authentication to access my
database.  I am using Management Studio.  If I try to add a user MS insists
that it be a local logon.  How do we create users that are not going to be
authenticated by Windows?

When I run the ServiceBroker Hello, World sample on SQL Server Standard SP2
or SQL Server Express on Vista, I observe that no message is ever entered in
any queue.  When I run the same sample on Windows Server 2008 Enterprise, the
sample behaves as it should.  

Hi Freinds,
SQL2005
I rebuild my server and trying to restore master DB, I start server in
single mode, but I'm getting this error:

Hi
Is full text indexing possible on views in SQL server express edition with
advanced services?  If Yes then how to do it on a view where I want to do
full text search on five different columns?

I have a 52 GB database that take 3 hours to restore using SQL Server
native restore. Does this seem long to anyone who has experience with
databses of this size? I know each insatalltion is different so things
like this can vary.

I have a table with 10million rows where I need to change the datatype on a
column from int to bigint.  I'm assuming this will take a long time to
complete by just going in to Management Studio changing the datatype and
saving.  

If I split the tempdb  mdb  to a separate drive on our SAN, which I
understand is a good practice, how can I determine the amount of space to
allow on the SAN for this?   We don't want to exceed the space of course, but
also wouldn't want to assign more space if it'll never be ...

Is there any way I can correctly identify all instances of SQL server
in my environment?  We are using SMS 2003 for inventory.
I need to be able to differentiate between an actual SQL server
serving a DB, a workstation just running admin tools, an MSDE

If a /L parameter is not specified for an MSDE installation, is there
any install log created?

I have few queries for MS SQL Server
a)       What is the difference in terms of ADO / OLEDB between Windows
Server 2003 and normal Windows XP Professional?
b)      Is there a parameter which regulates the number of bytes in a result

I have a SQL 2000 database server with the server collation set to
SQL_Latin1_General_CP850_BIN and one of the databases with a collation of
SQL_Latin1_General_CP1_CI_AS which has been created by an external company.
Problem I have is that on this server stored procedures are ...

Gurus,
Is it true that local administrators on a system with SQL Server 2005
installed have an implied 'sysadmin' right to SQL Server?

I would like to change the owner of several maintenance plans.  I can't seem
to find a way to that without recreating each plan while connected as the new
owner.  Is there a method similar to changing a job's owner via the job's
properties or a database's by sp_changedbowner?