Viewing 15 posts - 16 through 30 (of 97 total)
Check this link and see if any of the suggestions is helpful.
January 7, 2004 at 9:50 am
I ran your code on several test machines but could not replicate the error. Could you confirm how you are executing the code? QA or a stored procedure?
January 7, 2004 at 9:12 am
I think they are two separate issues. The job owner (for a scheduled DTS package) needs to have sysadmin rights to ba able to execute CmdExec. You could also set...
January 7, 2004 at 8:46 am
No, I don't think so. The SendMail task uses whatever email profile is available on the computer on which the DTS package is run. For instance, if you run the...
January 7, 2004 at 8:21 am
Yes you are correct. If you right click SQL Server Agent in EM and select Properties, Job System. You'll see where you can set the proxy account to use for...
January 6, 2004 at 4:41 pm
You probably do not have the privilege to execute jobs on the server. Change the resulting job ownership to a login that has execute job permission after you schedule the...
January 6, 2004 at 3:24 pm
I would suggest you do this after you run your backup. You could also issue the CHECKPOINT command before you perform the delete action. I don't think you run any...
January 6, 2004 at 3:18 pm
There are more than one way to skin a cat. One solution in this case is to use ActiveX, open the Excel spreadsheet and remove all the data at the...
January 6, 2004 at 3:12 pm
I don't know if there is a TSQL statement to do this but in EM right click on the database, properties, transaction log. Highlight the second log file and hit...
January 6, 2004 at 3:06 pm
When you schedule a DTS package from the DTS Package Designer, the resulting job is owned by the login with which you signed into SQL Server. The job will be...
January 6, 2004 at 2:52 pm
You'll need MULTIPHASE DATA PUMP to achieve this.
January 6, 2004 at 11:32 am
1. Check this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_2_90hl.asp
2. Make sure MSDTC service is running.
January 6, 2004 at 10:29 am
This is because the DB users are stored in the sysusers table in each user DB whereas the login info is stored in the master DB so when you restored the...
January 6, 2004 at 10:23 am
Have you removed the BUILTIN\Administrators login? Did you add the domain admin user to the Server Admin fixed server role on the SQL Server? Is the domain admin user identified...
January 6, 2004 at 9:45 am
From BOL:
<Quote>
The WHERE and HAVING clauses in a SELECT statement control the rows from the source tables that are used to build the result set. WHERE and HAVING are filters....
January 6, 2004 at 9:04 am
Viewing 15 posts - 16 through 30 (of 97 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy