You can use Transparent Data Encryption for this.

I think I covered this one...

Is this supposed to be a desktop application?

SQL Server 2008 R2 Express Edition supports databases up to 10 GB in size. I would be very concerned about running applications that...

🙂 Thanks to you for the good laugh!

jcb (2/16/2012)

---

As I said, unfortunately isnumeric is not perfect, someone can ask MS to implement a C# float.tryparse like function to do the trick (and it can be done with...

You're welcome.

Happy to help

orkun çapraz (2/16/2012)

---

Thanks my friend, I will try it once system is block.

I want to ask a question.

Is there any way when a process block the others, automatically kill it...

Permissions on linked servers are assigned to logins, not to database users. "dbo" is not a login.

Check the security settings of the linked servers: all the authorized logins should be...

Jeff Moden (2/15/2012)

---

If one second is what you need it to be (especially compared to 30 minutes), why mess with success? Leave the option to recompile in the code....

It's a server level privilege and you won't see it with sp_helprotect.

Use this instead:

SELECT sp.permission_name, p.name

FROM sys.server_permissions sp

INNER JOIN sys.server_principals p

ON p.principal_id = sp.grantee_principal_id

WHERE sp.permission_name =...

Lowell (2/15/2012)

---

i'm pretty sure GRANT VIEW ANY DEFINITION TO LOGIN is a server scope command...it has to be against a login and not a user, and your database has to...

No: the above script grants the privilege on ALL databases, including model.

New databases are created from a copy of the model database, which will already have those privileges granted to...

You will have to download the whole table and compare it to your local data, unless you have something on the remote table that you could use to filter data...

jcb (2/15/2012)

---

You can also use ISNUMERIC and case to input only valid numeric or null when its invalid.

Depending of your tables and needs you can also log or create a...

Assuming USER1 is defined in each database, this should do:

EXEC master.dbo.sp_MsForEachDB 'USE [?]; GRANT VIEW Definition TO USER1;'

Not 100% sure what you're after, but this should do the trick:

UPDATE lf

SET Linked_File_Name = (

SELECT TOP 1 hf.[File_Name]

FROM dbo.Header_File hf...