Yes you can, as long as it doesn't need to use SQLDMO to create objects.

Like Gail suggested, you really need to ask you manager for clarification.

Some managers tend to use turbo language and invent their own slang to try to get things done.

It's up...

it (sqlserver) keeps records for all mails it sends.

This is something you need to take into account.

We have dbmail enabled on all our sql2005 and > instances to monitor for...

I implement the advise Kimberly provided in her blog:

Free proc cache if to much single used plans

ref: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Plan-cache-adhoc-workloads-and-clearing-the-single-use-plan-cache-bloat.aspx

Can you elaborate on the "We seem to have solved a major IO problem last weekend so we'll see how long it runs this weekend." ?

Are there typical slowdowns /...

wise decision !

Keep in mind MS has a free downloadable migration assistant for MSAccess to SQLServer 2005/2008 .

Maybe it can even help you in your current situation to see what...

Brandie Tarvin (3/10/2011)

---

I...

I don't think you'll get the column name,

but the ordinal can be retrieved using a udf

Don't shoot me if this doesn't perform well, chances are a clr fn can...

You'll need to post both execution plans to be able to give you a hint on your Q.

since for now we are at instance level, I would expect exposure of sys.configurations but I seem not to be able to find it using the product.

Interesting project tough:

1)...

ebook SQL Server Statistics by Holger Schmeling (free download at red gate http://www.red-gate.com/our-company/about/book-store/ )

stated about 100 rows. ( page 24 )

Of course, as always ... test it, test it, test...

First of all I would install the SP3 version (which is the latest now)

If you have a look at the screenshots of this post, you'll see Figure E where...

just my 2 ct to get an idea on how many GB you'd need:

Save your execution plan and open it with sqlcentry (free) plan explorer .

It will give you a...

Another vitamin boost by SQLkiwi 🙂

Gianluca Sartori (3/3/2011)

---

Thank you Johan, I must have missed your last post. :blush:

We're still working on the issue with MS support.

Now they're trying to reproduce the problem on their own,...