Sue_H

Forum Replies Created

Viewing 15 posts - 3,751 through 3,765 (of 4,477 total)

RE: Analysis Services on SQL SERVER 2014

zouzou - Tuesday, April 4, 2017 4:39 AM
Yes the service is running and i did try with IP and port number but...

April 4, 2017 at 6:10 am

#1936502
RE: Analysis Services on SQL SERVER 2014

Did you check if the service is running? Are the firewall ports open? Is the browser service running?
You might also want to see if you can connect...

April 3, 2017 at 11:18 am

#1936365
RE: Extract all email subscription

lhynlen - Monday, April 3, 2017 10:54 AM
Thanks for your response. How can i implement this? I only have permission to view...

April 3, 2017 at 11:10 am

#1936363
RE: Transaction Log filling, and the proper response

By default, tempdb is in simple recovery mode already. I may be wrong but I thought that a checkpoint would be done by the system if the log is...

April 3, 2017 at 10:59 am

#1936359
RE: Extract all email subscription

lhynlen - Monday, April 3, 2017 9:25 AM
Is there a way that you can extract all email subscription in SSRS without admin...

April 3, 2017 at 10:41 am

#1936353
RE: Log shipping error: server not found

dopydb - Monday, April 3, 2017 7:34 AM
hi Sue
thanks for this, cant remeber the server ever being 004, must have been done...

April 3, 2017 at 7:51 am

#1936285
RE: Log shipping error: server not found

I just found this and it's probably a better article to read about this issue - has more details on different scenarios, issues:
Rename a Computer...

April 3, 2017 at 7:27 am

#1936277
RE: Log shipping error: server not found

dopydb - Monday, April 3, 2017 7:07 AM
hi
i am trying to get log shiping setup on one of our servers, but when...

April 3, 2017 at 7:25 am

#1936274
RE: SQL Server Multi Administration Job not appearing on target server inquiry

yhandz_21 - Sunday, April 2, 2017 8:34 PM
yes thanks for that it worked after sp_resync_targetserver 'YourTargetServer' but just want to...

April 3, 2017 at 6:37 am

#1936252
RE: Compilation lock and blocking

Robin35 - Saturday, April 1, 2017 5:37 PM
Sue_H - Saturday, April 1, 2017 1:37 PM

April 2, 2017 at 8:20 am

#1936174
RE: FTP Connection Manager would not connect

Diske - Saturday, April 1, 2017 1:49 PM
We tried. Rebooted, new projects, one default package only with the connection manager. Even tried...

April 1, 2017 at 2:58 pm

#1936128
Reply To: DTS and Primary Keys
You can insert identity values that are gaps which don't exist in the table using identity_insert on. Once identity_insert is off, it goes back to using the value you...
- This reply was modified 6 years, 6 months ago by Sue_H.
- This reply was modified 6 years, 4 months ago by Dave Convery.
April 1, 2017 at 2:45 pm

#1936127
RE: SQL Server Multi Administration Job not appearing on target server inquiry

They get blocked sometimes for different reasons - you don't get an error but you will see the Normal|Blocked status.
On the master, you could try executing:...

April 1, 2017 at 2:25 pm

#1936126
RE: Compilation lock and blocking

You can capture the reasons for recompilation using extended events or profiler.
With extended events, you would want the event sqlserver.sql_statement_recompile.
With profiler, SP:Recompile event gives the...

April 1, 2017 at 1:37 pm

#1936123
RE: Grant Execute Permission on sp_audit_write

That is odd. I checked on a new 2014 instance and it was the same for whatever reason. Docs say public has permission but it doesn't. Was able...

April 1, 2017 at 1:32 pm

#1936122

Viewing 15 posts - 3,751 through 3,765 (of 4,477 total)