You should also look at your buffer cache, it may be that the data is not in the cache when first run and then it is in cache and it...

I'd have to agree with Gail on this one. Did you test to see that the Set RowCount was carried to the execution of the dynamic sql?

Also, why use...

I'll chime in as well that I do not see any issues with the T-SQL code, it should only return 1 row.

It is Friday and that is international professional development day,...

True, but if your domain is compromised you have problems in every area not just SQL Server and while SQL Server holds your data at least you should have backups...

I'm not sure that there is a good way to write this query. It is hard to determine if there is a way to make it faster as you...

Danny (5/2/2008)

---

I am only talking hypothetically. Lets assume a domain controller has been compromised. A domain admin could then access the SQL box. If the SQL box was not part...

Q (5/2/2008)

---

Jack Corbett (5/2/2008)

---

I just figured you would have a months table with the number of days in the month as each of the months mentioned have 31 days....

I just figured you would have a months table with the number of days in the month as each of the months mentioned have 31 days. So I would...

I guess I've never had to manage a really high transaction environment, so I've always allowed autogrow to manage database size. The performance hit was always acceptable to me....

Attached is a zip file with a datasource and 2 reports. The orders report has the order details as a subreport. The datasource points to adventure works on...

Phil,

Your code should look something like this:

[font="Courier New"]SET IDENTITY_INSERT db2.dbo.AccountTypes ON

INSERT INTO db2.AccountTypes

   (

   id, -- this would be the PK identity field

   TYPE,

   ...

   )

   SELECT

       id,

       TYPE,

      ...

How are the column being populated? Somehow the data in ColA is being created without the milliseconds, which tells me at some level it is being used as a...

Can you attach the rdl file for the report to the thread. Reporting Services can be difficult to explain in a forum without seeing what is being done.

It sounds...

Sorry you put the post in a SQL Server 2005 forum so I answered with a SQL Server 2005 application. SSMS replaced Enterprise Manager with SQL 2005. You...