Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Some Doubts

Author  Topic 

vmurali
Yak Posting Veteran

88 Posts

Posted - 2007-11-19 : 06:42:41
Which SP can be used to set or clear a stored procedure for automatic execution?

Which TSQL DDL statement cannot be at the database scope?
a)Create Database
b)Alter Database
c)Drop Contract
d)Create Certificate

What is schema binding?

Which Tsql extension in sql 2005 allows SP's to be exposed as Web Service?

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2007-11-19 : 09:58:50
Is that all the questions on your exam?

e4 d5 xd5 Nf6
Go to Top of Page

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-19 : 10:58:26
I can help with 2 of the 4:

Which SP can be used to set or clear a stored procedure for automatic execution?
sp_procoption


What is schema binding?
The process of binding a function to a schema, see schema-bound in books online.







Future guru in the making.
Go to Top of Page
   

- Advertisement -