did you enable it to use tcp/ip ?

Just to add to the previous post...

First of all it is a good thing you plan to migrate in stead of upgrade.

- whatever you do, start with SQLServer 2005 upgrade...

Here it comes again .... :hehe:

THIS SCRIPT IS NOT INTENDED FOR SCHEDULED USAGE !! READ BOL to find out how a db-log works !

With full recovery, you need to perform...

-Check out the upgrade logs !

You'll probably find them at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

After that, if I were in your shoes, I would rerun SP2.

The login mode...

Indeed using the cte for this is a great solution.

There is a little caveot concerning data usage.

You absolutely need to know where you're comming from to be able to link...

based on your query that's exactly what it should return.

SELECT FactID AS ID, EmplyID, PersonID, 'Factory' AS WorkPlace

FROM ...

:ermm:

Just a little reminder of a nice article...

I've also interpreted thesqlgurus comment as non-personal, but a pointing to a practise that arises more and more.

Companies should learn sqlserver is way more than an enhancement of msaccess :sick:

The...

What's the exact error you are receiving if the proxy is not logged in ?

- are you using (mapped) drive letters in your packages (file locations) ?

Use UNC !

don't use file = 'x:\myfolder\myfile.txt'

but use file='\\myserver.mydomain\myshare\myfolder\myfile.txt'

NO! a proc only influences the database.

Depending on the recovery model of that particular database, log file entries can be overwritten or not.

In normal situations, it is considered to be...

check BOL for the case statement;

update mytable

set col3 = case when col1='abc' and col2 = 'def' then col4

...

Shall I send you my old...

rea|and (5/20/2008)

---

thanks guys,

@ALZDBA: so, you say that there's no way to "catch" a second resultset (my sp returns two recordset).

And actually I've tried to use your method but it seems...

/*

show partitioned objects

*/

select distinct

p.[object_id],

TbName = OBJECT_NAME(p.[object_id]),

index_name = i.[name],

index_type_desc = i.type_desc,

partition_scheme = ps.[name],

...