If you want to, you can just post the execution plan and we'll see what we can come up with 🙂

this is one of the misconceptions of sqlserver temp objects.

- http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-myths-debunked-part-1/

- http://www.scarydba.com/2009/10/13/table-variables-are-only-in-memory-fact-or-myth/

There is another forum thread with the same question:

http://www.sqlservercentral.com/Forums/Topic923309-146-1.aspx

and of course there is an article at SSC:

http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

how about just creating an audit ddl trigger.

Be sure to cover that with a server event in case the trigger is disabled.

Just use a scheduled sqlagent job that runs your script for every userdb.

I advise to just talk to your sysadmin/dba and request what you want.

They will most likely be glad to point you to the request procedure or eventually the implemented segregation...

You cannot.

- #tablename temp tables are cleaned up after the connection closes.

- ##tablename (global temporary tables) can only be dropped if they are no longer used by an active connection.

What...

primitive but working ....

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.Management

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction()> _

Public Shared Function ufn_GetOSStartUpTime() As SqlDateTime

...

I didn't find it in sys.dm_os at a first glance ...

so here are some examples of how you can do it with WMI and/or Powershell

http://social.technet.microsoft.com/Forums/en-GB/ITCG/thread/c4e577d3-ee7f-42a7-83da-375361d56bde

Integratable in CLR...

GilaMonster (2/21/2011)

---

GSquared (2/21/2011)

---

jcrawf02 (2/21/2011)

---

Jeff Moden (2/21/2011)

---

jcrawf02 (2/21/2011)

---

Jeff Moden (2/21/2011)

---

WayneS (2/20/2011)

---

For those going to SQL Saturday #69 in Philly, I'll be presenting @ 2:15. I'm getting pretty excited about this!

Click here...

YSLGuru (2/21/2011)

---

Thanks for sharing ALZDBA but I think thats just for showing how long SQL Server has been running and not the uptime for the Windosw Server its running on....

Another ref to put in the "must read" section !

Very good job !

Is there already a "sql server db logs / recovery models " section in SSC Stairways[/url]?

It depends 😉

For investigation / development I use SSMS and TSQL.

I have a script library which I built over time, so starting from there I'm fairly at ease.

With SSMS...

just a quick copy/paste from my script library:

-- how to determin SQLServer Uptime

-- zie Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html

--

-- dd 20060912 JOBI - aangepast voor SQL2005 (DMV)

--

--...

Indeed, interpreting the install log files is a PITA for everybody.

the error messages start before the registration errors you posted.

And yes, the timeout messages mostly are a result of another...

IMO schema can be used in at least two ways:

- to outline data collections cfr Adventureworks db

(not coupled to an application !)

- to ease...