Viewing 15 posts - 2,161 through 2,175 (of 2,648 total)
In my current (and some of the previous) company we definitely have audit controls.
Not in all systems (yet) but at least on the core ones.
so every time someone...
November 11, 2018 at 12:09 pm
similar results for me
As the results I had given before only related to the date part I've also run your code with just the date bit.
and also...
November 10, 2018 at 2:06 pm
November 10, 2018 at 12:51 pm
November 10, 2018 at 12:37 pm
Jeff Moden - Saturday, November 10, 2018 11:30 AMThanks, Frederico. Time for some play.
just in case having a single value was an...
November 10, 2018 at 12:34 pm
November 10, 2018 at 12:31 pm
November 10, 2018 at 11:03 am
Cool. The only thing is that I try to avoid trips through...
November 10, 2018 at 10:36 am
one other option (and there are more)
declare @tbl table
( juldate decimal(18, 0)
, timei float
)
insert into @tbl select 118063, 11456
insert...
November 10, 2018 at 9:31 am
November 10, 2018 at 8:09 am
Error looks quite clear.
----------
Could not use view or function 'InvoiceTotals' because of binding errors.
----------
one of your view is invalid because the underlying objects changed ...
November 7, 2018 at 8:47 pm
not quite
is_linked = 0 - reports the instance settings
is_linked = 1 - reports the specific linked server settings
Having the instance rpc_out enabled does not enable it...
November 7, 2018 at 4:47 am
select name, is_rpc_out_enabled
from sys.servers
where is_linked = 1
if is_linked = 0 that is the instance itself
November 7, 2018 at 4:28 am
not with standard SSIS methods
Depending on the file you can however use a C# script to parse the file and create the table yourself.
With bulk insert (T-SQL)...
November 6, 2018 at 5:39 pm
I've seen this happen before - on 2008 R2.
It was possible to generate the table and the index, but the filter definition would not be generated depending on the...
November 6, 2018 at 2:43 pm
Viewing 15 posts - 2,161 through 2,175 (of 2,648 total)