i was always under the impression that to downgrade, you have to uninstall and reinstall.

especially master and the hidden resource databases, which cannot be restored to any lower version service...

at my last place where we supported Oracle and SQL for an applications RDBMS, we had a specific set of rules to map equivalents structures at a table level. it...

typically, you look at at a specific table, and decide which specific columns need to be encrypted, either because they contain personally identifying information, health information, or sensitive info...

after the bcp is created, you can call 7za.exe(the command line version of 7zip) to zip the file.

if you call it from xp_cmdshell, you are limited to one...

was this a question, or were you pointing folks to the solution to an issue you encountered?

we'd need more details to really help.

my research implies it's due to bad logic in the procedure:

when i googled "sql error 3621"

this link implied that the error was returned...

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...