i think as soon as you try to simplify and abstract stuff, it makes it harder to understand. pseudo code sux sometimes...tablex/database a/b...yuck.

so do you have multiple tables(maybe in other...

on my machine i had 2005 installed a couple of times as various instance names...then i installed 2008. cleaning up some extra unneeded isntance names,

i now have the 2005 db...

i must have tunnel vision this morning;

i didn't see any BULK insert scripts for the files; after downloading the csv files, i see they are UNIX style(slash r for the...

there is a default collation at the database level, which you can see in sys.databases.

collation is not at the table level, but for each individual column. the value is visible...

first, you should never store dates as any datatype except datetime.

fix it now so you don't have the same issue in the future; if it's stored as a date,...

i believe the setting "Generate Scripts For Dependant Objects" is True on one machine, but not the other.

Tools>>Options in SSMS, then you have to find the node "SQL Server Object...

I know that when you look at sys.triggers and the db_id is zero, it's because it is a Logon Audit trigger, so it's not associated to a specific database, but...

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...