We have a job that needs to run on the 1st working day of the month.
I have a function that returns a bit if the current date is the first
working day of the month.  Is there a way to use this function as the
first step of the job and if it returns 1 move to the next step,

I have the following query:
    (select    sum(A.Quantity) QtyA
    from    Prod_Assembly_Data_1 A
    where    A.[Date] = K.[Date]

Hello,  I wanted to confirm tht there are no issues when you have a
perf mon counter object such as SQL Server Buffer Manager  and your
host machine has mutliple SQL Server instances running.   That is the
counters simply reflect the sum of the values for all instances.

I'm in the process of removing all DAO code from a ADP project. I had
a bit of it sprinkled through the thousands of lines of VBA code.
To start with, I'm trying to decide whether or not I have to remove or
change this line of code...

I have 2 servers taht I have applied SQL 2005 SP2 on, but now they are
reporting different versions. What is the difference between
9.0.3054
and

Morning All,
At production on publisher Database, on friday evening our log reader job
failed, I checked on sunday morning, till that time it occupies all the disk
space, and what I found is

Periodically I have queries that generate extremely high logical reads.
One proc in specific that I've identified typically does in the range of 200
to 300.  However occasionally the proc will do 2-3 million.
If I re-run the proc with the same parameters, I am unable to reproduce ...

I am in the process of depolying a database maintenance plan tasks for
several servers. I have designed one using the Databases maintenance
plan wizard but I want to be able to replicate the same maintenance
plan for all the SQL instances in our environment.  I want to avoid to

Summary:  We have been getting a reoccuring time out error when running a
single one line insert into a table. The timeout occurs until we run select *
from the table. This is for SQL Server 2000.  
___________________________

How to install sql server 2000 Personal Edition at my XP Desktop, if
SQL  2005 is already installed.
i need to connect Servers from Desktop.
Thanks in Advance.

Hi
We have installed "SQL server express edition SP1" on one of my test box. W
e have created a test databases and many procedures on the box. The
application we are developing require full test search capabilities. Now the

Hi,
I have a tree database with the following fields:
- themeid
- description

ID  CID     Date
1     1      3/10/2008
2     2      3/10/2008
3     3      6/20/2007

I have saved a trace file from SQL Profiler using the tuning template. I have
3 questions related to running this against the tuning advisor:
1) When I try to run the trace in the tuning advisor, I get "98% of consumed
workload has syntax errors". What does this mean?

I did a SQL 2k to 2k5 migration using the detach/attach method. The
migration went successful. After the migration the SQL logins were disabled.
The password complexity was enabled in 2k5. I unchecked password complexity
and enabled the SQL login, however I am still unable to log ...