Agreed. C:\Users\username\{anything} is...

all those packages are actually stored in an[image] data type in the [msdb].[dbo].[sysssispackages] table.

you could preview them or manually convert them to xml stringsand save them to disk.

select convert(nvarchar(max),convert(varbinary(max),packagedata)) from...

your Columns table would need the column name, data type+ size and probably whether it's null/not null;

defaults and foreign keys, even when coming from our definitions table would be...

Gmail, like many other client applications, have an option to prevent images from showing unless the sender is trusted. I had to do that...

based on experience, you won't find a one-function-to-rule-them-all address cleanup. break it up into smaller pieces that complement each other.

there's too many exceptions to the patterns;

what I've done previously is...

SQL-DBA-01 (9/26/2016)

---

Hi Experts,

Wanted to know if there is there any way to have database names aliases in SQL Server?

For example, there is a database with Name: "database A". Can...

there's a neat trick using FOR XML to get a delimited list of columns.

here's a snippet i wrote that i use in a procedure to generate sample insert/update/merge statements.

it assumes...

First, use Central Management Servers or Registered Servers; that will be where you add new servers as you discover them.

That functionality is built into SQL Server Management Studio, so there's...

Besides running the script with an impersonated credential, which solves the SQL problem,i would think you need an explicit path to your sql file:

sqlcmd -S myserver -E -i "C:\Data\AutomatedScripts\DeleteRecordsTest.sql"

for a large script, you'll want to execute it via sqlcmd instead of trying to open it in SSMS and executing it.

did you try selecting from the temp table, and left joining the larger table?

from your description, it sounds like your first table is the larger table, and you inner join...

you are doing it correctly, but it depends on what is doing the presenting.

In Grid mode in Management Studio, CrLf are ignored(converted to spaces) FOR PRESENTATION ONLY, if you copy...

in general, If someone has sysadmin access, you cannot restrict access to...

when the view is actually compiled, the wild card is expanded to the list of actual column names in the compiled version of the view;that's to avoid dynamically having to...

there's a number of powershell scripts that use SMO to script out all objects as well;

you could easily set something up to call that on a regular basis.

I'll see if...