Viewing 15 posts - 46 through 60 (of 122 total)
When a job is run by the SQL Server Agent it is run as this user. This means that if you are using integrated security it will take on this...
May 29, 2009 at 8:16 am
I have worked with India, Indonesia, US and Korea.
My limited observations (a couple of hundred tasks):
India - we had 5 teams I would send the same task to all...
March 25, 2009 at 8:29 am
If they are on the same or trusted domains create a domain log on for the agent of the server that is going to collect the data from the remote...
March 17, 2009 at 10:15 am
Are you running in Windows, SQL server or Mixed mode for authentication?
March 17, 2009 at 10:05 am
The next option assumine it does not have to be a .bat file is you can create a .NET program that as part of its configuration inpersonates the username and...
March 12, 2009 at 7:41 am
Are these trusted domains so you could just give authority for the SQL Server Agent user to run the file directly?
March 11, 2009 at 8:43 am
This won't qualify as a great answer but what you really want is a .Net date time picker for start and end date times. You can customize the reporting services...
March 10, 2009 at 7:38 am
What type of security are you using? What role are you in when you try to create the jobs?
If windows mode is being used are you an administrator on...
March 9, 2009 at 7:33 am
Is the database you are inserting to Binary or ASC II? I have found the removing the Force Translate is sometimes necessary to get some inserts to work. Set 65535...
March 2, 2009 at 7:25 am
It sounds to me like SQL 2005
Steps for email using DBMail
1) Go into MSDB and allow the user SQL Agent is running as to use the Database Mail Role
2)...
February 11, 2009 at 9:52 am
The easiest for me is to right click on the instance choose properties and get the name.
This will only work if sql browser service is running otherwise you will...
February 10, 2009 at 10:33 am
On our servers we create one domain admin account per sql server instance this is used to run sql server, sql server and the network location where the backups are...
February 6, 2009 at 1:44 pm
To go with the getting rid of all user you may have to run a mass kill program to get rid of the connections. I have not used to single...
February 6, 2009 at 1:32 pm
I just adjusted my test servers memory slightly below the amount it was using and noticed that it actually increased its' memory usage above the set point. Later today I'll...
January 29, 2009 at 9:29 am
Yes, one of the advantages of the 64bit environment is the extra memory at no additional Sql Server licensing cost. Have you restarted your SQL server to apply the memory...
January 29, 2009 at 8:45 am
Viewing 15 posts - 46 through 60 (of 122 total)