Viewing 15 posts - 2,206 through 2,220 (of 13,469 total)
CliffordPreston (9/23/2014)
September 23, 2014 at 10:17 am
what error are you getting? not working is a pretty wide net to cast.
do you get an error stating the database needs to be set to trustworthy?
is the new server...
September 23, 2014 at 8:08 am
assuming your Transactions table has a column named [TransactionDate], and that date represents the date you are looking for, this query will
get all transactions from midnight until the second...
September 22, 2014 at 8:55 am
Visual Studio can create a cache file for reports , so it skips getting the data from the server during a report preview. if the data changed, or the cache...
September 22, 2014 at 7:40 am
additionally, how about a scheduled job that looks for more than one post per second per user, and deletes the ones that were spammed based on that criteria?
September 21, 2014 at 7:47 pm
phingers (9/19/2014)
The db mail idea is good, although in the same way as disabling the...
September 19, 2014 at 5:06 am
i had to do something similar, where the Visual Studio Project was deleted on a developers machine. The RDL's and all the data sources etc are stored in the...
September 18, 2014 at 2:33 pm
well i know how to get the order of dependencies : if you limit the results to just Tables, that is the order of foreign key hierarchys...but then you have...
September 10, 2014 at 5:52 am
my powershells cript has similarities, butis a little different on that like for .Fill;
i don't have void or[void] anywhere.
i'm also filling a dataset, and not a datatable.
$SQLDataSet = New-Object System.Data.DataSet;
$SqlDataAdapter.Fill($SQLDataSet,...
September 9, 2014 at 11:30 am
since it's a named instance, i think it might be a SQL express instance...which has TCP/IP disabled by default.
do you know if it's an express instance?
if it is, first you...
September 4, 2014 at 1:35 pm
i use CLR extensively, and for a lot of different reasons.
Here's a list of the things i use it for:
Exporting a query to disk: TXT/CSV/TSV/RTF/HTML/DOC/XLS/More format's than you care to...
September 4, 2014 at 12:35 pm
that's a "feature" of procedures, with deferred name resolution.
there's no way to turn it off, unfortunately, as it would be very valuable to be able to do that in some...
August 28, 2014 at 5:44 am
take a look at this thread, where we did some analysis a while back;
i threw a SQL CLR function out, that seemed to do pretty well performance wise, that leverages...
August 27, 2014 at 2:50 pm
you can stop the SQL 2012 service and find the mdf and ldf files for the database(s) in question.
copy them to the new server and use the Attach method:

August 26, 2014 at 12:48 pm
correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:
so C:\CambridgePubs.xlsx would...
August 25, 2014 at 10:46 am
Viewing 15 posts - 2,206 through 2,220 (of 13,469 total)