Viewing 9 posts - 1 through 9 (of 9 total)
As my knowledge goes, you cannot assign permissins to individual logins to execute a package. Instead, create the package with a User password. And anyone who needs to execute this...
November 29, 2004 at 3:41 am
No, to run a trace the sysadmin previliges are required.
To give it a try, I just create a new login on my server and added it only to the 'processadmin'...
May 13, 2004 at 5:08 am
Following is the excerpt from BOL -
If an object is not qualified with the object owner when it is referenced (for example, my_table instead of owner.my_table), SQL Server looks for...
May 13, 2004 at 4:27 am
This might be a possibility .... The Registration properties for the server in EM might have been changed from 'Windows Authentication' to 'SQL Sever Authentication'.
If so then, just edit the...
May 7, 2004 at 1:31 am
This might be a possibility .... The Registration properties for the server in EM might have been changed from 'Windows Authentication' to 'SQL Sever Authentication'.
If so then, just edit the...
May 7, 2004 at 1:29 am
Hi,
I also think that the DTS package is a cool way to accomplish the pulling of data into a flat file
- Vani.
May 5, 2004 at 1:05 am
By saying that user accounts have been set up, do you mean that the account has been added as a user in the databases?
If that is the only step...
May 4, 2004 at 12:34 am
The Transaction log gets truncated when a check point occurs only if the "Trunc. log on chkpt." option on the database is set. If this option for the database is...
April 6, 2004 at 3:25 am
To find out indexes on a table, it would be easy to run the T-SQL satement from Query Analyser
sp_helpindex <table_name>
eg: sp_helpindex syscolumns ---> will list all the indexes on the table...
March 25, 2004 at 12:07 am
Viewing 9 posts - 1 through 9 (of 9 total)