Viewing 15 posts - 1 through 15 (of 171 total)
An example of the the code I'm running is as follows:
XCOPY D:\SQL_Data\MSSQL\DocumentsBackup\* \\Documents\Backups /D /I /S /C /Y
Thank you
May 28, 2019 at 9:48 am
October 8, 2018 at 4:23 am
Steve Jones - SSC Editor - Monday, September 10, 2018 8:07 AMMoving the authorization to a new user works.
Thank you for the...
September 17, 2018 at 3:46 am
August 6, 2018 at 5:24 am
August 3, 2018 at 6:05 am
So how and what exactly is this agent job doing? From what you...
July 18, 2018 at 9:29 am
SGT_squeequal - Thursday, July 12, 2018 2:59 AMselect user_name(objectproperty(object_id,'OwnerId')), * from sys.objects
where user_name(objectproperty(object_id,'OwnerId'))=' user here'
Is there a way of finding out schema...
July 12, 2018 at 3:43 am
thank you for your reply!
The script is something like:
CREATE PROCEDURE employeeinfo
AS
emaployeeid INT = NULL
select employeename, id FROM Employee
where...
July 3, 2018 at 1:55 am
Thank you for your reply! the script and table definitions are as follows:
SELECT b.time*1.0 credit, 0.0 credits,b.Id, b.date
FROMstaff b
INNER JOIN emp e...
June 28, 2018 at 4:33 am
Thank you for your reply. I wanted to know if there is an implication in stopping the job which is why I haven't stopped it.
June 25, 2018 at 2:31 am
February 23, 2018 at 2:50 am
Thank you for your reply. Regarding the use of temp table being better than table variable, is it mainly because you can only create Primary Keys and on temp tables...
February 21, 2018 at 9:17 am
February 7, 2018 at 6:20 am
Viewing 15 posts - 1 through 15 (of 171 total)