Answer / guest

The global variable @@Version stores the build number of the
sqlservr.exe, which is used to determine the service pack
installed.
eg: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17
2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service
Pack 3)

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---