yes, knowing when to keep quiet and when to raise your voice gets better with experience.

The last think you want is for your boss to grill you because you did...

Hi

Under SQL Server Agent --> Jobs - you can right-click on Jobs and say New Job

Step 1: Give the Job a Name

Step 2: Click on Steps

Step 3: Click on New

Step...

yes, the only 2 values that you want to insert is:

* NULL - if no date supplied

* the date supplied

The above case statement would cater for the scenario that is...

declare @Date datetime

select @Date

select convert(varchar, @Date)

select cast(isnull(@Date,'') as varchar)

NULL

NULL

Jan 1 1900 12:00AM

The above query illustrates what is happening - the cast - to a varchar and '' blank -...

Yes maybe the stored proc is declaring a date variable and it assigns a default value for you?

Hi

Is there any chance that the front-end supplies a default date - instead of the NULL?

Thanks

Kevin

Hi

Are you requiring to perform admin tasks by using the SQL scheduler / jobs

or

DO you need to create DTS / SSIS packages that run as jobs on the server -...

Your union will return records from both tables unless you perform an aggregation on each table in the query for each query of the union.

The other option which can be...

Are you using DTS or SSIS?

if you are using xp_sendmail - then it uses a mapi profile (user mailbox)

Try logging into a server with this account and open outlook for...

When last was a transaction log backup done for these databases. You can check on the properties of the Database - right at the top in SQL 2005

let us know

Thanks

Kevin

The event log - under system/application is usually your best starting point.

For a SQL Service to just stop is a serious condition, check memory, hdd space and drive letters.

let us...

Hi Sharon

The first thing to check:

* Is the login A created at the Server Level under --Security Logins?

* The user at this level must then be given server roles

* The...

This is an interesting one.

I have heard someone with a problem a while back and what they landed up doing was to run the specific script at a specified time...

Hi

Have a look in your SQL Server Logs - during the evening and see if there are any messages like:

Message

SQL Server has encountered 14 occurrence(s) of cachestore flush for the...

Hi

I know there is a feature to do a backup and split the backup into multiple files:

So if you have a 10GB DB to backup and specify 3 files:

Backup1.BAK ...