You could trace the process with profiler, using the "tuning" built-in template.

You should be able to capture alle the statements executed in the session.

homebrew01 (9/7/2011)

---

Is there a "rule of thumb" estimate of a reasonable tempdb database size in comparison the the databases on the server ? I know that the processes...

Avinash Barnwal (9/7/2011)

---

The third way doesn't seem to be option to find out which of the port SQL Server is listening, since if you are already connected to the SQL...

There must be a t-shirt for that too.

SQLkiwi (9/7/2011)

---

jcrawf02 (9/7/2011)

---

I apparently have nothing useful in my head today. How about a new game for PASS Summit to get people talking to each other? Paul et al wear...

sqlgreg (9/7/2011)

---

Gianluca, the files MyFunkyDB.mdf and MyFunkyDB.ldf are there on the hard drive in the proper folder, same as the other databases I've created without any issues.

Also I'm able to...

SQLRNNR (9/7/2011)

---

ermmm that one is for the...

Uh, I guess the "spaghetti dba" should definitely buy this one, but I don't know how I would look like with it.

😛

mtillman-921105 (9/7/2011)

---

Hmm, just noticed that SQL Server Central t-shirts are on sale here. 'A little pricey at $27.00 though, but I still may pick one up. I feel...

As stated in my reply: no sessions, no results from...

Looks like SQL Server service user is unable to write the file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\MyFunkyDB.mdf'.

Check the service account in SQL Server Configuration manager. If you change the service...

It's not an error, it's an informational message fired whenever you change database context with USE DatebaseName. Nothing worth worrying about.

2. Changed language setting to...

You can monitor the tempdb usage per active session using this script:

http://www.sqlservercentral.com/scripts/tempdb/72007/

The script returns the tempdb usage for each active session and can't be used to identify the offending query...

Dynamic SQL:

DECLARE @tableWithDuplicates sysname

SET @tableWithDuplicates = 'SomeTableName'

DECLARE @sql nvarchar(max)

SET @sql = STUFF((

SELECT ',' + name

FROM sys.columns

WHERE object_id = OBJECT_ID(@tableWithDuplicates)

ORDER BY column_id

FOR XML PATH('')

),1,1,'')

SET @sql = ' SELECT ' + @sql...

You're welcome.

Glad I could help.