Viewing 15 posts - 301 through 315 (of 472 total)
I've just tried the following (with outputs):-
xp_cmdshell 'reg query HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names'
xp_cmdshell is not recognised as an internal or external command, operable program or batch file
January 30, 2017 at 9:30 am
It certainly looks that way.
I've got domain admin access and I can run this script on every other server (this is the only server I've come across so far...
January 30, 2017 at 8:51 am
January 30, 2017 at 8:43 am
January 30, 2017 at 7:10 am
Thanks Jeff, I'll have a look at that little lot.
There will be a couple of columns I can't make deterministic due to their nature (i.e. the "Is" flags) but I...
December 21, 2016 at 2:11 am
Hi Jeff
Unless the computed columns in the table are defined as "PERSISTED", then this table is as bad or worse than using a view to create the same thing.
None of...
December 20, 2016 at 9:35 am
Another oddity, on the date dimension it's failing on a date columns that contains (funnily enough) a date.
It's a computed column in the SQL table but the cube processing...
December 16, 2016 at 6:41 am
Hi Thom
I'm referring to Cube Dimensions.
December 16, 2016 at 5:58 am
Thanks for the links, I'll go through them in details later.
We're running Visual Studio 2012 and deploying it onto a SQL 2012 box.
October 12, 2016 at 6:01 am
Apparently I'm the in-house DBA for 5 servers (out of a total of 88 instances). Biggest database is around 300GB (so far) and growing.
There isn't an "official" DBA in...
October 7, 2016 at 1:57 am
I had to remove replication completely from the publisher side and I haven't had a chance to put it back.
Apparently, according to the 3rd-party supplier, if their software sees replication...
September 14, 2016 at 1:36 am
Hi John
I didn't have a chance as we had to remove replication last week as the 3rd-party couldn't make their changes. The supplier hasn't supplied the error message and...
September 12, 2016 at 8:13 am
Hi John
It's set up for transaction replication and the command was run on the publisher.
September 12, 2016 at 7:56 am
Thanks John
It should have been (I don't remember specifying not to anywhere).
I'll double-check the scripts I've got and see if I can find anything obvious.
::edit::
I've just checked the scripts that...
September 12, 2016 at 5:52 am
Viewing 15 posts - 301 through 315 (of 472 total)