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

tobypaul509 (8/23/2016)

---

What is the best tool in terms of efficiency, cost and success rate for repairing and recovering corrupt SQL 2005 database files?

I need to purchase a tool for my...

ChrisM@Work (8/23/2016)

---

JasonClark (8/23/2016)

---

Try to run the below code to prevent accidental delete:

CREATE TRIGGER [TR_ProtectCriticalTables]

ON DATABASE

FOR

DROP_TABLE

AS

DECLARE @eventData XML,

@uname NVARCHAR(50),

...

doh simple and obvious;

the database_id =2 , regardless of what database context that...

whenever the difference between estimated rows and actual rows is off by a lot(order of magnitude or more,

it usually means the statistics are out of date enough to adversely affect...

it's an easy fix.

change the NOINIT TO INIT

that is append vs create/overwrite.

mwinn (8/11/2016)

---

I have been running this Backup script for several years but yesterday I had to transfer the database...

the data is the data. don't modify the data, modify the query that is exporting to csv.

if you use SSIS, you can modify it to export everything with double...

i think you want something like this:

SELECT

'exec sp_rename ''' + QUOTENAME(Table_Name) + '.' + QUOTENAME(REPLACE(COLUMN_NAME,'''','''''')) +

''', ''' + QUOTENAME(LOWER(REPLACE(COLUMN_NAME,'''',''''''))) + ''', ' + '''COLUMN'';'

FROM

Information_Schema.[COLUMNS]

WHERE COLUMN_NAME <>...

any object name with a single quote in it needs to be escaped in a command:

exec sp_rename '[table_name].[Rec''d 2007]', '[rec''d 2007]', 'COLUMN';

TheSQLGuru (8/7/2016)

---

If you do this with a trigger, you MUST make it asynchronous!! I would either put the necessary information into a simple queue-style table or use SQL Server Service...

Does the existence of duplicates actually break anything, or is it just a cleanup task because the .net application doesn't check for duplicates before adding the data? the urgency is...

wow Line 74851

thats a huge proc to debug.

at that size, it must be doing a zillion things, that's rough.

i think it would be like this, right?

DECLARE @TermToTweak VARCHAR(30) = 'lowell@fake.com'

DECLARE @cmd VARCHAR(MAX) = 'EXECUTE AT(LinkedServer,''update P

set P.Email1 = ''' + @TermToTweak + '''

from MyDatabase.dbo.Profiles P

JOIN MyDatabase.dbo.Complaints C on...