just hazarding a guess, but since this is running on Express, could the AUTOCLOSE setting of the database be causing the disconnect of the client connections, when SQL Server decides...

it's the full syntax for a constraint instead of the shortcut for a foreign key:

ALTER TABLE dbo.a

ADD CONSTRAINT FK_MyForeignKey FOREIGN KEY (id) REFERENCES dbo.b(id);

to rename a constraint that has a...

I found a lot of stuff on Database Mirroring here:

database mirroring sql server 2008

general questions and information gathering stuff like that is what google is awesome at; the forums here...

hehe in my shop we call that a problem with the CKI (Chair to Keyboard Interface);

it can often be fixed witht...

I'm a little weak on your requirement, so help me clarify it:

you have an openDate and a closedDate.

I thought the closedDate should be x business Days greater than the openDate;...

yes, the plan could be cached; it's not guaranteed.

I have an older book that explains it in some detail...the answer is if SQL thinks there is a high cost for...

without the two tables (tblSale and tbl1 ) and some sample data, i can only make a guess that is syntactically correct;

my assumption in my example is that the Closeddate...

ouch.

assuming deletion of specific data, then the data is lost. there is no way to recover deleted data when in SIMPLE mode;

the typical thing you'd have to do...

that's pretty dumb. if you don't want them to see it, don't give them access to the report at all, period. if they are seeing "too much", tweak the report...

here is a link to one that i built after a few posts on the subject here on SSC; it's got all the code to insert all the known holidays...

oops reread it and there are multiples;

this seems to get you 98% there:

--now get the ID's using a tally table

declare

@pre varchar(10),

@post varchar(10),

@pr int,

@po int,

@st int

set @pre = 'TBM'

set @post...

if the TBM number is always 6 characters and it always starts the string, you could simply take the LEFT(col,6) of the string

SELECT LEFT(String,6) from #Test

if it could exist anywhere...

i have this saved in my snippets to get the next business day:

this assumes you have a Calendar table with some specific columns, since business days are also dependant on...

truncating a table frees up space WITHIN the database, so more data can be added without expanding the database. the db assumes that you made room for more data; if...

it seems like you want a 1 to N solution, not a running total(since you explicitly gave the 1-3-5 example of non consecutive values)

for any actual solution, i would end...