What are you trying to figure out? The number of bytes required to store the selected data? Is this an audit of some type? There are queries that you can...

This is one of the few places where I use cursors...

Here is a few excerpts from a change monitoring sp I wrote (it looks at more than just tables):

DECLARE @DBName...

I am assuming that this is not a one time push, but you are planning to schedule this as a regular process?

I would recommend creating your own exe or script...

Just my (albeit late) 2 cents:

Beyond the obvious "tables are better than arrays" it sometimes helps to stop and rethink about the root technology that was used to develop what...

You are missing the "schema". Try using the four part naming convention specified above.

My 2 cents... I would go ahead with the install (on a test server!!!) and then un-install re-install SSRS. You should then be able to connect to your previous SSRS...

I think I got it figured out... the issue has to do with the "fingerprint" for sftp (scp). For some reason, even if I set the SQL Server job to...

Thank you for the response.

I have actually boiled the problem down to the executable that I am using to pull the file: PSCP.exe. If I call this exe from...

This should give you a good starting point:

SELECT *

FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt

CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) as qp

With SS2005 you can use the Dynamic Management Views and Functions to pull the queries executed, as well as execution performance on them, without necessarily resorting to profiler. It may...

If performance and locking are concerns, another option is to simply export csv or text files to a network share from excel (using a machine and date/time stamp on the...

Crispin Proctor (8/20/2008)

My first thought would be to create a copy of your database(s) and write a script to create triggers on all tables. Write out any changes from database...

Coming from an external source, I would normalize at the data import. If you use dynamic sql within the data import, you will save needing it to query your data......

Jack's got it right: normalize! If you can't, then you are going to have to use dynamic SQL. It's not that dynamic SQL is "bad", it has it's uses, it's...

My 2 cents: There is an application and there is a database. There are a lot of reasons that the line can get blurry, but you need to be sure...