this is only a guess, because you did not specify enough details. the desired results did not show where the values might have come from, and since BOTH queries report...

I do things the same as McSQL, but one more thing i add is a check against a minimum date that is logical for the data on hand ; for...

winmansoft (3/24/2013)

---

Hi Lowell

Thank you for replying. Your method of giving permissions to tables works fine.But if in server roles if i set sysadmin(I did it in SSMS) for that user...

are you familiar with the CASE statement yet? it's what you need to add to your query to do what you are asking.

Other suggestions: don't use the Old syntax Table1,Table2

1....

The big issue with this kind of search, is that it must involve a TABLE SCAN of every table in the database.

If you have any tables with millions of rows,...

ir depends on if you are looking for a string, a reference to an object(table/view/etc), or a reference to a column.

-- a string

select * from sys.all_sql_modules where definition like '%COMM%'

--...

on my dev machine, where i have the last 4 versions of SQL, i was able to create a linked server from 2008R2 to 2012, and successfully query a known...

if you've ruled out the last 3, the only way I know of (and it's probably this, i guess) is it's getting stopped because the server stops and starts.

instead of...

Offhand, these are the reasons I remember for a trace stop being stopped

1.the SQL server is stopped and started. If that is the case, you might need to...

Ok Alan, help me out here: what makes a Broadcast Calendar? are we talking about TV programming, and just a regular calendar, but the first day the first Monday of...

my google of "Error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded." says that Access can raise that error if too many records are being returned, or the database tries to...

I've played with lots of calendar generations, and googled a bit to see what a "Broadcast Calendar" is; all i found was a bunch of (what i think) are fake/.virus...

Not sure, we can't tell from this side;

you said you got it working for pipe delimited, and the only difference between...

you create multiple roles which contain the permissions you want to be able to assign;

adding a user and granting permissions are a three part process.

first you really needed to already...

aliases are always needed when you add the same table twice; here'a i'm using an aribtrary T1 and T2;

it especially helps the query as well, as with your example, it...