To fix the date format on the report server (in 2005):

Edit C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\Pages\ReportViewer.aspx and add Culture="en-XX" where XX is your country code.

Example:

<%@ Register TagPrefix="RS" Namespace="Microsoft.ReportingServices.WebServer" Assembly="ReportingServicesWebServer" %>

<%@...

Thank you Michelle from NZ. I added culture="en-au" to ReportViewer.aspx and my report now presents dates correctly in dd/mm/yyyy format.

No sheep jokes, I promise!

Ian Scott

Jack,

I checked the BOL entry you provided (http://msdn.microsoft.com/en-us/library/ms156493(SQL.90).aspx)

I have been through every setting I can find on both Reporting Services server and the server my database is on....

Here is an interesting way of looking at storage!

According to an IDC Research report, in 2006 161 Exabytes (161 billion gigabytes) where created. That's 3 million times the information in...

Sheepish Grin!! Thinking too much about my Christmas holiday than what I am doing.

I didn't think to look in the Server agent jobs!

I didn't explain that very well!!

In row 1 of t1, col4 contains 'xyz' so update t2 set Col4 = avalue

In row 2 of t1, Col1 contains 'xyz' so update t2...

Answer to 1)

select @dte = convert(datetime, convert(varchar, @dte - day(@dte)+1,112))

Sets the value of @dte to 1st of month and midnight. Day() gives # of days in month, date format 112...

You can create a trigger as follows:

create trigger TestDates_Insert

on TestDates

for Insert

as

declare @dte datetime

 select @dte = DateT from inserted

 if (@dte <= convert(datetime, '5:00')

 and  @dte >= convert(datetime, '1:00'))

  begin

  Update TestDates

  set TestDates.DateT = convert(datetime,...

Handling dates and times causes more grief than any other issue!!

When a user enters "2:30" I presume they mean 2:30 in the afternoon today! The "1/1/1900" is the default date...

If I understand you correctly, the following should work:

Create Procedure sp_GetEmployees

( @dbname  varchar(50) )

as

declare @sql  varchar(500)

set @sql = 'Select * From ' + @dbname + '.dbo.Employees'

EXEC...

Steve (hoo-t),

You have answered my question and confirmed my suspisions!!! It is imposible to trap ALL errors in a called procedure from a calling procedure.

Regards, Ian Scott 

Timeout! What I am attempting to explain with examples is:

 "Can I trap ANY error (missing statements, incorrect data types, not testing for Nulls, no more space etc etc) in a...

OK, Here is my real life problem!.

The called sp does the following + a lot of other stuff:

 .

 .

OPEN tnames_cursor

FETCH NEXT FROM tnames_cursor INTO @tablename

WHILE (@@fetch_status <> -1)

BEGIN

 SELECT @sqlstring = 'DBCC...

Thanks Kathi,

Your previous reply put me on the right path. The classic case of tunnel vision from thinking about this for too long!!

Regards, Ian Scott

OK, I will attempt to explain this a little better!

It is essential that Step4 (Cleanup) is the last step executed. Step2 is set for On Success Step4, On Failure Step3...