Thanks Jeffrey.

I set the services to manual. I was wondering where do I configure the startup parameters in the cluster administrator console. I was browsing around and couldn't find it.

Thanks...

Yeah it's missing the semi colon thats why it thinks its a part of the file path. We don't need the traceflag anymore so I wanted to remove it completely.

Everytime...

george sibbald (1/5/2010)

---

quick and dirty way using dynamic SQL

select 'exec sp_helptext ', name from sys.objects where type = 'P'

run the results of that in another window, output to a file...

SQL Iron Chef (1/5/2010)

---

Hello World,

I'm trying to figure out if there is a way to query master or a dmo/dmv/etc to find SPs that use a certain view.

For instance, suppose...

thanks for the info guys.

basically i was given a task to rewrite that store procedure and was trying to figure out what the sp was doing since i didn't write...

Actually I didn't! I was just trying to digest someone else code, that...

it is an inner join. shoot how embarrasing.

i remember seeing this in my text book way back in my college days

ex: from table1, table2 where table1.id = table2.id

darns all the latest updates didn't fix it. if I find a solution I'll add a reply

actually i think its database specific because when you create it, its under programmbility and then store procedure or function

Actually I think it should be >=

Wow thanks guys!

Or is there a way to to not show bars with zero value? This is killing me

Dang it I figure it out.

Basically you can set the visibility property of an object like a chart or list or table or etc to hide if the password is...

Thanks Steve.

I remember reading somewhere that if you rebuild indexes it can make the transaction log full or grow bigger. If thats the case should you run a transaction log...