I have a SQL Server linked server setup on a SQL Server 2000 Standard
Edition.    
When I run the query listed below with literals I received the error listed
below.

Hello, this might be a stupid question, but how would i go about
getting the dates that are NOT in the table.
For instance:
Table contains these dates: like a calendar with sat and sun missing,

I wonder if someone could explain to me why the script below runs fine
against an SQL2000 server but fails against an SQL2005 server with:
invalid object name 'People'. .
The connection to the database works fine. If I supply the wrong password I

i have to restore database from production bakup to development
everyday, there is a program which does this bakup and names the file
like PROD_20070523.BAK based on the date.
is there any way to run this with SQL agent and make sure everytime

I have a SSIS package which does a simple data extract from a source sql
server to a dest. sql server...I would like to change the source server at
runtime....
Like in the DTS world, I would create global variables and using dynamic

I know that even amongst the guru's here we sometimes get differing
opinions....I'm curious about a couple of issues very important to me right
now.
1.  I've asked about performance related issues that might arise from

In a table I have tblID, customerID, test_results.
Summing the content of test_results, gives 89.  Counting the results for a
giving customer gives 24. To calculate the average test results is done
simply by 89/24 = 3.71.

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'PAC_APPS2' as 'PAC01\Administrator' (trusted)
Starting maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:01 AM
[1] Database IER: Database Backup...

I'm interested to know what the besrt way would be to create a sequenze
number.
How can I prevent that a number will be created twice? What are your
thoughts?

Hi, to all
I'm planning to upgrade my Windows 2000 server (No Domain/AD, its just a
stand alone server) to Windows Server 2003 R2 SP2.
I have Microsoft SQL Server 2000 - SP3a running on the server.

We have 8 SQL2000 databases running in a live enviroment with 2
developers needing write/read/create access.
Inside one of the DBs I have created a new DB Role called db_nodelete
and revoked delete access which works fine for the dev team. To do

I have a A/A/A/P Sql cluster with one default and 2 named instances. I
installed SP2 on the default instance, when I go to install on one of
the named instances is says it cannot install and stops(does not say
much at all). what can i look at to see why it will not install?

Sqlserver 2005 SP2
Hi All,
Upon completion of a job, an email should be sent to an operator but instead
it return the following error:

looking for a script to run so that it will stop all SQL server services and
start them later .
I need to do system backup and need to capture every thing and then start
SQL server services.

I have the following problem in a Win 2000 Server + SQL Server 2000
environment and I hope somewhat can help me to resolve it (after many
days of useless attempts I am desperate).
In my database I have two table: