I modified the owner of the job in EM, general tab, owner drop down. However, it is still being executed by a different user. So how can I configure...
Hi folks, I'm cleaning up temp tables that I have started creating back in 2002 to present. However, I don't remember anymore if it's mine or not. I...
The printer was created under my username. The service account is a member of administrator. I'm thinking that the service account is not seeing the...
Hi folks, We have a DTS job that data pulled from MSSQL to a printer. When I run the job myself, it prints out. But when I schedule the job, it...
Is MSSQL 2000 stable on Advanced Windows 2003 operating system? Has someone done it? Are there things that needs to be done on the 2003 operating...
ok folks, we can't figure out what's wrong. Our programmer built an MS Access application and it connects to an MSSQL server on the same segment....
Ok folks, I don't know if this is the right forum. We have an MSSQL cluster. Then we also have a webserver running on IIS5 on Windows 2000. Everytime...
I was able to work around my 40 min running query. It is now down to 8mins. I think that is good enough for pulling 2.4 million records. I placed...
Here is another one but SET SHOWPLAN_ALL ON http://www.nopaste.com/p/aWXeFrf5A
This is what I got. I used -> SET SHOWPLAN_TEXT ON http://www.nopaste.com/p/azSdFNWu5
Did you mean loannumber column? EDIT: I did an sp_help and this is what I got: Loan_LoanKey_U_Cidxclustered located on PRIMARYLoanKey...
Hi folks, I don't know if it should be posted here. Here is the exec plan http://img254.imageshack.us/img254/2479/execplanyy5.gif The WHERE...
This is great info. <img src='/community/emoticons/emotion-1.gif' alt=':)' />
Thanks guys for the advice. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />I really appreciate it!!!
Also, addtitional info, domain will still be the same.
hey folks, We have a DR server with 2 nodes on a cluster. We need to move it to a different state(IL to CA) due to the colo being closed here in IL....
Thanks Mohammed! <img src='/community/emoticons/emotion-1.gif' alt=':)' />
We have DTS packages running on SQL2000. There are plans of moving to SQL2005. Do we have to convert our old DTS package so that it will work with...
Here is what I did: select loanno, client, datalength(comment) as commentlen into temptable from sourcetable Then I displayed the result and I have...
and also, can someone please post a code that will prepend a string to an existing string on a TEXT field? Before on a varchar declared field, I...
Separate names with a comma.
