The database is in single_user mode, but that does not prevent you from connecting on another Database (master).

Connect to the master database, and run sp_who2, check the SPID of the...

Are the queries in stored procedures? If yes, then just deny the updating of those procedures to the users in question, and leave them only to the DBA, or admin...

steven.wood (6/16/2009)

---

J-F cheers for the quick response.

Ok a bit of context for you, I have a 3rd party software app I cannot change the database structure of, data from this...

GilaMonster (6/16/2009)

---

?????

A...

steven.wood (6/16/2009)

---

Hi,

Please can someone help as I'm an utter novice when it comes with working with Triggers.

I have a holding table that is populated by a trigger no problem, thing...

Highlight the table name in SSMS and do ALT+F1, it launch sp_Help on the current selection. You will see the fields, datatypes, and index informations.

Hope that helps,

Thanks a lot Gail, this is the best explanation I had of page verify settings. Once again I learn a lot from reading your posts.

I will change my DB To...

Gail, what's the difference between

Page Verify - None

Page Verify - Torn Page Detection

Page Verify - CheckSum

One of my DB is currently set to Page Verify - None, which makes...

Oh Geez... SQL 2000, Sorry, my solution will not work, it's for 2005.

Sorry about that... I should've read the entire post..

kam7395 (6/12/2009)

---

Hi Everyone,

I am new to SQL Server 2000, Please somebody let me know how to "count the occurences of weekdays in a year" or else...

You need to group by Every column that is not contained in your sum, here's how:

SELECT A.empnum,

A.ename,

...

Hi,

The Sum aggregate is used to SUM the same columns accross rows. What you want to do is sum different columns.

Here is an example

Select

EmployeeID,

Name,

(Select (reg_hrs + ot_hrs + sick_hrs +...

Happy I could help Ian,

Have a great day,

Why do you do...

John Rowan (6/10/2009)

---

Step 1: Execute SQL Step - SELECT Col1, Col2, Col3 FROM YourTable WHERE........

-- Result Set = Full Result Set

-- Result...