you cannot resize it to be smaller than it currently is...did you perform a shrink before trying to modify the size? that is the most likely issue.

I think you'll need...

Remi you've got to look at the recent posts; he's pasted about a dozen interview questions to the forums, instead of googling. Even changed his screen name once since this...

It sounds like you want to calculate reminder dates with an interval of three months, for lets say a year into the future?

you'll want to use a Calendar or Tally...

i'd suggest updating statistics right away on the server...that can often slow down execution plans.

another thing to consider is the time it takes to assemble the information and send it...

kingscriber with exists(), it should bail out on the first match it finds; seems like it ends up scanning 14K items until it hits a match, so I'd think that...

I was recently "schooled"(ie chastised..hehe) here on the differences of IF EXISTS.

IF EXISTS (SELECT 1 FROM FilesView WHERE Element IS NOT NULL)

or

IF EXISTS (SELECT * FROM FilesView WHERE Element...

Ed i think it has to do with the version you are installing; I think SQL Express and SQL Express with Advanced Services only let you connect to a SQL...

Ed i don't know if this is much help, but in the past when i wanted to get a table that had a field which contained CrLf, i ended up...

mwstewart did you find out what the problem was? are there any triggers, or did you find something else?

Andrew I'm second guessing the purpose of the function....

is it just getting the # rows for a given table? is it being called 1000 times, one for each table?

if that...

nevermind.

my error was this:

set @options = 0

the allowed values for @options is 2 in my case.

my pleasure and thank you very much for the complement!

your question was missing a lot of things that we'd need to join your two tables together, ket alone insert into one of them.

give us some more details: the CREATE...

MJ I'm not sure on the whole sp_oa option, but if you create linked servers to each of your networked SQL servers, you can query them with an OPENQUERY command;...

well, you've got a logical error first:

dates should not be varchars...use datetime datatypes.

CREATE TABLE Table1

(ID int,

Enter datetime)

second, if you want a specific format, validating it to be a...