Viewing 15 posts - 1,351 through 1,365 (of 6,400 total)
Not much to go on.
You got your sample data, scripts and your mail routine?
But wouldn't be to tricky to write a query to build up the...
November 29, 2017 at 1:16 am
You could build a 1 node fail over cluster and install SQL as an instance, then create an availability group.
Not true HA as its 1 node, but you...
November 29, 2017 at 1:09 am
November 29, 2017 at 12:58 am
November 28, 2017 at 9:27 am
November 28, 2017 at 1:02 am
I can try it.
What if i will have a lot of records...
November 27, 2017 at 3:08 am
i have hashcode in QlikView in txt file like:
A'--$Q>F7+O/"ZC.T(3#U,;
I am trying insert this into...
November 27, 2017 at 2:16 am
You will need to token'ise the output file, something like the below to input a dynamic date and time value
C:\JobOutputFiles\DatabaseBackup_$(ESCAPE_SQUOTE(JOBID))_$(ESCAPE_SQUOTE(STEPID))_$(ESCAPE_SQUOTE(STRTDT))_$(ESCAPE_SQUOTE(STRTTM)).txt
November 26, 2017 at 11:39 pm
Yeah I don't like the drop & add server approach, seems very dirty to me, as that's used for renaming a SQL server, so having two machines named the same...
November 24, 2017 at 6:40 am
In that case I would go with the linked server method as that's technically the safest way to do 4 part naming, but again a linked server for a loopback...
November 24, 2017 at 5:53 am
The correct server name should be the NETBIOS\INSTANCE of the host machine, not the listener. As AOAG use separate instances and the Listener is just a DNS alias which controls where...
November 24, 2017 at 4:28 am
SQL can use more memory than what you set it to, as certain things like extended stored procedures, linked servers and other aspects of the service use memory outside that...
November 23, 2017 at 8:43 am
November 23, 2017 at 7:57 am
Query msdb.dbo.sysjobs and msdb.dbo.sysjobschedules to pull out the next run date and time for the copy and restore jobs, then you can see when it is going to start to...
November 23, 2017 at 4:23 am
Senchi - Thursday, November 23, 2017 12:59 AMThere is no Free Visual studio subscription. What are you talking about ?
November 23, 2017 at 2:08 am
Viewing 15 posts - 1,351 through 1,365 (of 6,400 total)