Viewing 15 posts - 871 through 885 (of 7,168 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...
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
July 17, 2013 at 5:25 pm
jjr.123 (7/14/2013)
other string variable to hold the packageName , and...
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...
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...
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...
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...
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...
July 12, 2013 at 11:40 am
MickyD (7/10/2013)
opc.three (7/10/2013)
July 12, 2013 at 8:27 am
The other option is to use dynamic SQL:
IF NOT EXISTS ( SELECT *
FROM sys.objects
...
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...
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
July 9, 2013 at 10:11 am
ApologetixFan (7/9/2013)
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...
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...
July 9, 2013 at 8:39 am
Viewing 15 posts - 871 through 885 (of 7,168 total)