Hi,

This may not be the answer but i get this sometimes with the following conditions;

I have two physical machines that i use here in the office.

We have expiration policies in...

Hi,

First and foremost this is not a table, it is a dynamic management view or DMV. Secondly, DMVs are not available in SQL 2000. DMVs were implemented in SQL 2005....

I'm just saying too. It's a bit misleading when you look into it.

I have not tried to implement as of yet. I am just trying to gain helpful insight. Do you have any you would like to share?

Boooo... Can i have my points?

Well, it's Friday!!!

I use smtp to send emails. If you have access to a server i feel that is the best way. I kickoff a visual basic script to do it.

Hth,

Brian

If you wrote a proc, usp_DoBatch...

psuedo-code

start tran

set @i = 1

while @i <= 10000

   begin

   If @i % 100 = 1

      start tran

   Do Something

   If @i % 100

    commit tran

  ...

Hi,

In BOL, search for placing tables on filegroups and it explains how to move existing tables to other filegroups using EM.

hth,

brian

I'm suprised that there is not seperate results returned for row beyond the result set and statement failed.

sp_spaceused @objectName

its not quite the same thing since it doesn't show you the amount of space the object uses in the log but it does report space used on disk

do you have to be so technical   ///

Thanks for passing that on.

No the query runs with no problem in QA. Does your EM ask for confirmation when a change has been made to a record before moving on to another record? I...

I went back and changed the size of the [Resolution] field to varchar(5000) and i still get the same results. Any other suggestions?

I agree with the other posters. Why should you reinvent this? Even in the case that you use stored procedures to enforce referential integrity rather than foreign keys, inherited a...