I lost this tables:

Clustered index successfully restored for object 'syscolumns' in database 'sgt'.

Msg 2501, Level 16, State 1, Line 1

Could not find a table or object named 'FUNCIONARIO'. Check sysobjects.

Msg...

It seems perfect. How can I add information to the script about the user that this this operation?

also, what object inside the msdb can I query to have all the restores that were made to SGCTI?

Can I do a select where name ='SGCTI' to one of the...

to the data (insert, update and delete). Only DML

There is a person that made a script (generic script) to do this.

I have searched on the internet and did not found...

I saw the script some time ago but I...

Sorry, I was not clear.

I need to find a way of encrypting the data because I cannot prevent the client from creating SQL or windows users with full permissions on...

I want that no one can read the database. They can only read the information on the database through my applications (vb.net and vb 6.0)

Can they decrypt (to read the...

I saw TDE encryptation in SQL Server 2008 which could be the answer to my questions but then I read this:

"TDE is not a form of access control. All users...

I don't have SANs. The SQL Server Instances are on two different servers (each server is a standalone server)

Servers are on different physical places.

Can I create http linked server?

As told, the two database will be on different servers.

Maybe the best solution is to create a linked server on the destination server. Then on the destination database create a...

Thank you for the feedback.

Ok. I undestand it.

What about the profiler?

1) Can I ask the profiler to log all the querys that are pass throug the query window? Olher...

Hi,

Thank you for the feedback.

I would like to achieve this without a third party tool.

Can't I say to the Management Studio automatically save (without having to ask the user) all...

i ALSO TRIED TO CHANGE BY DOING THIS:

IF (@ANO IS NULL AND @MES IS NULL AND @DIA IS NULL)

BEGIN

...

Thank you for your reply but in this case I prefer the first solution.

Thank you all for the help.

Lynn gave the right answer.