Viewing 15 posts - 11,671 through 11,685 (of 13,469 total)
I didn't want to be obvious and choose Darth Maul or something; obscurity is good sometimes.
how about we go with Bill and Teds Excellent Adventures? I could dig an avatar...
February 4, 2009 at 7:26 am
the best way is to update from a list of known last names...you cannot assume that every last name that starts with mac... gets it's 4th letter capitalized...
macaroni, machiavelli are...
February 3, 2009 at 12:22 pm
i think your HOUSE_EVENT table is going to have just certain statuses that are relevent to the current status of a property...many can be ignored i assume?
correct me if i'm...
February 3, 2009 at 12:17 pm
lol...you know the answer....you'll have to add a primary key to the table
...even if nothing uses it business wise, you can add an idnetity() column, make it the primary key,a...
February 3, 2009 at 7:20 am
when you install, you have the choice on installing a default instance or a named instance
if you chose default instance, the SQL server is the name of the machine....
sqlcmd -U...
February 3, 2009 at 6:47 am
It's kind of intuitive once you understand it's just a support hierarchy.
1st level support is typically the person that answers the phone or email, but may be more customer service...
February 3, 2009 at 6:34 am
yeah, not directly configurable without turning on advanced options.
i think this is what you are after:
[font="Courier New"]
--advanced options get enabled
sp_configure 'show advanced options', 1;
GO
RECONFIGURE
GO
--'user connections' 0=unlimited,...
February 3, 2009 at 6:20 am
it's kind of easy...
in your case, you only care about the time portion of any date....not the date itself.
so you ADD the number of seconds to an arbitrary date,
then one...
February 2, 2009 at 11:26 am
i meant here on SqlServerCentral.
Teh script ssections contains thousands of script contributions to do a variety of things; there's at least half a dozen to help you scritp out your...
February 2, 2009 at 8:01 am
search the scripts section for "generate scripts"; there are plenty of examples there;
however, teh builtin stuff works great: rightclick on your db...tasks...generate scripts.
a wizard will appear and just tell it...
February 2, 2009 at 6:53 am
I've dealt with a couple of shared hosting providers.(ihostasp.net,godaddy.com)
They always give you an interface so you can run SQL statements, batches, etc...you just have to realize, in a shared...
February 1, 2009 at 9:41 pm
well, SQL servers datetime datatype is only accurate to 3 milliseconds increments...so if you try to increment by milliseconds it goes from 0,3,6,9 all the way up to 997
to preserve...
January 30, 2009 at 4:27 pm
import and export of any kind, where thru the Management Studio or SSIS, are only part of Standard,Enterprise and Develoepr editions; they are not included in the freebie versions.
your best...
January 30, 2009 at 11:30 am
going back to your specific issue....the Service Broker job can be scheduled to run every minute...
say you have a trigger that puts an event in the new Tracking table instantly...that's...
January 30, 2009 at 8:42 am
I guess you missed my point; you can have a trigger that does whatever the trigger needs to do. no problem.
but that is separate from an email notification that...
January 30, 2009 at 8:32 am
Viewing 15 posts - 11,671 through 11,685 (of 13,469 total)