Specify the account 'sa' when you create the job step that runs the CMD job. From BOL:[@database_user_name =] 'user'Is the name of the user account to use when executing a TSQL step. user is sysname, with a default of NULL. When user is NULL, the step runs in the job owner's user context on database.
2005-02-11
Thanks all! I shall check the answers in a second... just to clarify the requirement....--------------------------------------------------------------I understand your requirement as follows.--You wanted to delete all records having the "memberofgroup" field's value as 15. --You wanted to update the END-DATe to the maximum END-DATE possessed by any record whose memberofgroup is non 15.--I dont find the end […]
2005-02-02
Here's an expanded example showing how you could insert rows into a new table while parsing, or update existing rows with the parsed data.DROP TABLE SlowThinker GO DROP TABLE TheData GOCREATE TABLE SlowThinker ( id int PRIMARY KEY, ExData varchar(100) )CREATE TABLE TheData ( id int PRIMARY KEY, Col1 varchar(100), […]
2005-01-03
Yes. It's better to have multiple data files then a single file because SQL Server creates a backup thread for each file that is being backed up.If you already have a big file and you add another file, SQL Server will distribute the data to both files if both file size is set to unlimited. If […]
2004-12-23
SQL Server & AD in Windows Server 2003 We are going to upgrade our server (PDC) from NT 4.0 to Windows Server 2003. The new forest will involve several domains and different sites between Boston, NJ, NH and PA. Does anyone have knowledge of impact if we add SQL Server into new Active Directory in Windows […]
2004-11-22
1 reads
Thanks. The DSN entry worked for other XP clients but not for my PC, which seems to be related to how my machine was originally built. Its a little off subject but do you know of any configuration that would not allow for dynamic port connection? If I set up an ODBC entry and specify port […]
2004-10-12
I have a feeling that I have confused you. When I say that you will be scheduling a task. I mean that you use Windows scheduler on the server to schedule the task not SQL server job scheduler..... when you create the scheduled job on the server (not in SQL). That is where you use […]
2004-10-06
We've been able to tie this to outlandish queries that run with thousands of items in an WHERE IN () list.Sound reasonable.
2004-09-28
I hope some will respond as well. I'm sure someone else has been through this. Also, I have used exec sp_change_users_login with the 'auto_fix' option to fix my NT authentication logins in the past as well, in this case, it did not work. I found this article that helped me work around it.. worth bookmarking […]
2004-09-17
First a tutorial on how Windows Authentication works. A user logs into his/her computer. That computer is part of a domain and the user's login is authenticated by the domain controller. Then when they connect to SQL Server on the same domain, the domain controller still recognizes their login credentials. But if SQL Server is […]
2004-09-17
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers