When I restore a database to another server I use the following stored procedures to rectify the user SID etc. - I forget which one should be run first..:

CREATE PROCEDURE dbo.Usp_fixusers

--...

I've used the restoring to a point in time a number of times with great success, but I always have to change my regional settings from English to American Date...

For info:

To use WIndows Authentication you'll first need to ensure that the SQL Server is set-up for it:

Right click on the SQL Server in Enterprise Manager and select the SECURITY...

We used to have a problem with installing SQL Server 2000 on a number of hosts where we had to ensure that the Host Identity was in UPPER case i.e. no mixed case...

I tried John's code - I had to change the @StartDate to '2005-01-27'.

I had no problems - I received an ISO Week of "4"

Regards,

Nic Washington

How about something like:

create table #TempData (ID int)

insert into #TempData values ( 1 )

insert into #TempData values ( 2 )

insert into #TempData values ( 3 )

insert into #TempData values (...

Something like the following should work:

Create Procedure usp_my_procedure As

Update ViewWeeklyFormUpdate

            Set Form...

Great! - Thanks for the news.

Regards,

Nic.

Thanks a lot for the info - I'll give it a try.

I've already written some code and changed the WSID to nothing which resulted in no host name being passed...

I thought I had just found a way by going into design on the linked table and then pulling up the properties and changing the Description of the ODBC connection but...

Thanks a lot for the information it looks to be exactly what the problem is - I'll give it a try.

Is there anyway of changing the existing links without having...

Try buying "SQL Server Security" - ISBN 0-07-222515-7

I've found it a god send for plugging these issues.

I was helping a user yesterday with setting his server up as Mixed Mode authentication - when ever he changed the setting via Enterprise Manager and then stopped and restarted...

I hacked the sp_Protect stored procedure to produce the following which will return a table in a similar manor to the permissions view in Enterprise Manager.

NB. It currently only returns...