Thanks for your input

Not exactly the same DB, but something close. He has the full data amout, but I have views and he uses them converted to tables. However, the...

Great!

Thanks for your help, it worked.

OMG! That's true.

I had never believed that could be true.

Thank you both!

But I'm adding a user, it's not an object.

EXEC importeddb.dbo.sp_grantdbaccess 'user'

Won't work since sp_grantdbaccess is a procedure stored in master db.

The best solution I got is like Jo's one. Re-select the field to sort by that field.

A boogie-man tsql story. I hope that to be solved in sql2005.

Thanks!

SELECT TOP 10
S.id_solicitud,...

Hi Jo

Unfortunately that gives the same result, this way the result has sense for me, since the ORDER BY is referencing the resulting column instead the source one.

Another shot?

Hi Mathew.

That did'nt work either. The "2" references the column after processing, this equivals the "fecha_creacion" without the S prefix.

In other words, that is what is happening with the original...

Yes, that works!

Thank you!

And what about taking dettach-rename-reattach? As far as I understand this will leave us with the old "name" too, but without a way to change it :-

I know to lurk...

No, I have not MOM, but Brian's proposal about Full Text made me look the service list.

...And found a LogPI agent that shouldn't be there anymore. Stopped it and the...

For example, this is the resulting message from a SP trying to backup a non-existent DB:

Server: Msg 911, Level 16, State 1, Procedure usp_FullBackupDb, Line 25
Could not locate entry in...

Good one, however:

SELECT DATEDIFF(Year, 0, convert(datetime,'2005-12-14')-convert(datetime,'2003-12-15'))

Will return 2, a "-1" completes it

SELECT DATEDIFF(Year, 0, convert(datetime,'2005-12-14')-convert(datetime,'2003-12-15')-1)

Thanks!

Great!!

That function is shorter than the one I was building

Thanks!

Yes and no. SA password...

You were right, I changed the SQL account from System Account to explicitly the one that runs the desktop and it worked.

But now I don't know the difference (for SQL...