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...

syedbilalmasaud (5/19/2008)

---

ok let me try with print statement and see the results and let you know , if you can write script for my specific database it will be very...

Not much you can do about it, but complain :ermm: ......

It would be better to have your companies "software-client" complain and request a sql2005 certificate for it.

Let them reside...

If I were in your shoes, I'd look for "exec" statements, and replace them with "print" statements, then execute the script a see what it does.

It was wrong of me...

rbarryyoung (5/18/2008)

---

ALZDBA, unfortunately, what that footnote is describing is all that Express Edition can do. It cannot exchange messages with Express Edtion instances, including itself. It can only...