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

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