Big Brother^® is a Web-based systems and network monitor. A universal color-code interface of "red is bad and green is good" allows anyone to measure the health of a network...

i'd speculate that someone tried to truncate a table that was referenced by a foreign key, got an error, and assumed that it was not supported;

truncate table deletes all the...

to really help, we'll need the real schema; use enterprise manager, select the table, right click>>All Tasks>>Generate SQL Scripts

paste the results here;

you can join the same table on itself when you...

without knowing the table structure for sure, something like the sql below is what you need. an inner join shows only matches...so if a company in table1 did not have...

My shop is similar to yours Tristan; we deploy upgrade scripts that add tables or columns, alter columns, migrate data, etc. Those scripts are expected to be performed on lots...

After I Saw Davids answer, I gave my head a good slap because I knew better; I had even started writing a function when David posted the right answer.;

you can use Enterprise manager to create the scripts for you;

go to design view, edit the design of the table and notice the little used button at the top named...

The answer really is no; the right way to do it is to create a new table witht he column in the middle, migrate the data to the new table,...

you might be confusing a VIEW with "dynamic tables"; a VIEW is really a SELECT statement which has been saved, and is automatically updated whenever the underlying tables it references are...

here's my suggestions.

SELECT PRODUCTCODE, CONVERT(VARCHAR(30),EVENTDATE,103) Startdate,

COUNT(DISTINCT(PERSONURN)) AS 'BILLABLE CDRS',

COUNT(*) - COUNT(DISTINCT(PERSONURN)) AS 'COUNTS',

SUM(CASE WHEN EVENTTYPE & 4 = 4 THEN 1 ELSE 0 END) AS 'CUSTOMER',

SUM(CASE WHEN...

why can't you import into SQL , and after the import is completed alter the column definition to be a datetime field, or add datetime columns and migrate the data...

I think it has to do with the filepath containing a space between 'jeff seeman' and 'Documents and Settings' as well;

so it finds the file 'c:\Documents' and fails.

if a filepath...

the problem with this is what about all those forums you subscribe to to keep abreast of questions...I probably belong to a dozen different forums for various interests.

$108 ($9 x...

i poked around the MS KB, and wow they are purposefully vague on how to fix any underlying conditions that might raise error 18; i'm going to watch this thread...

why not just grant permission just to the specific procedure, instead of a role that has too many rights?

grant execute on pr_truncate_table to webdev