Thank you very much Perry

ok, thank you very much.

So what is the "EXECUTE AS" for?

hum???

How is that?

If a user as rights to execute the stored procedure but do not have permissions on the tables inside the stored procedure how can the procedure run if...

can someone help on this? thank you very much

Thank you for reply.

My question was: Is this the self signed certificate that is used by SQL Server 2005 when you configure the option "force encrypation =yes" and don't provide...

thank you very much i will try that.

What about the other services like SQL Server Browser and others?

yap i used.

But that link will help you to know what to do to have a clean uninstall

This link will help you:

http://support.microsoft.com/kb/290991/en-us

No, the identity does not need to retain the same values. I just need to recreate the whole table (primary key and identity)

lol, ok, i will try to explain better.

I have a table, this table as 4 columns. The first column (int) is an identity field and it's the primary key.

When i...

I noticed that the server where this query is very fast as 2 quadcore processors....

The other machines only have a dual processor.

Maybe it's this....

What do you think?

Thanks

P.s - When...

"It's telling you that the database has transactions in the log that have not been backed up and, if you restore over the database you will lose those transactions"

This is...

Thank you george

If i create a user (SQL User) with a login named Paul and then mapped to the database (user account) with db_owner permissions he will be capable of connection when...

thank you george