Sue_H

Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 4,477 total)

RE: Microsoft documenation on SQL server certificate accounts and roles for auditng password change purposes

So they know nothing about this - logins, certificates, roles. I guess that's typical and indicates the value of their audits.
Try this and the section Certificate...

September 12, 2017 at 7:52 am

#1959100
RE: Issue with SQL Reporting Services. Error while performing memory shrink: System.OutOfMemoryException

It's pretty much what is listed - you ran out of memory. You get the error when SSRS is performing an operation and the memory needed is not...

September 11, 2017 at 2:43 pm

#1959031
RE: disable Guest accounts

Instead of writing your own cursor, you could just generate a script of the SQL Statements and avoid a cursor altogether. The statements give you a list...

September 11, 2017 at 11:50 am

#1958996
RE: SQL Agent Job Error - String or binary data would be truncated. [SQLSTATE 22001] (Error 8152)

Jesse McLain - Monday, September 11, 2017 9:34 AM
I'm having trouble with what seems to be this exact issue. I have a...

September 11, 2017 at 11:08 am

#1958979
RE: Not able to add SSIS Components to toolbox in SSDT 2015

SQL Espo - Monday, September 11, 2017 8:48 AM
I am unable to add components and/or data flow tasks into my SSIS Toolbox...

September 11, 2017 at 10:03 am

#1958965
RE: disable Guest accounts

You want to make sure you aren't running this in master, tempdb or msdb. You will get an error if you try to disable guest in master or...

September 11, 2017 at 9:58 am

#1958964
RE: SQL Merge Replication Error

ahsanmumtaz - Wednesday, September 6, 2017 1:20 AM
Can anyone please help me out to solve this error in SQL Server merge...

September 8, 2017 at 12:30 pm

#1958782
RE: Remote query gets killed after ten minutes

ricardo_chicas - Wednesday, September 6, 2017 3:00 PM
we will be able to test with the people at the other network until tonight,...

September 8, 2017 at 12:14 pm

#1958773
RE: default member in cascaded parameter

AntonyO - Tuesday, September 5, 2017 2:16 AM
Hi,
I have a report with 2 multivalue parameters.
For example Category and Product.
At the begining all the...

September 8, 2017 at 12:00 pm

#1958772
RE: MSDB - How to Link Steps to Jobs

rka - Thursday, September 7, 2017 5:35 PM
In dbo.sysjobhistory table, we get list of all the jobs and step execution history. But...

September 8, 2017 at 7:27 am

#1958720
RE: PL_SQL compares with T_SQL

sqlfriends - Thursday, September 7, 2017 10:27 PM
But use many dml in cursors in pl_sql caused context switch between sql engine and...

September 8, 2017 at 7:13 am

#1958718
RE: PL_SQL compares with T_SQL

SQL Server's T-SQL and Oracle's PL/SQL are extensions of standard SQL. They both have procedural methods or operators in them. Most of the database platforms have some type...

September 7, 2017 at 5:49 pm

#1958656
RE: Migration of primary server to another- logshipping

Narine M - Tuesday, September 5, 2017 2:56 AM
Hi All,
We are going to migrate the primary server from cloud to another datacenter,...

September 7, 2017 at 4:48 pm

#1958654
RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - Linked Server

TheGreenShepherd - Thursday, September 7, 2017 1:51 PM
Thanks. I'm inquiring re: trusted for delegation. As far as the security mapping goes,...

September 7, 2017 at 2:50 pm

#1958641
RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - Linked Server

TheGreenShepherd - Wednesday, September 6, 2017 2:26 PM
I'm setting up a linked server connection from SQL Server 2014 instance "301" to SQL...

September 7, 2017 at 1:02 pm

#1958630

Viewing 15 posts - 3,091 through 3,105 (of 4,477 total)