-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],

...

You'll need a (temporary) table and you can only "catch" the first resultset, and output parameters.

create table #tmpResults (col......)

insert into #tmpResults

exec usp_whatever (.....)

- did you encounter errors when doing all this ?

- what does sqlservers errorlog state?

- this once more proves you really need backups !

I would certainly test SSMA.

Download it, install it, and see what kind of remark, warning, errors it gives.

You may need to do some stuff as a perparation for the migration.

Make...