Hey

DBA's job is to keep everything proper in the (including users data ).

Better to have backups.

You can also use DMV's for getting the required information.

Check out BOL for more info on DMV.

check whether the schema exists, if so grant permission .

if the schema does not exists then create the schema.

check out BOL for all these.

why do u need the schema.

If its in SQL 2000 pls post in the appropriate forum.

By base tables do u mean heaps (tables without indexes).

have'nt seen people using "." in their object names.

Most important thing with naming conventions is that once you have decided on a convention stick to it.

thanks for the info

hi

any other columns in the db. did u check properly.

Hi

Exists will check for existance of a one record that satisfies the condition and then will return the records. i.e. if there is one record that satisfies the condition tab1.po...

Perfect:-

Proper db backups. Spot on query optimizations. Regular and proper db maintenace. expert in high availability, configuration and all other hi-end stuff. (Where do u get such a person). :alien:

i thought you just wanted an indication that po# 12 existed or not. I assumed there is only one row in table1 and this single row has the value 12.

Anyway...

any large data updations going on? r u using gloabal temp tables.

Hmm... strange.

Is the db participating in replication or anything like.

Try scripting once again and check if this gets repeated.

try this

http://www.simple-talk.com/sql/learn-sql-server/service-broker-advanced-basics-workbench/

there is a good article in sql server central also.

"It depends" - Most often used when we cant find a clear cut solution to an issue. Mostly its true though