Hi everyone. I retook the exam yesterday and passed thanks to the extra time. It was with Pearson Vue, and was 180 minutes in total. This time around I had...

Jeff Moden (11/14/2014)

---

]]

2 minutes and 13 seconds...

shunor (11/14/2014)

---

Today I have failed on the exam 70-458 because of the time limit.

I have had 85 minutes to complete 51 questions, which is ridiculous.

On my previous exams I have...

Sorry to hear that, but I'm glad I'm not the only one and it confirms to me that it's shorter than other exams. Like yourself, I've also taken old 2008...

Thanks. I'll give that a go

Thanks, I've added a dedicated reporting user and am accessing the database with that now.

Dird (6/17/2013)

---

Doesn't the "write" privilege on a folder affect both...

bslchennai (6/16/2013)

---

Hi,

I am also facing same problem and in my table i have one clustered and two non-clustered index's, two types of triggers INSERT/UPDATE and i don't have foreign keys...

Also if it's successfully running in BIDS but not in Jobs, you might want to check that the SQL Agent user has access rights to the folder you are deleting...

This might be of help to you if you are searching within a database for an sp or view that contains a certain table name, field name, or text:

SELECT DISTINCT...

I use the following:

Any SPID above 50

sp_who2

This gives a little more info on what sp is actually running

SELECT

sp.spid

, sp.blocked AS BlockingProcess

, DB_NAME(sp.dbid) AS DatabaseName

, sp.loginame

, CAST(text AS VARCHAR(1000)) AS SqlStatement

FROM...

Hi Ben,

Another solution might be CLR.

command.CommandText = @"EXEC @StoredProcedure @Variable";

command.Parameters.AddWithValue("@StoredProcedure", sStoredProcedure);

...

I think 2008 R2 is .NET 3.5, so you would need to go into your project properties and change the target framework to 3.5

Would be interested to see too. I'm looking at a CLR solution. I've never developed CLR before, but would be a good way to learn.

IIRC you can use OPENROWSET after the FROM clause