Viewing 15 posts - 1,351 through 1,365 (of 1,518 total)
Same thing with me. Because I have sysadmin privileges I never had to worry about configuring access permissions to SSIS. The issue is allowing someone else to have that access...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 12:59 pm
Thank you.
The question still remains though as to whether SSIS can be accessed through SQL auth.
The auth. mode is greyed out on my conn dialog to SSIS.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 12:45 pm
I ran the following and got what I wanted (I think, need to look more closely):
USE dbname;
EXEC sp_helprotect null, 'rolename';
Thanks!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 12:28 pm
Not clear how this works. For me, SSIS is installed on the default instance (no instance name), whereas the database engine is installed on a named instance. Could it be...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 12:21 pm
Rule of transactions: As short as possible doing just what is required. I try not to call nested procs within a transaction at all.
In our code base we do that...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 11:48 am
Jeff Moden (3/19/2008)
Heh... I'd have never known... 😉 I only use temp tables (unless it's a UDF where I can't) and haven't run into a Recompile problem yet because...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 11:15 am
What about using SQL 2000 tools to do the same thing? What system tables should I use?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 11:10 am
It only shows up as Windows Auth. ONLY, greyed out as well, for me.
I wonder if this has to do with how SSIS was installed to begin with. I forget...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 11:02 am
John Mitchell (3/19/2008)
MariosI don't have time to do it now, but it should be fairly easy to get what you want by joining sys.database_permissions to sys.database_principals.
John
Perfect, thank you, this is...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 10:57 am
I should mention, while we are on the subject, "INSERT EXEC" does work with table variables in SQL 2005!
This is something I only realized recently.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 10:38 am
TheSQLGuru (3/19/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 10:35 am
Further to Matt's point above (see http://msdn2.microsoft.com/en-us/library/ms190384.aspx):
The following stored procedure will need to be created by the table owner and the user will need to be assigned EXECUTE permissions on...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 10:17 am
OK, I hear poor old table variables sobbing in a corner somewhere, so I have to step in here... :w00t:
Table variables do cause less overhead in terms of locking, logging...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 10:04 am
Mark Kenyon (3/19/2008)
1. On the layout tab, click the properties icon
2. choose report from the drop down list
3. expand the section interactive...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 9:01 am
Todd,
Thanks so much for clarifying and for the valuable input!
There are other rendering-type capabilities in VS Report Designer, such as repeating header/footer, page breaks etc. I thought being able to...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 18, 2008 at 7:41 am
Viewing 15 posts - 1,351 through 1,365 (of 1,518 total)