Viewing 15 posts - 526 through 540 (of 13,463 total)
Like Sue suggested, i use Powershell, as a scheduled job step to remove any abf files older than x number of days.
not sure how you are backing up, in...
May 9, 2017 at 12:11 pm
is there any chance that when you installed Developer2016, you didn't install Integration Services? this screenshot shows the checkbox unchecked; i'd suspect that that might be issue. SSDT is the...
May 9, 2017 at 11:43 am
sounds like an order-of operations issue, right? insert into the parent tables, first, then move on to the tables that are FK'd to the tables.
the built in microsoft procedure...
May 9, 2017 at 11:11 am
you are probably looking to move an object to the other schema. THERE ALTER SCHEMA command lets you move a schemaname.object name into a specific schema.
if i "develop"...
May 9, 2017 at 11:03 am
not sure if it is related, but back when i had 2008/R2 instances, i had the built in procedure sp_spaceused return the same error, because i had some very large...
May 8, 2017 at 12:00 pm
Just checking the basics, but is there any chance that the server you are connecting to is an Express instance, and not Developer/Standard/Enterprise?
If it were express, I'd expect a...
May 8, 2017 at 11:47 am
he said he is getting this error:
login field login for 'sa' (microsoft sql server , error:18456)
that means he's successfully connected to an instance.
so that...
May 6, 2017 at 7:39 pm
Luis you posted your solution between the time i looked again; your's works as well, thank you!
May 4, 2017 at 11:54 am
OK walking away and doing a mental reset let me see my issue, or at least come up with a working solution
i *think* i had two things going on.
May 4, 2017 at 11:51 am
it could also be nested permissions in Active Directory too.
So The users in [OURDOMAIN\SomeUsers] Are in [OURDOMAIN\BusinessAnalysts], and [OURDOMAIN\BusinessAnalysts] was explicitly granted access.
May 2, 2017 at 3:21 pm
check that login's default database.
see if the database has been dropped/removed, or the user no longer has access to that database. in those cases, setting the default database to...
May 2, 2017 at 3:16 pm
SSRS is a little wierd, you have to assign permissions in two places, at the site, and at the root folder, the screenshot here is from an older verison, but...
May 2, 2017 at 7:43 am
view server state? i guess you are trying to select info about the connection from sys.dm_exec_connections
stick with what i said, either sign the trigger or use EXECUTE AS...
April 30, 2017 at 4:35 pm
the trigger is probably inserting into an audit table, right? and a normal end user does not have access to that table; it might be sending an email, or something...
April 28, 2017 at 8:33 am
correction: the above uses a simpler cmdexec instead of powershell to call robocopy or the DEL command. same thing, different island.
April 27, 2017 at 2:32 pm
Viewing 15 posts - 526 through 540 (of 13,463 total)