tikoti (9/12/2012)

---

Hi!

Is there anyway to "grep" a database in sql server 2008?

I mean, look for a specific string in any table, in any column, in any row

I know that it...

neellotus07 (9/12/2012)

---

Hi Lowell,

Your query showing tables of any view, but if view contains another view then it is not showing name of that view.

Can u help me in this regard.

Thanx...

just checkign the basic here...I see you are using inner joins, and not left outer joins...

you are sure the inserted.userId will always have a value that exists in the...

probably the easiest way is to use the Scripting wizard in SSMS;

right click on the database in question, Choose "Tasks", then "Generate Scripts"

follow the wizard prompts;

you might need to go...

the CTE doesn't matter,...

you would jsut wrap...

raj_melvin (9/10/2012)

---

we are fine to log into a flat file

but I am unable to capture the required informations like " Hostname" ,"local ip" and "Application Name" ect.

this is for a...

To the best of my knowledge, SQL...

FreeHansje (9/10/2012)

---

So I have restored a database to a new server and a check reveals a DB-user being orphaned. However, this user must have been created as CREATE USER WITHOUT...

a well written trigger...

samaneh.lashgari82 (9/9/2012)

---

i want use sp for sending because when in search about this subject i found about create profile and account for data base mail...can i sent mail from sql...

including the columns referenced:

select

OBJECT_NAME(depz.object_id),

OBJECT_NAME(depz.referenced_major_id),

colz.name,

*

from sys.sql_dependencies depz

left outer join sys.columns colz

on depz.object_id = colz.object_id

and depz.referenced_minor_id=colz.column_id

where ...

This is one of those "in a perfect world "scenarios, in my case.

I can see that for large projects, but what about smaller projects or enhancements?

There was a recent...

I have this saved in my snippets that seems to do a good job of generating explicit permissions;

does this produce the results you are after for a single database?

select sys.schemas.name...

ok here's a quick prototype i *think* does what you are asking;

it's basically a power-replace that cross joins your funciton symbols with a know list of repalces;

does this work the...