also how many VLF's are there?

run DBCC LOGINFO on your Sharepoint database; you might need to reduce them.

http://blogs.msdn.com/b/saponsqlserver/archive/2012/02/22/too-many-virtual-log-files-vlfs-can-cause-slow-database-recovery.aspx

kevaburg (3/16/2015)

---

roger.price-1150775 (3/16/2015)

---

Not seen SQL call Powershell but seen lots of powershell scripts calling SQL.

Why are you renaming the files ?

If it's to ensure a file is only processed once...

as far as i know sp_send_DbMail requires email addresses int he correct format; it will not work with an operator name.

all my SQLAgent my operators point to sqlAlerts@mydomain.com, which is...

i beleive groups are a function of the mails erver, which generates individual copies of the email to people assinged tot eh group that the smtp alias points to;

i know...

also

b.field1 LIKE 'ABC'

is exactly the same as

b.field1 = 'ABC'

maybe you meant

b.field1 LIKE 'ABC%' --starts with

or

b.field1 LIKE '%ABC%' --contains

my knee jerk reaction would be to handle nulls for inequalities and exists, like this...

does this get expected data with this change?

WHERE

b.field1 LIKE 'ABC'

AND b.field2 BETWEEN GETDATE() -...

do any of those fields have nulls in them?

i think the "not in" portions can doink things up, right?

OR {NULL} NOT IN ('1', '2', '7', 'B')

...

OR {NULL}NOT IN ('CO','LT','B7')

that string is the base64 conversion of some string or value; i recongnize the format and the double equal signs at the end.

i tried running it through an online decoder...

i don't know how others do it, but i have a few tables i use for replacements;a table with random values and numbers, another with ANSI colors, another with...

i think you just have to open each datasource in the web client and review it to see if it is using ORAOLEDB.Oracle, or ORAOLEDB.Oracle.1 right? how many unique...

this gives you the name of the report + name of the shared data source;

if your reports have embedded data sources, i think you have to open each report.

from there,...

Khades i tried with a user defined function as the default as wlel, doesn't work;

i think you're stuck with adding an trigger for insert in order to get your default...

there is no ability to directly render as any format (ie $renderAsWORD) from within SQL server; those functionalite are all possible with an exdtrnal resource.

you can do html, fixed...

do you mean dynamically select a query and result set, and use SSRS to export it to doc/docX? if that's the question, i don't believe you can. i'm awful sure...

if the service is running, it's not possible to delete the master database either accidentally or on purpose; it has a file lock on it by the SQL Service.

if the...