here's a simple script to search both the job steps in msdb as well as the current database's stored procedure definitions.

this might point you to something to investigate.

I actually had...

Lowell (7/1/2011)

---

any chance there is a script or job doing something like this?

since you said it happens "regularly, maybe there's an obscure snippet in a job or something

IF EXISTS...

any chance there is a script or job doing something like this?

since you said it happens "regularly, maybe there's an obscure snippet in a job or something

IF EXISTS (SELECT...

i've always done this with dynamic SQL; it makes for better execution plans.

my "search function makes all searches with "starts with" for text fields, and exact matches for numbers.

so searching...

Babu thanks for giving me something new and interesting to play with; being able to parse a statement has a lot of possibilities.

i found an example in german here: http://olafhelper.over-blog.de/article-34700638.html

i...

I'm getting caught up on words i guess.

OPENROWSET is not used to export...my...

OLE DB provider "Microsoft.Jet.OLEDB.4.0" is a 32 bit driver...so if your sql instance is 64 bit, you'd get that error.

you probably need to download the updated 64 bit ACE drivers...

what error do you get?

i think bcp exports as raw text only, so any resulting file, no matter what extension you put on it, needs to be opened in something...

the few times i've read about this kind of issue, it was situations that i'm not sure apply here:

connection pooling: create a temp table, and then issue another statemetn...sometimes your...

Syed Jahanzaib Bin hassan (7/1/2011)

---

if you have passed the T-sql GRANT SELECT ON TO then he cant access the systems databases and systems objects even other...

you cannot encrypt a "table definition" (CREATE TABLE.....).. the column types and table name are stored in sys.tables and sys.comluns., and all the related obejects like constraints and indexes are...

part of what you posted says Year(today) -1

that would be 2010, correct? isn't that what you want?

as far as not breaking anything, if you were going to do an UPDATE, or add a job or reindex that wasn't one of the famous scripts here on SSC,...

first i'd suggest practicing on a completely unfamiliar system; you get tunnel vision looking at your own laptop and machines, and make assumptions aobut what is in place and what...

are you using a SQLCcmdObject with parameters to call the proc, or as a text command with ExecuteNonQuery??

show me the code you are using to call the proc, i'd...