Is the error always off by 1 day? If it is you could do this:

SELECT

BillID,

BillDate,

firstName,

...

I read the post(s),...

First I'd be interested in why you need to know this. Then I'd say, I don't think there is any way to determine this as temp tables are confined...

Do you mean you have 1 sql server and when you run a query using SSMS on the SQL Server it is very fast, but when you run the same...

Can you post the details of how you are doing this? What are all the steps in the SSIS package/dataflow? Are you sure the data is being retrieved...

You want to query the sys.tables view in the context of the database you want the table names from. For example querying it in master retrieves all the tables...

What version of SSRS? I believe this is a known issue for SSRS 2000 that was caused by either an IE or Windows update. Here is one link....

Check out the RESTORE command entry in BOL. If you are restoring a database to a different database you need to include the WITH MOVE option.

You have an extra period between Master and dbo, thus SQL Server thinks that Master is a linked server not a database. Try this:

exec Master.dbo.xp_cmdshell @cmd

In your example code, you do not have a where clause in your query. No where clause means all rows returned.

In theory, you could just setup a trace that includes all sql statement starting and completed events making sure you include the EventSequence column and then merge that trace data...

Okay guys, this is a good one, spoon feed me. Gail has already been there, too. You gotta check out the OP's latest post.

The links are where the definitions...

You just need to put in a single double-quote "

As long as you are using Integrated Security (Trusted Authentication) then you can get it. If you are using SQL Authentication, like a single account from a web application,...