Syed Jahanzaib Bin hassan (4/23/2011)

---

Hey Ninja Turtle,you are again talking about non sense and stupid but why Ninja Turtle why

I'll be listening on this thread... I've had that problem once...

Syed Jahanzaib Bin hassan (4/22/2011)

---

whats the problem with you guys,I dont know why guy interrupting me,do your own work

Regards,

Syed Jahanzaib Bin Hassan

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

Syed Jahanzaib Bin hassan (4/21/2011)

---

If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe....

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...