JimS-Indy (10/23/2012)

---

I'd love to have that learning experience.

VBS is very unsatisfactory. No editor, No debugger. I wrote the original program in VBA and deployed it as a standalone db...

This problem could probably be more "cleanly" solved with a CLR object.

Happy to help you knock one up if you'd like to go that route.

D-SQL (10/15/2012)

---

I tried to run this on the server in question

GRANT SELECT on spt_values TO public

but recieved an error

Msg 15151, Level 16, State 1, Line 1

Cannot find the object...

This blog post might help you:

http://blogs.msdn.com/b/suhde/archive/2009/04/05/invalid-object-name-master-dbo-spt-values-microsoft-sql-server-error-208.aspx

dflbob (10/8/2012)

---

I appreciate your input but I'm not really asking to be guided; just what's the better path as I thought it's pretty clear I'm in the SQL/BI world which...

The problem with asking someone to "guide" you to the best Certification Exams to take is that it is actually not easy to do without a fair bit of knowledge...

A number of them come with Services you can shut down if you are not using them.

/* Removed to respect OP's wishes */ 🙂

singh.anirudh31 (10/4/2012)

---

I have to use same formula to fill the calculated data in different tables. I want to make this formula configurable so that no need to write formula everytime...

What part of the Merge Statement are you trying to add the variabe to?

I think "Disabling" Constraints is only relevant for DML, for example, you could disable a Constraint if

you sought to insert data into a table, bypassing checks.

If, however, you wish to...

The concept of "global variables" doesn't really exist in T-Sql. You...

sqlfriends (10/1/2012)

---

I recently found when I use query window in SSMS, when I close the tab, it didn't ask me if I want to save the query sometimes.

For example If...

The error is almost certainly what it is.

I would just check and confirm the spelling, database and objects you are trying to access.

tauseef.jan (9/27/2012)

---

hi friends,

I need to create a server trigger to automatically map a login to a new database and make it a member of the db_owner database role.

I was trying...