this may solve your problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

select datediff(dd,'2006-01-01', getdate()) gives you the number of days.

If you want weekdays(mo-fr) you would have to make your own function like this one :

CREATE FUNCTION dbo.udf_convert_date2WeekRange (@RefDate datetime, @FirstLast char(1)...

- was the database detached in a propre way ? (detatchdb ...)

- you may be better off with backup/restore

add startup parameters -T1204 and T3605 to your sqlserver's parameters.

or execute dbcc traceon(1204, 3605, -1)

This way you get deadlockinfo in your sql server logs.

If you fetch/arrange me a ticket too, I'll even wear that tricky colored T-shirt from last year at Dallas

Can you pass me some...

maybe you could try to start sqlserver with minimal configuration using startup parameters from the commandline.

sqlservr.exe -f

check out "sqlservr Application" in books online.

is it running behind a firrewall or in another domain than the client ?

can you see the server in the serverlist when you try to register it in SQLserver management console ?

Did you check case sensitivity ?

If your server is installed case sensitive, .. your userId and password are also case sensitive !

avoid trailing blancs in passwords !

- how are you trying to connect ? Windows authenticated or SQL-authenticated ?

- can you ping the sqlserver ?

Drop / Create will be your only solution.

maybe this script can gat you on track :

set nocount on

print 'Linked Servers voor [' + @@Servername + ']'

print '------------------- ***********'

if not...

is a connectivity problem (could be anything)

- can you ping the sqlserver ?

- provide a correct userid and password for the connection.

- can you connect to the sqlserver using query...

check your stored proc "USR_Demographics" for string "g?tdate"

keep in mind that the function getdate() cannot be used as a default value of an input parameter for a stored procedure !

- end you statement with a semicolon ;

- this also can do the trick

alter TABLE [dbName].[dbo].[tableName]

add  colx bit not null default 0 ,

       coly bit not null default 0...

- maybe tablediff utility can do that for you. aarch that's sql2005

- I guess the SQL_Server_2000_Web_Services_Toolkit can do that to.