spot on advice from venoym and Recurs1on;

if you can provide more details, we can help you witht he perforamnce issue;

ideally, if you can save the ACTUAL execution plan and...

didn't go that far as to play with Full Text.;

it was purely from a Text-Dictionary to SQL Server Table project I fiddled with a few years ago; Full text wasn't...

if the software uses parameters, quotes are never a problem, performance could increase, as the query would benefit from the ability to be cached, because the parameters allow it to...

here you go Mark;

dunno if this will help, i took a thesaurus file from the Gutenberg project, and bulk inserted it into a table, then built the table of synonyms.

it's...

I'm doing this via an application, but I've always found that comparing a schema is not enough;it's too complex for a TSQL script to fix or recover form errors.

at least...

here you go:

a txt file with all the keywords as a CTE;

at 600+ lines, i did not want to post it inline to teh forum, so tit's a text...

SQLserver keywords can be found here:

http://msdn.microsoft.com/en-us/library/ms189822.aspx

you can see there is three sets there; SQl keywords, ODBC keywords, and future keywords.

it would be very easy to paste them into a text...

if you are SQL 2000 you can move the CTE to a subquery like this:

SELECT DATEDIFF(minute,StartTime,EndTime) - BreakPeriod,

(DATEDIFF(minute,StartTime,EndTime) - BreakPeriod) / 60 as hours,

...

something like this is what you are looking for, i think.

note how i created consumable data with the Common Table Expression and made sure to create the "right" data types?

if...

anyone in the db_owner role of an individual database has the ability to backup, restore or drop their own database, without additional server-wide permissions.

will that work for you?

here's a link to a nice free ebook to help you get started:

Troubleshooting SQL Server: A Guide for the Accidental DBA by

Jonathan Kehayias and Ted Krueger[/url]

just checked, and sp_ms_marksystemobject is available on my SQL2008 machine, but sp_MS_upd_sysobj_category is not.

maybe a system that was upgraded in place might still have it?

is this a SQL 2000 machine, by chance?

in SQL 2000, it was possible to set a flag accidentally that set all your procs you create in that session as system...

MyDoggieJessie (1/27/2012)

---

I stand corrected 😀

Lowell, I love your example however, there's one small error in your code, it errors out at the SELECT:---Can clarkKent see the table...

MyDoggieJessie (1/27/2012)

---

I don't believe this to be accurate - more of a maybe... as it really depends on how you've set up security on the server: Are you granting permissions...