Viewing 15 posts - 871 through 885 (of 7,164 total)
There is no way to "disable a database user" per se. The way i do this is to remap the User i want to "disable" to a different Login, a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 20, 2013 at 10:17 am
L' Eomot Inversé (7/17/2013)
Revenant (7/17/2013)
The Dixie Flatline (7/17/2013)
bcsims 90437 (7/17/2013)
JAZZ Master (7/17/2013)
SQLRNNR (7/17/2013)
petrifiedputrefied
purified
perforated
penetrated
defenestrated
immolated
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2013 at 5:25 pm
jjr.123 (7/14/2013)
other string variable to hold the packageName , and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 15, 2013 at 6:25 am
The Integration Services is required to be installed to get some important binaries onto the server but the service doesn't even need to even be running for you to successfully...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 15, 2013 at 5:49 am
jjr.123 (7/11/2013)
I have a master package which calls the child packages from a folder dynamically, when i tried this with execute package task inside a for each loop container...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 13, 2013 at 4:10 pm
Not sure exactly what you've got in place but I sense a bit of misunderstanding in what you're saying. When you redirect the error output from an OLE DB Destination...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 13, 2013 at 10:20 am
All Database Users will at minimum be a member of the public Role. This affords them basic permissions like connecting to the database. Now, you can grant or deny permissions...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 12, 2013 at 1:21 pm
SKKO (7/12/2013)
Thanks, but the time out is set to infinite so it should never time out.It happens less than 2 minutes into the job each time.
Are you thinking of the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 12, 2013 at 11:40 am
MickyD (7/10/2013)
opc.three (7/10/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 12, 2013 at 8:27 am
The other option is to use dynamic SQL:
IF NOT EXISTS ( SELECT *
FROM sys.objects
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 11, 2013 at 8:45 am
Is the server 64-bit? Does the server have the Excel Object Model installed either via Office or VSTO? How are you kicking off the script, in a PowerShell step-type or...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 10, 2013 at 7:55 pm
If you need this to work, you're in for a deep-dive.
Troubleshooting Kerberos Authentication problems – Name resolution issues
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2013 at 10:11 am
ApologetixFan (7/9/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2013 at 9:46 am
chauchs (7/9/2013)
Is there a way to edit the system functions?
Nope. The ability to mess with system objects was taken away in SQL 2005 because people were modifying the system in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2013 at 9:36 am
chauchs (7/9/2013)
I do not know how, I just deleted and created some other logins and it seems that...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2013 at 8:39 am
Viewing 15 posts - 871 through 885 (of 7,164 total)