if ServerA is going to issue a command(s) on serverB, psexec must be installed on ServerA

also i believe on a per user basis, you need to call psexec at...

DDL triggers are great for tracking whodunnit info, but rolling back operations can have a performance impact, as you identified.

I think using a DDL trigger to prevent index operations is...

i do something very similar, but i rename the original table just in case, along with any indexes/constraints/defaults/foreign keys.

then rename the temp table, and it's indexes/constraints/defaults/foreign keys to match the...

SQLPain (10/28/2015)

---

yeah that's true, currently I have more than 50 jobs set up on reporting server, all with funky name, don't know how to figure out which one is associated...

Sergiy (10/27/2015)

---

I would strongly recommend not to run sending emails or any other kind of external operations from a trigger.

And glitch in the functionality beyond SQL Server control may cause...

Backups occur on a per database level,...

New persopn (10/27/2015)

---

Hi All,

We are in the process of creating inventory, for that I need a query to capture the below information

HostName

InstanceName

Version

Edition

SQL Service Account

Region

Zone

Server Managed By

Storage Managed By

Backup Managed By

Type...

here's one way to do it:

since i want to find the second slash, i know i can use charindex to start at char 4 in your path.

/*

X:\folder\anotherfolder\X:\folderX:\folder\yet another folder\X:\folderX:\foldername\another folder\X:\foldernameX:\foldername\yet...

in that case, the assumptions really incorrect.

an entire SQL Service listens to a specific port; on a default instance, the default port is 1433, but, yes, it can be...

a person with db_owner on the database has the ability to backup / restore or drop the database they own.

if they drop it, they most likely would not have the...

if you have visual Studio 2012 , if you install the SSDT package from microsoft, you can create a new database project.

that has a wizard to point to a database,w...

i think you have to switch to dynamic sql for an all in one script right?

something like this?

Declare @serverID int,

@Memory int,

@Edition varchar (200),

@Version varchar (200),

@CoreCount int

select @serverID = server_id from...

DDL, sample data and expected results then?

based on some of your other posts, it looks like you are trying to script out a table definition.

take a look at my procedure i wrote in this article and...

since there's more than one row, and you only want to group on one column, you need an aggregate function;

any of these would be my first examples to see what...