But thats easily fixed with smart code

If exists... and @@SERVERNAME='Production' And db_name='ProdDB'

So i would argue it all belongs in a single procedure.

like Sue_H, i would have the procedure send the email. if you are reusing the procedure elsewhere, add an optiona parameter with a default, like @sendEmailNotification int=0

it looks like...

Texas A&M University offers A bulk cleansing service you could try.

you upload a txt or csv and get back results;

you have to register/create an account, but I believe it's free.

https://geoservices.tamu.edu/Services/AddressNormalization/

i just recently did the opposite of what the OP is looking to do: i expanded all abbreviations to full words;

mine was an investigation to eliminate variations in abbreviations and...

Jeff Moden (10/18/2016)

---

Create a stored procedure to return what they want. Give them privs to run the stored procedure and have the stored procedure execute as owner. That...

Is it truely an archive database, so you can just toggle it to read only mode, or is it somewhere in between?

You could add a file group, and move...

chocthree (10/16/2016)

---

Hi all,

A newbie here wishing to ask for advice on Microsoft Business Intelligence. Hoping this is the right forum to put my questions.

I would like to learn Business Intelligence...

ismahmoud (10/13/2016)

---

i'm using this script :

select * into LinkedServer.[DB_Name].[dbo].[Table_Name] FROM Server2.[DB2_Name].[dbo].Table2_Name

but give this error:

Msg 117, Level 15, State 1, Line 1

The object name 'LinkerserverName.DB_Name.dbo.Table_Name' contains more than the maximum number...

mcfarlandparkway (10/10/2016)

---

I have two tables one is temporary and another is main dbo employee

In the main table I have added a column called fullamount. Basically this fullamount column is coming...

ok bulk has to references files ON THE SERVER or a fully qualified UNC path

so unless the SQL server is on your local machine, you need to move the...

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