kyyo757 (3/29/2016)

---

Hello All,

I thought I'd share my solution to this problem after numerous searches on Google and not finding a solution to fit my particular needs.

Summary: We are not using...

i am actually in middle of a project where i have to do exact same thing. I am using a powershell script to copy the file and the script...

Can you please be more specific. This forum is particularly for SQL Server, does it monitor any performance related counters for SQL Server?

Sachin Nandanwar (3/23/2016)

---

Yes you can ..Google "Server side tracing in SQL Server".Place the trace script in a SQL job and schedule it and using fn_trace_gettable read the trace file to...

Easy to test, create a sql account with the policy on and type 3 bad passwords and see if it gets locked out.

When you create sql accounts and check " Enforce Passoword Policy", local windows policies on that server...

Luis Cazares (3/3/2016)

---

You can't execute a result set, you need to assign the text into a variable. Please, be very careful with SQL injection as this could be a recipe...

Luis Cazares (3/3/2016)

---

Why are you doing that when you can do this

DECLARE @templogin NVARCHAR(128);

Set @templogin='domain\user1';

exec [DBA].[dbo].[CopyAllLoginsUsers] @loginholder= @templogin;

Especially when using NVARCHAR(MAX), you're exposed to SQL injection.

Use parametrized queries whenever...

I would start updating the statistics first on subscribers.

mikeb80 (2/18/2016)

---

Hello,

The tempdb files are stored in a RamDisk. There is almost 50GB free space in this RamDisk.

However I'm not able to increase the size of the tempdb data file...

Kishore M. K. (2/17/2016)

---

Dear All,

Do we have any to tool to measure SQL Server (2012 or 2014) Performance and/or Database Performance with respect to the I/O Resource usage, Memory consumption,...

Good point, actually the...

I hate to say this but it "depends" . How is the database served to the application. Is there a single database for each client or all clients data are...

Apologies for confusion, i don't know how to draw a table here, so putting in text format. Let me put the steps that i am using:

i) I use a script...

Hugo Kornelis (2/13/2016)

---

curious_sqldba (2/12/2016)

---

I have a script which basically scripts out all the users along with permissions needed, my script will spit a script that should be executed to grant...