Viewing 15 posts - 3,361 through 3,375 (of 7,168 total)
Tom Van Harpen (8/17/2012)
August 20, 2012 at 1:34 pm
sage8 (8/20/2012)
This is not the database owner, another account is (but not sa).
That does not add up.
I will try to change ownership to sa.
How did it go?
August 20, 2012 at 1:03 pm
That happens when you change the db owner.
What does this return:
SELECT SUSER_SNAME(owner_sid)
FROM sys.databases
WHERE name = 'yourDatabase';
I think you'll find that it returns CUSTOMERCARE\dscott,...
August 20, 2012 at 12:36 pm
bwperrin (8/20/2012)
$src = "\\serverpath\filename"
$dst = "e:\path\filename"
Copy-item $src -destination $dst
and still...
August 20, 2012 at 11:00 am
Things are not adding up. Can you post a screenshot of what you're seeing?
August 20, 2012 at 7:58 am
sage8 (8/20/2012)
The result for:USE [your_database];
GO
SELECT SUSER_NAME(principal_id)
FROM sys.database_principals
WHERE name = 'dbo';
GO
is 'sa'
OK, that is what it should be. Nothing to be concerned about. Since...
August 20, 2012 at 6:55 am
Hello Tony, thanks for reading my article. I'll say this, in just starting out with SSIS you have a lot of ramping up to do. You'll need to cover not...
August 19, 2012 at 8:00 am
Thanks for posting back. Could you post the code that worked for you? Personally I am curious to see what finally worked but maybe others can benefit too.
August 17, 2012 at 2:52 pm
mtassin (8/17/2012)
So I'm trying to watch for new files... when I see one I kick into a For Each Loop Container that processes...
August 17, 2012 at 2:48 pm
Chuck 17099 (8/17/2012)
I have decided to use a SQL solution as it does not require any software to be installed on user workstations.
Are you sure? For the record:
If they have...
August 17, 2012 at 1:52 pm
If you're looking for LPIM on a 32-bit system enable AWE (applies to all 32-bit systems, even ones with < 4GB). Adding startup option -T845 is unnecessary on a 32-bit...
August 17, 2012 at 1:35 pm
bwperrin (8/17/2012)
Same problem for me - did you ever get this figured out?
Did you try the code I provided?
August 17, 2012 at 12:56 pm
As a side note, having your SQL Server run as a Domain Admin is quite dangerous considering you're about to open this up for users to send emails with attachments....
August 17, 2012 at 12:11 pm
dba0419 (8/17/2012)
Example:
EXEC msdb.dbo.sp_send_dbmail...
August 17, 2012 at 12:09 pm
It has nothing to do with the caller, and everything to do with the SQL Server service account. When you try using Database Mail the attachments need to be accessible...
August 17, 2012 at 11:21 am
Viewing 15 posts - 3,361 through 3,375 (of 7,168 total)