Why does the App need something other than just the OS disk? Is it reading & writing files?

No way that I'm aware of.

I'm not aware of any templates, but do really need one? What you really need to prevent scope creep is a requirements document and/or a functional specification. This can...

The execution context will be whateve the SQLagent account it. So, you could create the agent job logged in as the SQL agent account and make sure the SQL...

Antares686 (3/28/2012)

---

Haha, you just described me. I am self taught in all the C++, C#, VB, T-SQL, and PL/SQL. A bit of terminology I cannot directly relate but I can...

Randy Rabin (3/28/2012)

---

I'm not sure that pure programming is completely relevant to being a DBA, but Data Structure and Relational Set theory definitely should be. Every DBA should fundamentally know...

In my experience VB/Basic programmers have shown the worst software design techniques, implementations and documentation. The opposite seems to be true for those trained in OO, and specifically C...

If you would delimit each distinct statement with a semi colon you could just execute the whole string and produce the results you want.

Unless your requirements document requires that an actual GUID be used (for a justifiable reason) I would use an integer key of some sort. The size of the integer (int...

don't use SQLBIGINT in the format file. Use SQLCHAR for all of the fields.

use a dummy column 0 to handle the leading ", something like this (this is off the top of my head so don't hold me to the EXACT syntax):

0 ...

Benki Chendu (3/22/2012)

---

ohh..I am in trouble now..

I don't know from where the customer got the database backup from..

Here is what I did...

Restored the database with recovery..

Added that windows user to...

Benki Chendu (3/22/2012)

---

GilaMonster (3/22/2012)

---

If it's a log shipping secondary, add the user to the primary DB and make sure that the SIDs of the logins are the same on both...

Okay, I am suspecting that this server is maintained in synch with a primary server via...

You should probably just implement this as code in a trigger.