Hi John,

Thanks for the help.

How to find that group.

We have a login name proddba. So I enter

exec xp_loginfo 'domainname\proddba', 'all'

Is that group is different? I am thinking that...

It is throwing error with the msg invalid parameter

Is it possible that to find a particular login belongs to which group?

I can see a login created with windows authentication in server A. I am not sure is it...

Hi,

I want to stop the running trace.

I run the command

exec sp_trace_setstatus 2,2 (My trace id=2)

Then I am getting the msg that, the active trace must be stopped before modification.

How...

so if we want to use this option

"Be made using the login's current security context"

The same login has to exists on both servers, server A and server B

Thank you.

Before you script the trace definition, we have to run the profiler. So there we are giving one filename. When I use the same trace file name, it wasn't...

Thank you

In my running trace I can see

exec sp_trace_setstatus @TraceID,1.

In final it showed me TraceID=3

So if I run

EXEC sp_trace_setstatus 3, 2

It will stop the trace

If we start the serverside trace how to stop that.

I open the profiler through GUI and script out the definition and run from ssms but forgot to mention the stop...

Hi,

The job is running fine in SSMS 2012. It is failing in 2008 R2 & 2014.

When I run the job in 2014 it is throwing error

code:0*00000005

Source: script1

Description: Failed to compiled...

Hi Eirikur,

I downloaded the the SQL Server data tools from the link you provided and try to run on the remote desktop where the Sql 2014 installed but there is...

Thank You

Hi Errikson,

I can't install the 2012 SSIS components on the system. I want to upgrade the 2012 packages to 2014. For the upgrade, 2014 SSDT must be used.

How can...

No SSIS 2012 is in different machine. In present box SQL 2008 R2 & Sql 2014 is running.

I selected the Integration services features while the installation of Sql 2014...

Why it won't come with the installation of Sql?

Thank you