Pearl I'm using the exact same code in a scheduled job every day;the job captures the current wait stats, then resets them with the dbcc perf command;

i'm thinking that over...

if you don't want to browse the scripts section i mentioned, the easiest way is to use SSMS: In SSMS2012, make sure the scripting option for script indexes is true...

just a list of indexes, or the scripts for the indexes?

just the list:

select * from sys.indexes where object_name(object_id) = 'EDLogDetail'

scripting the indexes is a little harder, there's a lot of...

a part of the issue is probably memory management; i've been spoiled by the .Nets frameworks' garbage collection.

i see that PowerShell 2.0 had a problem with that, and explains...

if you are excluding two specific values:

WHERE ANI NOT IN('614xxxxxxx''614yyyyyyy' ) but that doesn't prevent 614aaaaaaa for example.

if you wanted to guarantee no alphanumerics(becauese people are lazily putting in repeating...

find and replace, in a proper text editor, because you would visually confirm each change, is absolutely the way to go.

a blanket find and replace is not going to be...

Basically its a find and replace operation... you can select definition from sys.sql_modules to get the CREATE PROC statements but you need to change it to alter and add with...

gfoulks (3/12/2014)

---

okay so the table in question has the following columns

DateTime

Acct_Number

SSN

Script_Code

Div_indicator

first_name

last_name

ani

terminate_area

transfer_area

Periodically we are getting records in this table where ani = 614xxxxxxx

We want to prevent all records with the ani...

gfoulks (3/12/2014)

---

Hello,

I've searched the internet looking for examples of a instead of trigger that I would like to setup but I've not been able to find anything that would really...

I think error " The server response was: 5.7.1 Client does not have permissions to send as this sender" is related to a specific mail setting; that is, using account...

vmoreau (3/11/2014)

---

Hi,

In a SQL 2018 database I need to fix some data in a huge common table that is referenced by FK across lots of other huge table in the...

well i went to the link provided, and have no ida what data you want to capture; i'd guess it's the short blurbs ont he left of the page?

whatever that...

i chose None of the above, because the AD group does not have the domain in the command, making it invalid.

--no such user or role

/*

Msg 15151, Level 16, State 1,...

thank's guys; that's the path i'm going down now...multiple for loops.; i'd do it differently in c# or vb.net,

SSIS for me is a middle layer of complexity inserted...

Thanks for looking Koen!

what i mean, is, say you have a folder of files, some file names contain "_Product_" in their names, others contain "_Patient_" or "_Sections_" in their names.

there's...