Steve Jones,
Please make an enhancement  request to make SqlDoc able to edit other extended properties.

Hi Steve,
In the interface I see and can edit MS_Description.

RG SQLDoc only displays (and updates/deletes) MS_Description extended property name.

To use DNS for the server you need to register those as SPNs as well if you want creds passed using that name to connect.

Clustering on a phone number column can introduce fragmentation as inserts are not "in order" and updates can cause page splits.

ALTER TABLE salaries ADD CONSTRAINT UN

August 20, 2018 at 5:21 pm

#2002600

@sunilkmr284,
If you are joining to other tables frequently by LeadID...

http://download.microsoft.com/download/B/4/E/B4E604D9-9D38-4BBA-A927-56E4C872E41C/SQL_Server_2014_Licensing_Guide.pdf

I you want double hops to work with Kerberos (Linked servers) you need the SPN (Service Principal Name) registered. DNS is for name resolution, a different function, so you need...

Pass the query through to SQL Server and let it find the row.

August 15, 2018 at 2:08 pm

#2001987

Or you can change the connection string for the flat file connection manager in code in you script. This example is setting the zip file connection for a load process:

I know Power BI can extract tabular data from web pages but it doesn't work on PDF. In a quick search I found Tabula

If you create a SQL Server Agent Job and make the first step executing the SSIS Package, and the execute sp the second step ths data will be loaded to...

Grant the service account SQL Server is running under adequate permissions in the folder.