This isn't possible. You can have two objects with the same name that have different owners/schema. But they'll be different objects. For example, you could have Sales.SalesTable...

Unfortunately you're going to have to alter each view's definition and encrypt them that way. Or you could use a third-party application - I'm sure there are some out...

You're supposed to use the object id of the trigger, not the table.

select objectproperty(object_id('name of trigger'), 'ExecIsTriggerDisabled')

A...

Phil,

That String.Format you were given is for the front-end code. That should work well enough. Or you could opt to format it in SQL Server if you wanted...

Mahesh Bote (4/4/2008)

---

[font="Verdana"]Not sure but you have to take help of Cursor, Dynamic SQL. Within the Cursor you have to build string for creating a Table and Select statement as...

karthikeyan (4/4/2008)

---

SQLZ,

It is not working.

...

It's not strictly true that SQL Server grabs all the memory it can get (not in one go anyway). What happens is, if SQL Server needs 200 mb then...

y.koteswarrao (4/4/2008)

---

Dear karl

Thank you for your reply........by re runnuning the sql services one log file will be created automatically is it.But while stop the services we cann't make any transaction...

If you modify Mahesh's solution just a little bit you've got your answer:

Declare @strSQL VarChar(Max)

declare @count int

set @count = 0

Select @count = @count + 1, @strSQL =...

If you have a backup (including log backups) restore the database and logs. Otherwise:

Start up SQL Server. The database will not recover correctly. Then detach the database,...

Thanks for confirming that. That's another good reason for fully-qualifying column names.

I had also noticed the foobar thing myself and agree it seems like a sope issue in the...

JohnG (4/3/2008)

---

I got caught with this in a trigger referencing the deleted table. It was a syntax error that SQL Server should have caught and thrown an error. ...

Have a look here...http://www.sqlservercentral.com/articles/Test+Data/61572/

That should help you get what you're looking for.

Here's another good reason why not to use IN:

Run this on the AdventureWorks database in SQL 2005:

begin tran

delete Sales.SalesOrderDetail where SalesOrderId in (select SalesOrderId from Doctor)

rollback tran

Whoops! You've just...