have you considered just reducing permissions?

I'm not sure if this is possible

you might be able to use a database trigger, but I've not seen it done before

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-trigger-transact-sql?view=sql-server-ver15

not even sure that altering a file size is...

My prediction is that for the first five years or so, the software driving driver-less cars will play it safe and come to a complete stop when confronted with...

i'm going to try all the suggestions and see what works (when my hands get warm it's still snowing here)

Hahaha, had an upgrade weekend myself. Things went fairly smoothly, other than timing being WAY off from estimated and me validating tables in the back of a bowling alley...

Legitimate question, this book was written for 2008 and 2008 R2, how much of the information in there is still relevant, even in the introduction to the book...

would that be a company that labels...

yeah - data splits on 1000 potential fields, bad use of loops or functions. at least with a TVP you can just do an inner join on syscolumns before you...

and don't ask why we want to choose the columns in sql - I suggested doing a "select as many as you need" and use a show/hide property in the...

It honestly terrifies me how...

going back to the original topic - are the questions getting stupider

i got asked if this represents a sql injection risk 🙁

shall we ask if bob can...

good of you to post us your update

you should have a quick look at Grant Fritchey's site - he despises profiler traces and loves XE

https://www.scarydba.com/2020/02/03/profiler-time-to-go/

you might pick up a few...

a few years ago, I encountered an issue for a large retail company. Every single point of sale system stopped. the issue was that they had cloned the deployment server...

you don't need the select

example

INSERT INTO Customer (FirstName, LastName, City, Country, Phone)

VALUES ('Craig', 'Smith', 'New York', 'USA', 1-01-993 2800)

Dino - all good points.....but

i can't see how you can...