Well now I have 2 questions. Is he just trolling or is he hired help from india at...

I was thinking along the same lines. The problem for me is that the same field name is used across a LOT of tables.

More to the point, my report's...

2GB of ram seems extremely low especially for a 78 GB db.

We have a "low" use server here with only 18 GB of data in it, but even with 4...

Syed Jahanzaib Bin hassan (4/21/2011)

---

That is a serious issue,did you check to bounce the agent service,

for the time being create an sp and include all jobs start script as

sp_start_job 'test1'

sp_start_job...

Syed Jahanzaib Bin hassan (4/21/2011)

---

can you prove this?

Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so

http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA...

sp_who2 comes to mind...

It's a good start, but I'd find it hard to backtrack to owner.tablename.basecolumn

especially since I use mainly sps in my code.

Nevermind, I figured out what you meant in the code :-P.

tfifield (4/21/2011)

---

Great article Craig! I've been put off by job postings that have the SQL God requirement in the past. I'll never look at job postings in the...

Can you post the full thing? Maybe you'll catch another passenger that's willing to get on this ride!

ALTER TABLE dbo.t2...

Wow it's almost more...

I forgot where I found this. This gives you the sps and ad hoc statements.

Still a effing ling way to go to get parse the tables and get the...

We can't do anything for you without the actual error message (sql side if possible).

Syed Jahanzaib Bin hassan (4/21/2011)

---

Start the SQL Server Browser service from the

CONTROL-PANAL ->Administrative Tools -> Services

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP |...